none
Calling Stored Procedure for Insert into an orchestartion RRS feed

  • Question

  • Hi All,

    I am trying to call Insert Stored procedure.Could anybody plz tell me how to get xml Response( To send that tesponse to another folder) from SQL DB using sql or wcf-sql.  the following is error when I try use RequestResponse send port  using sql adapter.


    Description:
    xlang/s engine event log entry: Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'xxxxx.Orchestration_1(e5a03e52-9534-fcb3-2b5e-9e57bc28c396)'.
    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: 843e2386-3cc1-4c2f-8093-2072c2878db2
    Shape name:
    ShapeId:
    Exception thrown from: segment -1, progress -1
    Inner exception: Received unexpected message type '' does not match expected type 'http://Sql#res'.
           
    Exception type: UnexpectedMessageTypeException
    Source: Microsoft.XLANGs.Engine
    Target Site: Void VerifyMessage(Microsoft.XLANGs.Core.Envelope, System.String, Microsoft.XLANGs.Core.Context, Microsoft.XLANGs.Core.OperationInfo)

    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: 843e2386-3cc1-4c2f-8093-2072c2878db2
    Shape name:
    ShapeId:
    Exception thrown from: segment -1, progress -1
    Inner exception: Received unexpected message type '' does not match expected type 'http://Sql#res'.
           

     

    Thursday, May 19, 2011 12:21 PM

Answers

All replies

  • Hi Raj

    When u generate the schema for the Insert using the WCF-SQL schema generation wizard.

    There you can find the schema for the ResultSet with StoredProcResultSet inside the Array of Result set

    U need to use this as the message type while receiving the response from SQL .

    The above error suggests ,that the response is not matching the message type .

    Hope that helps.

    Regards

    Sullu

     

     

     


    http://biztalkguide.blogspot.com/ Please mark as answer if this solved the issue.Thanks
    Thursday, May 19, 2011 3:02 PM
  • Thanks for u r reply. If we use sql adapter how the issue will be resolved?
    Friday, May 20, 2011 3:51 AM
  • Hi,

    I strongly advice to use WCF-SQL Adapter, see my post on WCF-SQL adapter and Stored-Procedure.

    HTH

    Regards,

    Steef-Jan Wiggers
    MVP & MCTS BizTalk Server
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly

     


    BizTalk
    Friday, May 20, 2011 9:57 AM
    Moderator
  • This topic (http://msdn.microsoft.com/en-us/library/dd787968(BTS.70).aspx) in the WCF SQL adapter help provides a step-by-step guidance into invoking a SQL Server stored procedure using BizTalk Server and the adapter.


    ______ Nitin Mehrotra, BizTalk Server CCxG, http://blogs.msdn.com/nitinme/
    Friday, May 20, 2011 10:57 AM