Microsoft KB Archive/832755

= BizTalk Adapter for SQL Server AIC Does Not Support SELECT Statements in Stored Procedures =

Article ID: 832755

Article Last Modified on 11/26/2003

-

APPLIES TO


 * Microsoft BizTalk Adapter for SQL

-



SYMPTOMS
If you configure the Microsoft BizTalk Adapter for SQL Server Application Integration Component (AIC) to call a stored procedure that uses a SELECT statement, you may receive an error message that is similar to the following in your BizTalk Server application log when the AIC is invoked to update the destination SQL Server table: Event Type: Warning

Event Source: BizTalk Server

Event Category: Document Processing

Event ID: 324

Date: 11/11/2003

Time: 3:34:44 PM

User: N/A

Computer: BIZTALKSERVER

Description:

An error occurred in BizTalk Server.

Details:

[0x80004005] Failed to parse the XML Document, please refer to the trace log for more information [0x0159] The server encountered a transport error while processing the messaging port &quot;UpdatePurchaseOrders&quot;, which uses a transport component with a ProgID of &quot;AICSQL.SQLPipeline.1&quot;. [0x012b] A transmission attempt failed.



CAUSE
This error may occur if the SELECT statement that the stored procedure uses returns an INT value other than 0.



RESOLUTION
Do not configure the BizTalk Adapter for SQL Server (AIC) to call a stored procedure that uses a SELECT statement.



STATUS
This behavior is by design.



MORE INFORMATION
The BizTalk Adapter for SQL Server AIC does not support stored procedures that use SELECT statements. The BizTalk Adapter for SQL Server AIC supports only the INSERT statement, the DELETE statement, and the UPDATE statement for use with a stored procedure.

Keywords: kberrmsg kbprb KB832755

-

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

© Microsoft Corporation. All rights reserved.