none
Calling a Stored Procedure (with or without parameters) from Biztalk Orchestration with returning values RRS feed

  • Question

  • I have to call a stored proc from a biztalk orchestration

    What I have done so far:

    I have created a procedure schema from add generated items>> add adapter metadata. Then I give particular database and chosen my required proc. It generated schema and an orchestration. I have followed this link exactly but I am not getting the required results. I am sending input message generated from schema(SQLService.xsd which was generated automatically). My messages get suspended with following errors.

    In BizTalk MMC:

    1. An internal server error was encountered while attempting to transmit the message. (Messaging)

    2. Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'CallSP.Orchestration_1(124a0e35-4852-ed2e-ea20-6d31c421059e)'.
    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: 5ff367f3-8c81-40b5-a1b2-93186ac51832
    Shape name:
    ShapeId:
    Exception thrown from: segment -1, progress -1
    Inner exception: An error occurred while processing the message, refer to the details section for more information
    Message ID: {8A94C182-F4A1-4601-9647-7194A853FADA}
    Instance ID: {0A9B6DFA-B5AC-4798-9015-568F7459DDDE}
    Error Description: An internal server error was encountered while attempting to transmit the message

            
    Exception type: XlangSoapException
    Source: Microsoft.XLANGs.BizTalk.Engine
    Target Site: Void VerifyTransport(Microsoft.XLANGs.Core.Envelope, Int32, Microsoft.XLANGs.Core.Context)
    The following is a

    In Event Viewer:

    1. xlang/s engine event log entry: Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'CallSP.Orchestration_1(124a0e35-4852-ed2e-ea20-6d31c421059e)'.
    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: 5ff367f3-8c81-40b5-a1b2-93186ac51832
    Shape name:
    ShapeId:
    Exception thrown from: segment -1, progress -1
    Inner exception: An error occurred while processing the message, refer to the details section for more information
    Message ID: {8A94C182-F4A1-4601-9647-7194A853FADA}
    Instance ID: {0A9B6DFA-B5AC-4798-9015-568F7459DDDE}
    Error Description: An internal server error was encountered while attempting to transmit the message

            
    Exception type: XlangSoapException
    Source: Microsoft.XLANGs.BizTalk.Engine
    Target Site: Void VerifyTransport(Microsoft.XLANGs.Core.Envelope, Int32, Microsoft.XLANGs.Core.Context)
    The following is a stack trace that identifies the location where the exception occured

       at Microsoft.BizTalk.XLANGs.BTXEngine.BTXPortBase.VerifyTransport(Envelope env, Int32 operationId, Context ctx)
       at Microsoft.XLANGs.Core.Subscription.Receive(Segment s, Context ctx, Envelope& env, Boolean topOnly)
       at Microsoft.XLANGs.Core.PortBase.GetMessageId(Subscription subscription, Segment currentSegment, Context cxt, Envelope& env, CachedObject location)
       at CallSP.Orchestration_1.segment1(StopConditions stopOn)
       at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp)

    2. A message sent to adapter "SQL" on send port "SendPort3" with URI "SQL://VMBIZTALK/Northwind/" is suspended.
     Error details: Unknown Error Description  
     MessageId:  {8A94C182-F4A1-4601-9647-7194A853FADA}
     InstanceID: {0A9B6DFA-B5AC-4798-9015-568F7459DDDE}

    ScreenShot:


    Thursday, May 9, 2013 5:36 AM

Answers

  • Finally I solved it.

    Configuration of SQL adapter in actions I worte only TableOp/Select/dbo/Employees except of writing

    <BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <Operation Name="Select" Action="TableOp/Select/dbo/Employees" />
    </BtsActionMapping>

    Thursday, May 9, 2013 9:44 AM