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