BizTalk Server General - SQL Adapter problem

Author

SQL Adapter problem - multiple body parts

George Bamber

2006-06-27, 1:17 pm

Hi

I wrote a stored procedure to handle entering data in a table. If the record
doesn't exist it inserts it otherwise it updates the values.

At the end I do a select and return a key value. Nothing special.

I then did a "Add Generated Items..." and have a schema and orchestration.

Everything works fine until the SQL port returns from running the stored
procedure. Sometimes I get a MultipleBodyPartException with up to four body
parts whereas we're only expecting one.

Any ideas?

Thanks
George

George Bamber

2006-06-28, 1:21 pm

Hi

Is it possible to call a stored procedure without getting a response but
tracking if there is an error? Would the SQL adapter return an error?

Thanks
George

"George Bamber" wrote:

> Hi
>
> I wrote a stored procedure to handle entering data in a table. If the record
> doesn't exist it inserts it otherwise it updates the values.
>
> At the end I do a select and return a key value. Nothing special.
>
> I then did a "Add Generated Items..." and have a schema and orchestration.
>
> Everything works fine until the SQL port returns from running the stored
> procedure. Sometimes I get a MultipleBodyPartException with up to four body
> parts whereas we're only expecting one.
>
> Any ideas?
>
> Thanks
> George
>
>
>