I start the orchestration with a small xml (generated by the SQL Adapter), which contains only the name of the stored proc, which selects the data I need.
But. The Port that sends the request, and receives the response is a solicit request-response Send Port. And the only element, which has the Polling properties, is a Receive Location. So I don’t know how to set this property.
When I restart the BizTalk Server, the hanging orchestration continues to run. I don’t have to start it again.
It’s true, that the orchestration does nothing for 5 Minutes, so I try to change it to work like you said.
Maybe I don’t know everything about the SQL Adapter?