Invalid XML elements found inside sync block

• psullivan

  SSChasing Mays

  Points: 604

  More actions

  January 8, 2004 at 4:55 pm

  #65373

  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>

• Eddie Wuerch

  SSChampion

  Points: 12535

  More actions

  January 8, 2004 at 11:04 pm

  #489282

  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