The XML data may become corrupted when you use a SQL adapter to run updategrams to modify a database in BizTalk Server 2004 (888756)


The information in this article applies to:

  • Microsoft BizTalk Server 2004 Developer Edition
  • Microsoft BizTalk Server 2004 Enterprise Edition
  • Microsoft BizTalk Server 2004 Partner Edition
  • Microsoft BizTalk Server 2004 Standard Edition
Content Maintenance:27544

SYMPTOMS

When you use a SQL adapter to run updategrams to modify a database in Microsoft BizTalk Server 2004, the XML data may become corrupted.

CAUSE

This problem occurs when the following conditions are true:
  • The data contains the same string that is used as the XML prefix. For example, "ns0" is the prefix in <ns0:InRoot/>.
  • This prefix string is immediately followed by ":before" or ":after".

MORE INFORMATION

The following code exmple contains the string "ns0." This string is the same as the XML prefix. 
<ns0:InRoot xmlns:ns0="http://SQLSendRuntime.BVT.Test">
            <ns0:sync>
                        <ns0:before />
                        <ns0:after>
                                    <ns0:TestTable001 Col_1="1" Col_2="&lt;ns0:before&gt;test&lt;/ns0:before&gt;" />
                                    <ns0:TestTable001 Col_1="2" Col_2="&lt;ns0:after&gt;test&lt;/ns0:after&gt;" /> 
                                    <ns0:TestTable001 Col_1="3" Col_2="ns0:before" /> 
                                    <ns0:TestTable001 Col_1="4" Col_2="ns0:after" /> 
                        </ns0:after>
            </ns0:sync>
</ns0:InRoot>
This code adds the following rows to the table, contrary to expectations:
  • <ns00:before>test</ns00:before>
  • <ns00:after>test</ns00:after>
  • ns00:before
  • ns00:after
Modification Type:MajorLast Reviewed:1/28/2005
Keywords:kbXML kbprb KB888756 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.