|
Home > Archive > BizTalk Server General > May 2004 > SQL Aic Problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Steve Drake 2004-05-24, 4:37 pm |
| 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
| |
| Steve Drake 2004-05-24, 4:37 pm |
| Sorted now, it was a "" issue, we did think we had checked for this, thanks
for you time.
"Steve Drake" <Steve@_NOSPAM_.Drakey.co.uk> wrote in message
news:ekNCuSZQEHA.3264@TK2MSFTNGP10.phx.gbl...
> 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
>
>
|
|
|
|
|