Bad SQL Stored Proc Return Message

From: Proteus Duxbury (proteus.duxbury_at_paconsulting.com)
Date: 09/21/04 

Date: 21 Sep 2004 10:41:21 -0700

Hi,

I have a simple stored proc which I want to use to delete the contents
of a table. I know that the stored proc has to return an XML message
so it has been coded to:

a) Delete the contents of the table
b) return the contents of another table using XML AUTO.

I can send the request to the proc fine and it does run (i.e. records
are deleted). But the orchestration falls over when it tries to
recieve the response. It says:

Received unexpected message type '' does not match expected type
'http://SQLReceieve1#ResponseRoot'.

Which is fine, but how do I see the actual message that it is
complaining about? I can't find a way using the HAT and the XML schema
was generated automatically by BizTalk from the return of the proc, so
it should be OK.

I've tried using the orchestration debugger and 'attaching' to the
recieve but it just says 'null' for the return message.

Thanks,

Proteus.

Relevant Pages

  • Re: XML Import options
    ... If you pass the content of the file from the client to the server ... > stored proc directly, you can use NTEXT/TEXT as stored proc parameters! ... >> when XML was ...
    (microsoft.public.sqlserver.xml)
  • Re: XML Import options
    ... and then call the procedure from your client code while passing the content ... >> stored proc directly, you can use NTEXT/TEXT as stored proc parameters! ... >>> I have a text parsing routine on the front end written many years ago ... >>> when XML was ...
    (microsoft.public.sqlserver.xml)
  • RE: Bad SQL Stored Proc Return Message
    ... If you select Operations -> Messages from the HAT menu, ... I know that the stored proc has to return an XML message ... > Received unexpected message type '' does not match expected type ...
    (microsoft.public.biztalk.general)
  • Re: Unknown token received from SQL Server when using FOR XML
    ... > I've got a problem with a stored proc using the FOR XML ... Are you getting this message in Query Analyzer? ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Strange problem. Help me please
    ... stored proc using FOR XML on the client-side (e.g., FOR XML RAW, or FOR XML ... NEST ) either through OLEDB/ADO or via the SQLXML ... If I add FOR XML RAW into the stored proc, ...
    (microsoft.public.sqlserver.xml)