Posted by: techsavygal | November 24, 2006

SQL Adapter changes in BTS 2006!

This is been an old post lying in my drafts…apologies if it is slightly not in sync.

While migrating our applications from BizTalk Server 2004 to BizTalk Server 2006, we came across a weird error when we were trying to debatch a message received from sql server 2000/2005:

“Unexpected event (“document_start”) in state “processing_empty_document”.”

This error occurs due to the changes made in the SQL Adapter receive pipeline in BizTalk Server 2006. I jumped to investigate the problem and the solution and here it goes as below:

Problem:The SQL Adapter pipeline is not able to read the header and footer tags of xml attributes when the stored procedure is passing xml data using XML AUTO. In BizTalk Server 2004, the SQL Adapter schema was written in such a way that it was compatible with AUTO feature. But, in SQL Server 2005 has enabled batching and each line is executed.

Solution(s): Inorder to resolve this issue, we either need to make changes to the existing source schema, where we add the tag names to each tag in the xml file. For example: you have an xml message as below:

a. Modifications to source schema –  Change the source schema to include tags for each element. for example <tag1> value</tag1>

b. Modifications to stored procedures –  Replace XML AUTO with XML EXPLICIT.

Advertisements

Responses

  1. Wonderful work! That is the kind of information that are supposed to be shared around the net. Shame on the seek engines for not positioning this put up higher! Come on over and consult with my web site . Thanks =)


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: