Invalid XML elements found inside sync block
-
Hey all I'm trying to create a template for use in SQLXML IIS virtual directories and I am receiving this error:
<?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="Invalid XML elements found inside sync block"?>
I am very new to XML and SQL, so any advice would be great, thanks for the help
below is the entire updategram...
Pat
Now, I working with a table that has 80 columns, so this is nasty:
<?xml version="1.0" encoding="UTF-8"?>
<
iv00101insert xmlns:updg="urn:schemas-microsoft-com:xml-updategram" xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<updg:sync>
<updg:header>
<updg:param name="ITEMNMBR"/>
<updg:param name="ITEMDESC "/>
<updg:param name="NOTEINDX"/>
<updg:param name="ITMSHNAM"/>
<updg:param name="ITEMTYPE"/>
<updg:param name="ITMGEDESC"/>
<updg:param name="STNDCOST"/>
<updg:param name="CURRCOST"/>
<updg:param name="ITEMSHWT"/>
<updg:param name="DECPLQTY"/>
<updg:param name="DECPLCUR"/>
<updg:param name="ITMTSHID "/>
<updg:param name="TAXOPTNS"/>
<updg:param name="IVIVINDX"/>
<updg:param name="IVIVOFIX"/>
<updg:param name="IVCOGSIX"/>
<updg:param name="IVSLSIDX"/>
<updg:param name="IVSLDSIX"/>
<updg:param name="IVSLRNIX"/>
<updg:param name="IVINUSIX"/>
<updg:param name="IVINSVIX"/>
<updg:param name="IVDMGIDX"/>
<updg:param name="IVVARIDX"/>
<updg:param name="DPSHPIDX"/>
<updg:param name="PURPVIDX"/>
<updg:param name="UPPVIDX"/>
<updg:param name="IVRETIDX"/>
<updg:param name="ASMVRIDX"/>
<updg:param name="ITMCLSCD"/>
<updg:param name="ITMTRKOP"/>
<updg:param name="LOTTYPE"/>
<updg:param name="KPERHIST"/>
<updg:param name="KPTRXHST"/>
<updg:param name="KPCALHST"/>
<updg:param name="KPDSTHST"/>
<updg:param name="ALWBKORD"/>
<updg:param name="VCTNMTHD"/>
<updg:param name="UOMSCHDL"/>
<updg:param name="ALTITEM1"/>
<updg:param name="ALTITEM2"/>
<updg:param name="USCATVLS_1"/>
<updg:param name="USCATVLS_2"/>
<updg:param name="USCATVLS_3"/>
<updg:param name="USCATVLS_4"/>
<updg:param name="USCATVLS_5"/>
<updg:param name="USCATVLS_6"/>
<updg:param name="MSTRCDTY"/>
<updg:param name="MODIFDT"/>
<updg:param name="CREATDDT"/>
<updg:param name="WRNTYDYS"/>
<updg:param name="PRCLEVEL"/>
<updg:param name="LOCNCODE"/>
<updg:param name="PINFLIDX"/>
<updg:param name="PURMCIDX"/>
<updg:param name="IVINFIDX"/>
<updg:param name="INVMCIDX"/>
<updg:param name="CGSINFLX"/>
<updg:param name="CGSMCIDX"/>
<updg:param name="ITEMCODE"/>
<updg:param name="TCC"/>
<updg:param name="PriceGroup"/>
<updg:param name="PRICMTHD"/>
<updg:param name="PRCHSUOM"/>
<updg:param name="SELNGUOM"/>
<updg:param name="KTACCTSR"/>
<updg:param name="LASTGENSN"/>
<updg:param name="ABCCODE"/>
<updg:param name="Revalue_Inventory"/>
<updg:param name="Tolerance_Percentage"/>
<updg:param name="Purchase_Item_Tax_Schedu"/>
<updg:param name="Purchase_Tax_Options"/>
<updg:param name="ITMPLNNNGTYP"/>
<updg:param name="STTSTCLVLPRCNTG"/>
<updg:param name="CNTRYORGN"/>
<updg:param name="DEX_ROW_ID"/>
</updg:header>
<updg:before>
</updg:before>
<updg:after>
<IV00101
ITEMNMBR
="$ITEMNMBR"
ITEMDESC="$ITEMDESC "
NOTEINDX
="$NOTEINDX"
ITMSHNAM="$ITMSHNAM"
ITEMTYPE="$ITEMTYPE"
ITMGEDSC="$ITMGEDESC"
STNDCOST="$STNDCOST"
CURRCOST
="$CURRCOST"
ITEMSHWT="$ITEMSHWT"
DECPLQTY="$DECPLQTY"
DECPLCUR="$DECPLCUR"
ITMTSHID
="$ITMTSHID "
TAXOPTNS="$TAXOPTNS"
IVIVINDX
="$IVIVINDX"
IVIVOFIX
="$IVIVOFIX"
IVCOGSIX
="$IVCOGSIX"
IVSLSIDX
="$IVSLSIDX"
IVSLDSIX
="$IVSLDSIX"
IVSLRNIX
="$IVSLRNIX"
IVINUSIX="$IVINUSIX"
IVINSVIX
="$IVINSVIX"
IVDMGIDX
="$IVDMGIDX"
IVVARIDX="$IVVARIDX"
DPSHPIDX="$DPSHPIDX"
PURPVIDX="$PURPVIDX"
UPPVIDX="$UPPVIDX"
IVRETIDX
="$IVRETIDX"
ASMVRIDX="$ASMVRIDX"
ITMCLSCD="$ITMCLSCD"
ITMTRKOP="$ITMTRKOP"
LOTTYPE="$LOTTYPE"
KPERHIST
="$KPERHIST"
KPTRXHST="$KPTRXHST"
KPCALHST="$KPCALHST"
KPDSTHST="$KPDSTHST"
ALWBKORD="$ALWBKORD"
VCTNMTHD="$VCTNMTHD"
UOMSCHDL="$UOMSCHDL"
ALTITEM1=" $ALTITEM1"
ALTITEM2
="#ALTITEM2"
USCATVLS_1
="$USCATVLS_1"
USCATVLS_2
="$USCATVLS_2"
USCATVLS_3
="$USCATVLS_3"
USCATVLS_4
="$USCATVLS_4"
USCATVLS_5
="$USCATVLS_5"
USCATVLS_6
="$USCATVLS_6"
MSTRCDTY
="$MSTRCDTY"
MODIFDT="$MODIFDT"
CREATDDT="$CREATDDT"
WRNTYDYS
="$WRNTYDYS"
PRCLEVEL="$PRCLEVEL"
LOCNCODE
="$LOCNCODE"
PINFLIDX
="$PINFLIDX"
PURMCIDX="$PURMCIDX"
IVINFIDX
="$IVINFIDX"
INVMCIDX
="$INVMCIDX"
CGSINFLX="$CGSINFLX"
CGSMCIDX="$CGSMCIDX"
ITEMCODE="$ITEMCODE"
TCC="$TCC"
PriceGroup
="$PriceGroup"
PRICMTHD
="$PRICMTHD"
PRCHSUOM
="$PRCHSUOM"
SELNGUOM
="$SELNGUOM"
KTACCTSR
="$KTACCTSR"
LASTGENSN="$LASTGENSN"
ABCCODE="$ABCCODE"
Revalue_Inventory
="$Revalue_Inventory"
Tolerance_Percentage
="$Tolerance_Percentage"
Purchase_Item_Tax_Schedu
="$Purchase_Item_Tax_Schedu"
Purchase_Tax_Options
="$Purchase_Tax_Options"
ITMPLNNNGTYP
="$ITMPLNNNGTYP"
STTSTCLVLPRCNTG="$STTSTCLVLPRCNTG"
CNTRYORGN="$CNTRYORGN"
DEX_ROW_ID
="$DEX_ROW_ID"/>
</updg:after>
</updg:sync>
<sql:query>SELECT [ITEMNMBR], [ITEMDESC], [NOTEINDX], [ITMSHNAM], [ITEMTYPE], [ITMGEDSC], [STNDCOST], [CURRCOST], [ITEMSHWT], [DECPLQTY], [DECPLCUR], [ITMTSHID], [TAXOPTNS], [IVIVINDX], [IVIVOFIX], [IVCOGSIX], [IVSLSIDX], [IVSLDSIX], [IVSLRNIX], [IVINUSIX], [IVINSVIX], [IVDMGIDX], [IVVARIDX], [DPSHPIDX], [PURPVIDX], [UPPVIDX], [IVRETIDX], [ASMVRIDX], [ITMCLSCD], [ITMTRKOP], [LOTTYPE], [KPERHIST], [KPTRXHST], [KPCALHST], [KPDSTHST], [ALWBKORD], [VCTNMTHD], [UOMSCHDL], [ALTITEM1], [ALTITEM2], [USCATVLS_1], [USCATVLS_2], [USCATVLS_3], [USCATVLS_4], [USCATVLS_5], [USCATVLS_6], [MSTRCDTY], [MODIFDT], [CREATDDT], [WRNTYDYS], [PRCLEVEL], [LOCNCODE], [PINFLIDX], [PURMCIDX], [IVINFIDX], [INVMCIDX], [CGSINFLX], [CGSMCIDX], [ITEMCODE], [TCC], [PriceGroup], [PRICMTHD], [PRCHSUOM], [SELNGUOM], [KTACCTSR], [LASTGENSN], [ABCCODE], [Revalue_Inventory], [Tolerance_Percentage], [Purchase_Item_Tax_Schedu], [Purchase_Tax_Options], [ITMPLNNNGTYP], [STTSTCLVLPRCNTG], [CNTRYORGN], [DEX_ROW_ID] FROM [BIZ1].[dbo].[IV00101_Shadow] where isinserted = 1 for xml auto</sql:query>
</iv00101insert>
-
One of your params is off (just a typo)... try changing:
[....]
<IV00101
[....]
ALTITEM2="#ALTITEM2"
to:
ALTITEM2="$ALTITEM2"
...and then go hunt down the person responsible for those column names and kill them. (But be nice about it - at least they avoided underbars in most of the names)
-Eddie
Eddie Wuerch
MCM: SQL
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply