|
Home > Archive > BizTalk Server Orchestration > March 2006 > SQL Receive Port
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]
|
|
|
| Hi,
My BTS project has two orchestrations:
1. Flat File Import
2. Flat File Export
Import orchestration has a receive port that picks flat file from a
location and processes it. Export orchestration is independent and
should only be triggered if required since file is exported to Client
at his request which has no fixed schedule.
Export orchestration has a SQL receive port that requests data via SQL
adapter. Since I need to manually trigger the orchestration so I placed
additional FF Recieve Port before the SQL Receive port. But on building
it shows the following error:
error X2214: you must specify at least one already-initialized
correlation set for a non-activation receive that is on a
non-selfcorrelating port.
[On the whole my basic objective is to have a orchestration that would
retrieve data via SQL Adapter]
Can anyone please help me on this.
Thanks,
Amit
| |
| Eric Stott 2006-03-07, 5:51 pm |
| Your recieve shape that is picking up the flat file, the activate paramater
needs to be set to True.
Eric
http://stottcreations.com/blog
"Amit" <s.amit.kumar@gmail.com> wrote in message
news:1141755903.462633.65550@u72g2000cwu.googlegroups.com...
> Hi,
> My BTS project has two orchestrations:
> 1. Flat File Import
> 2. Flat File Export
>
> Import orchestration has a receive port that picks flat file from a
> location and processes it. Export orchestration is independent and
> should only be triggered if required since file is exported to Client
> at his request which has no fixed schedule.
> Export orchestration has a SQL receive port that requests data via SQL
> adapter. Since I need to manually trigger the orchestration so I placed
> additional FF Recieve Port before the SQL Receive port. But on building
> it shows the following error:
> error X2214: you must specify at least one already-initialized
> correlation set for a non-activation receive that is on a
> non-selfcorrelating port.
>
> [On the whole my basic objective is to have a orchestration that would
> retrieve data via SQL Adapter]
>
> Can anyone please help me on this.
>
> Thanks,
> Amit
>
| |
|
| Yes, I have already set FF Receive Shape's activate property to True.
I am able to build the project without any errors if I set SQL Receive
port's Binding Property to True and Partner Orchestration Property's to
Self Correlation. For all other combinations its throwing errors.
| |
| Eric Stott 2006-03-07, 8:47 pm |
| Would it be possible to have the the trigger file initialize the
orchestration, and then have a stored proc actually return the data, so you
send something to the database telling it to return the data, that data that
is returned then you can send out to the customer?
Eric
http://stottcreations.com/blog
"Amit" <s.amit.kumar@gmail.com> wrote in message
news:1141765145.800321.58600@j52g2000cwj.googlegroups.com...
> Yes, I have already set FF Receive Shape's activate property to True.
> I am able to build the project without any errors if I set SQL Receive
> port's Binding Property to True and Partner Orchestration Property's to
> Self Correlation. For all other combinations its throwing errors.
>
|
|
|
|
|