|
Home > Archive > BizTalk Server Orchestration > October 2005 > SQL Adapter Receive - Orchestration instances
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Adapter Receive - Orchestration instances
|
|
| JupiterBiz 2005-10-06, 5:57 pm |
| We have a receive SQL adapter configured to receive set of records for every
5 minutes and activates a orchestration instance. We do not want to activate
multiple instances of orchestration at all i.e. if the first instance is
still running after 5 minute interval, we do not want to start the second
instance. In other words, we want to force one orchestration instance at any
time. I have tried ORDERED DELIVERY falg to TRUE in port but it did not work.
Please advise. Thanks in advance for your suggestions.
| |
| Alan Smith 2005-10-07, 2:50 am |
| Hi,
One option would be to use a Sequential Convoy orchestration, this would
mean you only had one instance running, but the reveive location would still
fire every 5 minutes, and the inbound messages would queue up. There's a
bunch of samples for seq convoys on the web (or check the bloggers guide).
A second option would be to implement an orchestration that does this:
While True
Call SP (SQL Solicit Response)
Process messages
Delay
End While
This would mean the SP would not get called before the orch has processed
the messages.
You would need a way to trigger the orchestration initially, as it needs to
be running to call the SP.
Regards,
Alan
--
The Bloggers Guide to BizTalk
http://geekswithblogs.com/asmith
"JupiterBiz" wrote:
> We have a receive SQL adapter configured to receive set of records for every
> 5 minutes and activates a orchestration instance. We do not want to activate
> multiple instances of orchestration at all i.e. if the first instance is
> still running after 5 minute interval, we do not want to start the second
> instance. In other words, we want to force one orchestration instance at any
> time. I have tried ORDERED DELIVERY falg to TRUE in port but it did not work.
> Please advise. Thanks in advance for your suggestions.
| |
| JupiterBiz 2005-10-07, 6:03 pm |
| Alan,
Thanks for your response. We will use the second option. First option will
not work becoz the SELECT of SQL adapter receive will have to wait until the
orchestration instance is completed. We are updating a flag at the end of the
orchestration and that will determine what needs to be processed in the next
run. Thanks for your help.
JupiterBiz
"Alan Smith" wrote:
[vbcol=seagreen]
> Hi,
>
> One option would be to use a Sequential Convoy orchestration, this would
> mean you only had one instance running, but the reveive location would still
> fire every 5 minutes, and the inbound messages would queue up. There's a
> bunch of samples for seq convoys on the web (or check the bloggers guide).
>
> A second option would be to implement an orchestration that does this:
>
> While True
> Call SP (SQL Solicit Response)
> Process messages
> Delay
> End While
>
> This would mean the SP would not get called before the orch has processed
> the messages.
>
> You would need a way to trigger the orchestration initially, as it needs to
> be running to call the SP.
>
> Regards,
>
> Alan
>
> --
> The Bloggers Guide to BizTalk
> http://geekswithblogs.com/asmith
>
>
>
> "JupiterBiz" wrote:
>
|
|
|
|
|