BizTalk Server General - Values from "bam_table_Active" not moved to "bam_table_Completed

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > December 2005 > Values from "bam_table_Active" not moved to "bam_table_Completed





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 Values from "bam_table_Active" not moved to "bam_table_Completed
Vamsi

2005-12-22, 5:55 pm

The values from "bam_table_Active" or not moved to "bam_table_Completed"

The column name'IsComplete' has got the value as '1' which i believe means,
the current trace is currently marked as completed, hence 'IsComplete' has
the value '1' if that is the case, I wonder why it is not moved to the
completed table, does any one has any idea on this?

and more over no errors in the event log, and all the columns under Active
table have been completed, Note: I am using continuationID's to follow up
orchestrations.

regards
Vamsi
Keith Lim

2005-12-28, 5:58 pm

Hi Vamsi,

For any activity record to be moved to *_Completed table, the record must
meet the following criteria:

1) IsVisible must be 1 (True) which really indicates that it has a
BeginActivity event persisted
2) IsCompleted must be 1 (True) which means that the record has an
EndActivity event persisted.
3) There is no related record in Continuation table (which means it is not
waiting for any record from continued segment(s) to be reconciled to the
root record).

From your info, it could either that your record is not meeting criteria 1
or 3 above. Please check if you are using the continuationID correctly.
To help us help you better, please let us know
the version (BizTalk 2004 or BizTalk 2006 beta) and whether you are using
TPE or EventStream to bamify your business process.

Please let me know if this help.

Thanks,
Keith Lim [MSFT]

--------------------[vbcol=seagreen]
"bam_table_Completed[vbcol=seagreen]
means,[vbcol=seagreen]
has[vbcol=seagreen]
Active[vbcol=seagreen]


--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com