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