none
Error in Oracle Adapter Pack to do pooling RRS feed

  • Question

  • Hi

    I used BizTalk Adapter Pack 2.0 to do pooling in an Oracle Data base executing a store procedure, The configuration of my Recive location is:

    - Type = WCF-Custom

    - Pipeline = XMLReceive

    - Binding Type = OracelDBBinding

    - ...

    When I execute my application reported the error:

    "The Messaging engine failed to process a message submitted by adapter:WCF-Custom Source URL:oracledb://INTDES.WORLD. Details:The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure."

    Do you know why i have this error?

    thanks for you Help.

    Alejandro Gonzalez J.

    Friday, June 26, 2009 2:02 PM

Answers

  • The error has been solved deleting the send port in the orchestration and adding a new send port selecting the option Use an existing Port Type in the wizard Select a Port Type and selecting the port created for the adapter.

    In the previous implementation I indicate Create a New Port Type and I could have selected the wrong message

    Thanks of all you

    Alejandro Gonzalez  J.

    Wednesday, July 1, 2009 4:40 PM

All replies

  • Hi Alejandro ,

    From the error, it is clear that adapter is receiving the polled data successfully from Oracle Server.
    This error can occur because of number of reasons. Make sure you have configured following things:

    1. There is some send port or orchestration to handle the incoming message.
    2. If 1 is true, make sure you have not selected "Pass Through" pipeline in the receive location. Select "XML Receive" pipeline instead.

    I can think of these 2 things for now. If both of them are configured correctly, search for suspended message from the BizTalk Server Administration Console and see the error details there.


    Thanks
    Gaurav



    Friday, June 26, 2009 2:26 PM
  • Thanks Gaurav for you response

     Both conditions are correct, the receive port is connected with orchestration and the pipeline is XML Receive.

     

    The error details are:

    -

    System

     

       

    -

    Provider

     

         

    [ Name]

    BizTalk Server 2009

     

       

    -

    EventID

    5778

     

         

    [ Qualifiers]

    49344

     

       
     

    Level

    2

     

       
     

    Task

    1

     

       
     

    Keywords

    0x80000000000000

     

       

    -

    TimeCreated

     

         

    [ SystemTime]

    2009-06-27T14:45:24.000Z

     

       
     

    EventRecordID

    415341

     

       
     

    Channel

    Application

     

       
     

    Computer

    c-biztalk.intergrupo.com

     

         
     

    Security

     

    -

    EventData

             

     

         

    WCF-Custom

     

         

    oracledb://INTDES.WORLD

     

         

    The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

     

    Alejandro Gonzalez J.

    Saturday, June 27, 2009 2:31 PM
  • Can you double check that your orchestration is enlisted and the orchestration host is running?

    If that didn't help, you can compare the orchestration subscription and suspended messages context property to figure out the issue. ( Help link - http://msdn.microsoft.com/en-us/library/aa577436.aspx)

    Thanks,
    Jeevitha

    Sunday, June 28, 2009 3:55 PM
  • Thanks Jeevithafor you response

    The orchestration subscription is:

    http://schemas.microsoft.com/BizTalk/2003/system-properties.ReceivePortID == {E8F228D4-6663-40D6-BE79-0A8DF70AEB3E}  And

    http://schemas.microsoft.com/BizTalk/2003/system-properties.MessageType == http://Microsoft.LobServices.OracleDB/2007/03/INTEGRA/Package/PKGINTEGRACION/OBTENERELEMENTOINTEGRACION#ArrayOfRECORD  And

    http://schemas.microsoft.com/BizTalk/2003/system-properties.InboundTransportType != SOAP

                    Or

    http://schemas.microsoft.com/BizTalk/2003/system-properties.ReceivePortID == {E8F228D4-6663-40D6-BE79-0A8DF70AEB3E}  And

    http://schemas.microsoft.com/BizTalk/2003/soap-properties.MethodName == OBTENERELEMENTOINTEGRACION

     

    I don’t  know  how can I suspended messages context property.

    Wednesday, July 1, 2009 12:53 PM
  • The error has been solved deleting the send port in the orchestration and adding a new send port selecting the option Use an existing Port Type in the wizard Select a Port Type and selecting the port created for the adapter.

    In the previous implementation I indicate Create a New Port Type and I could have selected the wrong message

    Thanks of all you

    Alejandro Gonzalez  J.

    Wednesday, July 1, 2009 4:40 PM
  • The orchestration subscription does not look correct. Notice this part:

    http://schemas.microsoft.com/BizTalk/2003/system-properties.MessageType == http://Microsoft.LobServices.OracleDB/2007/03/INTEGRA/Package/PKGINTEGRACION/OBTENERELEMENTOINTEGRACION#ArrayOfRECORD 

    This should be something like http://Microsoft.LobServices.OracleDB/2007/03/INTEGRA/Package/PKGINTEGRACION#OBTENERELEMENTOINTEGRACION

    I think you have used incorrect schema as your message defining schema in your orchestration. The ArrayOfRecord is a schema the SP schema makes use of.

    Hope this helps!

    Wednesday, July 1, 2009 5:04 PM