How to split an XML message in BizTalk 2004 using Document & Envelope Schemas?
Read it on the weblog by Jan Tielens.
http://weblogs.asp.net/jan/archive/2004/03/07/85259.aspx
My first post is actually a copy of Robert's log:
Today (February 16th 2004) I have been busy solving a really difficult problem on a BizTalk Server 2002 production machine of one of our customers. Splitted documents where suspended by BizTalk. The error message in the event log of the server was as follows:
[0x80040e14] The following stored procedure call failed: " { call cs_create_SuspendedQ_from_WorkQ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?)}". :'Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.'
After a long search (again this error message is non-explanitory, which is common for BizTalk 2000 & 2002) I can the this conclusion:
This error occurs if a database-looup functiod is used in the mapper to search for a alphanumeric value in a numeric database field. The error therefore was not caused by spliting up documents but by the alphanumeric value in the incomming document. The error message is again very incomplete, but also internet groups provide all kinds of incorrect answers.