| Ola Hiselius 2006-03-25, 11:37 am |
| I have a orchestration that i want to use for inserting several lines into a
SQL table. I use the SQL-adapter with a stored procedure.
If the incoming message only contains one row everything works just fine.
But if the message consists of several rows the orchestration gets suspended.
Everything works fine until the last row of the message. When the result from
the last insert is sent back to BizTalk I get en error. I have tired to send
back different results (Return 0 or Select ... etc) from the sp, but nothing
works. The errormessage is:
------------------
Uncaught exception (see the 'inner exception' below) has suspended an
instance of service
'StorFlatfil.Orchestration_1(6d756f07-3743-39be-0e02-a54d4c03dd97)'.
The service instance will remain suspended until administratively resumed or
terminated.
If resumed the instance will continue from its last persisted state and may
re-throw the same unexpected exception.
InstanceId: acfdc2d9-a631-40ad-8ce0-409136d8e62e
Shape name: Receive_2
ShapeId: a8cab57d-06cc-4381-a498-62807d683645
Exception thrown from: segment 1, progress 13
Inner exception: Multi-part message 'SQLOutput' has body part 'BodyPart10',
expected body part 'BodyPart1'.
Exception type: WrongBodyPartException
Source: Microsoft.XLANGs.BizTalk.Engine
Target Site: Void ReadMessageState(Microsoft.XLANGs.Core.Envelope,
Microsoft.XLANGs.BaseTypes.XLANGMessage)
---------------------
When I look at the suspended message I can se that the last result from the
sp differs from al other. Here is an sample of bodypart1 to 9:
<?xml version="1.0" encoding="utf-16" ?><SQLResponse
xmlns="http://StorFlatfil.test"><orders customerid="PDBDA"/></SQLResponse>
and here is the last row (bodybart10):
<SQLResponse xmlns="http://StorFlatfil.test"><orders customerid="PDBDA"
/></SQLResponse>
Is there anybody that knows how to solve this problem?
Has anybody tried to use the SQLadapter with several rows to be inserted?
Thanks
/ola
|