SQL Aic Problem

From: Steve Drake (Steve_at__NOSPAM_.Drakey.co.uk)
Date: 05/24/04 

Date: Mon, 24 May 2004 14:40:27 +0100

All,

We have a MAP that needs to create an order header and many order items, so
we issue 2 SQL commands sproc01 and sproc02 sproc02 gets the order items
sent to it, this is the output sent to the AIC :

<ROOT>
<sproc01 name="InsertOrder">
<param01 name="order_id" value="1718"/>
<param02 name="company_id" value="7"/>
!SNIP!
</sproc01>
<sproc02 name="dia_InsertOrder_Item">
<param01 name="order_id" value="1718"/>
<param02 name="position_number" value="1"/>
</sproc02>
<sproc02 name="dia_InsertOrder_Item">
<param01 name="order_id" value="1718"/>
<param02 name="position_number" value="2"/>
</sproc02>
<sproc02 name="dia_InsertOrder_Item">
<param01 name="order_id" value="1718"/>
<param02 name="position_number" value="3"/>
</sproc02>
<sproc02 name="dia_InsertOrder_Item">
<param01 name="order_id" value="1718"/>
<param02 name="position_number" value="4"/>
</sproc02>
</ROOT>

And here is the error from the eventlog.

 [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 "GPSD Ackermann ORDER SQL Port", which uses a transport
component with a ProgID of "AICSQL.SQLPipeline.1".

 [0x012a] All retry transmissions failed.

 [0x80004005] Unspecified error

 [0x0156] The server could not finish processing messaging port "XXXX ORDER
SQL Port".

 [0x1730] Suspended Queue ID: "{776A98AF-8FAA-4C53-8EF5-B9838F643515}"

 [0x80004005] Unspecified error

Its strange as the SQL gets run (you can see it with an SQL trace) but
biztalk rolls back the transtion.

Steve

Relevant Pages

  • Re: ADO Connection - Fails - Unspecified Error
    ... >unspecified error for each of the ADODC controls that is referenced by a ... > This only occurs when there are items that reference the control and they ... > using SQL Query Analyzer, so I do not believe it is a permissions issue. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection - Fails - Unspecified Error
    ... >unspecified error for each of the ADODC controls that is referenced by a ... > This only occurs when there are items that reference the control and they ... > using SQL Query Analyzer, so I do not believe it is a permissions issue. ...
    (microsoft.public.data.ado)
  • Re: Formatting Dates
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > FROM root.dagent dagent ... > "unspecified Error" ...
    (microsoft.public.sqlserver.programming)
  • Problem querying data from Access
    ... Unspecified error ... I put it in view so that I can call the view instead of using the long SQL, ... Set cmd = Server.CreateObject ... Const adCmdStoredProc = &H0004 ...
    (microsoft.public.inetserver.asp.db)