Re: Need help in correlation
- From: "news.microsoft.com" <Joerg Fischer>
- Date: Tue, 9 Jun 2009 09:46:36 +0200
Hi,
You should better use a different approach, as this might lead to problems when retrieving rows and updating their status accordingly later in processing (maps or orchestration).
Just implement a SQL stored procedure which selects into a temp table, updates the selected records' status in the original table and returns them as a joined table with all required data. It can be called by a SQL adapter receive location easily.
Much easier.
Regards
Joerg Fischer
BizTalk MVP
"sam" <saambiswal@xxxxxxxxx> schrieb im Newsbeitrag news:9b11dfbe-d09e-406c-8fa0-d119fa40d0a8@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- Need help in correlation
- From: sam
- Need help in correlation
- Prev by Date: Re: Stop evaluating other rules if this rule is matched, how?
- Next by Date: RE: Issue Mapping Flat File to XML file
- Previous by thread: Need help in correlation
- Next by thread: Stop evaluating other rules if this rule is matched, how?
- Index(es):
Relevant Pages
|
