Using SQL Adapter in Orchestration

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Using SQL Adapter in Orchestration

Viewing 1 reply thread
  • Author
    Posts
    • #19987

      Hi,

         I have created an orchestration in which I am using two SQL ports. One SQL adapter user datagram and other uses Store procedure.

         Firstly I introduced Datgram SQL adapter and used an insert query. It works fine. Then I created another SQl port and configure Store Procedure execution. It creates another orchestration for that. I copied Message type and port from new orchestration to older one. i used newly created SQl adapter to call sttorw procedure from it. I builed and deployed the solution. Now when I pass message to the orchestration, SQL adapter for datagram executes succesfully but SQl adapter for Storee Procedure never gets executed. I check  in administration and It shows instance as succefull.

      If i check with schemas in HAt, it does not show newly create SQL adpater for SP call schema?. I do not have an idea about what is wrong with the procedure call and why Store procedure call schema is not visible.

      I will be really thankful if somebody can give me any clue about the same.

      Thank you in advance.

      Regards,

      Raminder Singh

    • #19988

       Here are some things to check:

      • Did you restart the host instance?
      • In the BizTalk Server administation console, open the orchestration properties and view the bindings.  Does the stored procedure send port show up?  If not, then the latest version is not deployed.
      • Is the stored proc SQL send port 1 way or 2 way?  If it is 1 way, you can easily change the adapter to FILE as a test to see if BizTalk delivers a file to the port.
      • Add trace statements to your orchestration around the stored proc send port and watch them in DebugView when the orch executes. (http://technet.microsoft.com/en-us/sysinternals/bb896647.aspx)
Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.