Failure executing the response(receive) pipeline

Hello,

I am very new to BizTalk and am having trouble using the SQL adapter to update a SQL database.

I have based this part of the BizTalk application on the “Walkthrough: Using the SQL Adapter with a Stored Procedure in an Orchestration” in the BizTalk Server help.  After deploying the solution I have tested with some data that I know is valid.  I have an error as the SQL database in not updated and I get the following error listed in the event viewer:

There was a failure executing the response(receive) pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "XML disassembler" Send Port: "SendPortSPROC_Call" URI: "SQL://localhost/BCS_ProcurementDB/" Reason: The body part is NULL.

Can anyone explain what “the body part is null” means? When I added the adapter via the “Add generated Items” wizard I selected send port which then has both request and response roots. The stored procedure returns a single value “true”.  

When I execute the stored procedure in the SQL Server it seems to work OK.

I have also tried changing the stored procedure so that it returns a list of values using “for xml raw, xmldata” when setting up the SQL adapter but I got the same “body part is null” error.

Any help would be much appreciated.

Cheers

Stable