Need help in correlation
- From: sam <saambiswal@xxxxxxxxx>
- Date: Sat, 6 Jun 2009 22:13:29 -0700 (PDT)
Hi forum friends,
I need your help to solve my issue in BizTalk.Please suggest me if
you have any idea .
Issue:I have one table called status table where i took some id on the
basis of status as 'R' and change the status to 'P'.This is because
other process which are depending on the table should not process the
same data(ID) from the status table.After i update the status table of
E_status column from 'R' to 'C', i have to pick up ids from another
SourceID table (Those ids whose status changed from 'R' to 'C' in
status table ) and start another process.
What i did:I generate a sql select storeprocedure schema which is
based on status table.I set one receive shape make activity true and
changed the E-Status node from'R' to 'C' in maping then update the
data in status table using update stored procedure schema.after this
process ends i generate another schema on the select store procedure
based upon SourceID table(store procedure selects those id s from
SourceID table whose status changed from 'R' to 'C' in status table)
and do the maping and insert the selected IDs in another table called
Request table.So for that i have to keep 2 receive shape and 2 send
shape in orchestration and the process happens in sequence.Now i can
make only one receive shape as activity true and neither i can make
any correlation based on my scenario.Here i get the build error for
keeping two receive shape and making one activity true
""you must specify at least one already-initialized correlation set
for a non-activation receive that is on a non-self correlating port""
Please help me out how can i solve this issue and is it necessary to
make correlation when you want to keep two receive shape in
orchestartion.
sam
saambiswal@xxxxxxxxx
.
- Follow-Ups:
- Re: Need help in correlation
- From: news.microsoft.com
- Re: Need help in correlation
- Prev by Date: Need help in correlation
- Next by Date: Stop evaluating other rules if this rule is matched, how?
- Previous by thread: Need help in correlation
- Next by thread: Re: Need help in correlation
- Index(es):
Relevant Pages
|