BizTalk Adapter for SQL Server AIC Does Not Support SELECT Statements in Stored Procedures (832755)
The information in this article applies to:
- Microsoft BizTalk Adapter for SQL Server 1.0
SYMPTOMSIf 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
"UpdatePurchaseOrders", which uses a transport component with a ProgID of "AICSQL.SQLPipeline.1".
[0x012b] A transmission attempt failed.CAUSEThis error may occur if the SELECT statement that the stored procedure uses returns an INT value
other than 0.RESOLUTIONDo 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 INFORMATIONThe 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.
| Modification Type: | Minor | Last Reviewed: | 11/26/2003 |
|---|
| Keywords: | kberrmsg kbprb KB832755 kbAudDeveloper |
|---|
|