Microsoft KB Archive/814804

= The Disassemble Result Set option does not work when you request many records in BizTalk Server =

Article ID: 814804

Article Last Modified on 1/14/2004

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Standard Edition
 * Microsoft BizTalk Adapter for SQL

-



SYMPTOMS
If you select the Disassemble Result Set option, and then you request many records, the SQL request does not succeed and you receive the following event error message in the application log file of your computer that is running Microsoft BizTalk Server: Source: RFSQL

Type: Error

Event ID 10

Category: None

Description:

A worker thread reported a failure: [Error:] An error occurred in BizTalk Server.

Details:

--

BizTalk Server failed to initialize a connection to database: &quot;InterchangeSQ&quot; on server: &quot;FRLAB108&quot;. :'New transaction cannot enlist in the specified transaction coordinator. ' There was a failure creating the internal work item. Make sure that SQL Server is running. [Source:] [HelpFile:] [HelpContext:] 0 Note: The Disassemble result set feature can not be used if the target SQL Server is the same one that BizTalk uses. In this case you must unselect the Disassemble Rresult Set feature. The error code is shown in the data area below. The operation was: ISQLWorker->Execute The worker thread was working on: Job Name: select * from northwind SQL Script: select * from products for xml auto

Note In this message, &quot;Rresult&quot; is a misspelling of the word &quot;Result.&quot;



CAUSE
This behavior occurs because a limitation exists in SQLXML. Microsoft BizTalk Server Adapter for SQL Server must complete the first data stream from Microsoft SQL Server before it can start a new data stream. This behavior occurs only if you use the instance of SQL Server that is on the local computer for both the BizTalk Server database instance and the host instance of SQL Server.



WORKAROUND
To work around this behavior, do not use the local instance of SQL Server for both the BizTalk Server database and the host instance of SQL Server.



STATUS
This behavior is by design.

Keywords: kbprb KB814804

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.