SQL Recv Port

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Recv Port

Viewing 1 reply thread
  • Author
    Posts
    • December 5, 2008 at 6:50 AM #21313
      community-content

        I am having SQL receive  Port  calling StoredProc. This works perfectly. Now if i turn and create envelope and body schema I get the following message. What is that Iam missing here. I made SQLSERVICE as Envelope and new message for Body.

        A message received by adapter “SQL” on receive location “Receive Location6” with URI “SQL://./HSEBSInt_DB/” is suspended.

        Error 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.

        MessageId: {70E394A2-42E4-45CD-A731-A28226AD9C05}

        InstanceID: {C63F74CB-D423-4744-9F18-A711C369A888}

        Thanks and Regards

         

        Vijaykishan S

      • December 5, 2008 at 10:40 AM #21315
        community-content

          Hi Vijay,

          I never work with this. However I suspect on schema. Since you trun envelope and body schema, your schema may look different now. So your receive port couldn’t match it with your schema if you use pipeline or your orchestration couldnt get it from message box . Just make sure your incomming message and schema that you deployed have same structure.

          Siva

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.