Hi,

Does anybody have experience in creating 2 receive shapes inside 1
orchestration.
In my situation, Biztalk needs to retrieve data from database using SQL
adaptor and publish orchestration as a web service, hence there will be 2
receive shapes required for the orchestration. When 2 receive shapes are
inside 1 orchestration it requires some type of correlation to exists betwee
n
the message instances. We tried to define some correlations on it but can't
work out.

Anybody know what could be the reason and how to solve it.

Thanks in advance.

[ Post a follow-up to this message ]

Hi

Yes, you need the correlation in order to make sure that the second
receiveshapre receives the message that is for its instance of the
orchestration and not for some othe rinstance.

Basically, what you do is take the schema you receive from the SQL
Port and do a property promotion on it. Then, take the schema you
receive from the webservice and promote a property... to the SAME
property field in the property schema.

Now, go into your orchestration, and create a correlation type on this
property, and create a correlation set of this type. Lastly, make sure
your first receive shape initiates this correlation set and that the
second receive shape follows this correlation set.

That should do it.

Jan Eliasen

On Thu, 9 Jun 2005 05:55:02 -0700, Sheila
<Sheila@discussions.microsoft.com> wrote:

>Hi,
>
>Does anybody have experience in creating 2 receive shapes inside 1
>orchestration.
>In my situation, Biztalk needs to retrieve data from database using SQL
>adaptor and publish orchestration as a web service, hence there will be 2
>receive shapes required for the orchestration. When 2 receive shapes are
>inside 1 orchestration it requires some type of correlation to exists betwe
en
>the message instances. We tried to define some correlations on it but can't
>work out.
>
>Anybody know what could be the reason and how to solve it.
>
>Thanks in advance.

--
Jan Eliasen, representing himself and not the company he works for.

[ Post a follow-up to this message ]

The situation is like this. We have an input schema that we received
from the web service consisting of an example say field A, B and C. Then
we got an sql schema we received from the SQL port but this SQL schema
is returning field D,E, F. In this case the fields returned are entirely
DIFFERENT from the input schema. In such cases we can't do a promotion
of the same property based on the schemas. So how do we create a
correlation set in this case?

So my question is can correlations only be done via property schemas? Is
distinguished fields feasible? is there any other solution if correlation
doesn't work.


"Jan Eliasen" wrote:

> Hi
>
> Yes, you need the correlation in order to make sure that the second
> receiveshapre receives the message that is for its instance of the
> orchestration and not for some othe rinstance.
>
> Basically, what you do is take the schema you receive from the SQL
> Port and do a property promotion on it. Then, take the schema you
> receive from the webservice and promote a property... to the SAME
> property field in the property schema.
>
> Now, go into your orchestration, and create a correlation type on this
> property, and create a correlation set of this type. Lastly, make sure
> your first receive shape initiates this correlation set and that the
> second receive shape follows this correlation set.
>
> That should do it.
>
> Jan Eliasen
>
> On Thu, 9 Jun 2005 05:55:02 -0700, Sheila
> <Sheila@discussions.microsoft.com> wrote:
> 
>
> --
> Jan Eliasen, representing himself and not the company he works for.
>

[ Post a follow-up to this message ]

Hi

You can promote two elements from to different schemas to the same
property in a property schema. Just don't use "Quick promotion" - use
"Show promotions, and do it manually.

Yes, correlation can only be done on promoted properties, and it only
works if you promote from your different schemas to the SAME property
in the property schema.

Jan Eliasen

On Sat, 11 Jun 2005 08:48:02 -0700, Sheila
<Sheila@discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The situation is like this. We have an input schema that we received
>from the web service consisting of an example say field A, B and C. Then
>we got an sql schema we received from the SQL port but this SQL schema
>is returning field D,E, F. In this case the fields returned are entirely
>DIFFERENT from the input schema. In such cases we can't do a promotion
>of the same property based on the schemas. So how do we create a
>correlation set in this case?
>
>So my question is can correlations only be done via property schemas? Is
>distinguished fields feasible? is there any other solution if correlation
>doesn't work.
>
>
>"Jan Eliasen" wrote:
> 

--
Jan Eliasen, representing himself and not the company he works for.

[ Post a follow-up to this message ]

Can you use a send port for the SQL call passing in parameters from the web
service call, or do you need both/either to start the orchestration?

you'll need correlation in the latter case, as mentioned by other posters,
which will require some matching value in the two documents.

Matt


"Sheila" <Sheila@discussions.microsoft.com> wrote in message
news:634665C0-1B4B-44B5-ACDD-69BDC1055C0D@microsoft.com...
> Hi,
>
> Does anybody have experience in creating 2 receive shapes inside 1
> orchestration.
> In my situation, Biztalk needs to retrieve data from database using SQL
> adaptor and publish orchestration as a web service, hence there will be 2
> receive shapes required for the orchestration. When 2 receive shapes are
> inside 1 orchestration it requires some type of correlation to exists
> between
> the message instances. We tried to define some correlations on it but
> can't
> work out.
>
> Anybody know what could be the reason and how to solve it.
>
> Thanks in advance.

[ Post a follow-up to this message ]

Hi,

looking at this thread i think you might benefit from this example

http://marv-in.net/blog/archive/2005/06/03/154.aspx

It shows how to send a single "one-Way' message to a webservice and
expects 3 return messages (async with correlation).

Hope this helps,

Marvin Smit.


On Thu, 9 Jun 2005 05:55:02 -0700, Sheila
<Sheila@discussions.microsoft.com> wrote:

>Hi,
>
>Does anybody have experience in creating 2 receive shapes inside 1
>orchestration.
>In my situation, Biztalk needs to retrieve data from database using SQL
>adaptor and publish orchestration as a web service, hence there will be 2
>receive shapes required for the orchestration. When 2 receive shapes are
>inside 1 orchestration it requires some type of correlation to exists betwe
en
>the message instances. We tried to define some correlations on it but can't
>work out.
>
>Anybody know what could be the reason and how to solve it.
>
>Thanks in advance.

[ Post a follow-up to this message ]