BizTalk Server General - Tracking Profiles & BAM

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > August 2004 > Tracking Profiles & BAM





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 Tracking Profiles & BAM
Eric

2004-08-24, 6:59 pm

I have deployed a tracking profile and am noticing an unexpected behavior.

I have a send message that only executes within a certain decision path in
an orchestration. The Decision path is not being executed within the
orchestration. The HAT orchestration debugger verifies that the shape is
never executed.

My tracking profile for this orchestration has a send shape tied to an
activity that is within this decision path. I would expect that the RTA
tables and the BAM PrimaryImport tables for this activity would not receive
event definitions as the event does not occur. Unfortunately the tables have
entires and the Count Measures are rolling out to the BAM workbook.

A..Is this expected behavior?
B...If it is expected, what methods do I have available that will allow me
to only capture "real" instances of the execution of the shape using BAM?

Any help is greatly appreciated.

Thanks!


Derek Tan [MSFT]

2004-08-24, 6:59 pm

Hi Eric,

Shapes are mapped to milestones. So can you please check if the milestone column that you mapped the send shape is
not populated in the bam_<Activity Name>_PrimaryImport table? If it is, the send event is indeed fired. If not, it means that
you have other mappings that trigger a record to be inserted in the table. Check which columns are not null to trace back to
exactly which events were fired.

Regards,
Derek [MSFT]

--------------------
>Thread-Topic: Tracking Profiles & BAM
>thread-index: AcSKJiEji7tG2CiiTiKRT8d5WPw01A==
>X-WBNR-Posting-Host: 65.206.140.228
>From: "=?Utf-8?B?RXJpYw==?=" <Eric@discussions.microsoft.com>
>Subject: Tracking Profiles & BAM
>Date: Tue, 24 Aug 2004 15:03:04 -0700
>Lines: 22
>Message-ID: <FDD75F64-4F2E-43D5-AAF8-7F273501350F@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:18947
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>I have deployed a tracking profile and am noticing an unexpected behavior.
>
>I have a send message that only executes within a certain decision path in
>an orchestration. The Decision path is not being executed within the
>orchestration. The HAT orchestration debugger verifies that the shape is
>never executed.
>
>My tracking profile for this orchestration has a send shape tied to an
>activity that is within this decision path. I would expect that the RTA
>tables and the BAM PrimaryImport tables for this activity would not receive
>event definitions as the event does not occur. Unfortunately the tables have
>entires and the Count Measures are rolling out to the BAM workbook.
>
>A..Is this expected behavior?
>B...If it is expected, what methods do I have available that will allow me
>to only capture "real" instances of the execution of the shape using BAM?
>
>Any help is greatly appreciated.
>
>Thanks!
>
>
>



--

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.

Eric

2004-08-25, 4:19 am

Derek,

I'm not quite sure which table you are refeering to. There are 7 tables for
each of the activities in the PrimaryImportDatabase:

bam_DMSTimeout_ViewTimeout_ActiveInstanc
esSnapshot
bam_DMSTimeout_DMSTimeout_RTA_RTATable
bam_DMSTimeout_Continuations
bam_DMSTimeout_CompletedRelationships
bam_DMSTimeout_Completed
bam_DMSTimeout_ActiveRelationships
bam_DMSTimeout_Active

The RTA table has entries with null values in the TimeTable Dimensions for
the activity and non-null values for Partition, Timeslice, and count

The bam_DMSTimeout_Completed table has values for RecordID and ActivityID
but a null values (in all records) for 'Timeout'. Is this the table you are
referring to?

If the event is getting fired, why would there be an entry in the completed
table with a <null> value for 'Timeout'?

-eric

"Derek Tan [MSFT]" wrote:

> Hi Eric,
>
> Shapes are mapped to milestones. So can you please check if the milestone column that you mapped the send shape is
> not populated in the bam_<Activity Name>_PrimaryImport table? If it is, the send event is indeed fired. If not, it means that
> you have other mappings that trigger a record to be inserted in the table. Check which columns are not null to trace back to
> exactly which events were fired.
>
> Regards,
> Derek [MSFT]
>
> --------------------
>
>
> --
>
> 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.
>
>

Derek Tan [MSFT]

2004-08-25, 5:54 pm

Hi Eric,

I beg your pardon. I got a little confused between the stored procedure names and table names. I meant to refer to the
bam_DMSTimeout_Completed and bam_DMSTimeout_Active tables.

I assume that you are mapping the send shape to the "Timeout" milestone. Please let me know if this is not correct.

Since there are records in the bam_DMSTimeout_Completed table but null value for the "Timeout" datetime column, it
means that there are mappings (other than the send shape) that causes events to be fired to the BAM infrastructure. Please
double check how you are mapping the activity with the orchestration shapes and schema. If you're still stuck, please
attach a screenshot showing the mappings in the Tracking Profile Editor.

Regards,
Derek [MSFT]

--------------------
>Thread-Topic: Tracking Profiles & BAM
>thread-index: AcSKW30o0EMZPLVDSZeFqLpb5K+oXg==
>X-WBNR-Posting-Host: 65.206.140.228
>From: "=?Utf-8?B?RXJpYw==?=" <Eric@discussions.microsoft.com>
>References: <FDD75F64-4F2E-43D5-AAF8-7F273501350F@microsoft.com> <ApyUbOjiEHA.3936

@cpmsftngxa10.phx.gbl>
>Subject: RE: Tracking Profiles & BAM
>Date: Tue, 24 Aug 2004 21:25:01 -0700
>Lines: 95
>Message-ID: <536CD7AD-85EA-4924-AF63-CF8928A0B758@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:18955
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Derek,
>
>I'm not quite sure which table you are refeering to. There are 7 tables for
>each of the activities in the PrimaryImportDatabase:
>
> bam_DMSTimeout_ViewTimeout_ActiveInstanc
esSnapshot
>bam_DMSTimeout_DMSTimeout_RTA_RTATable
>bam_DMSTimeout_Continuations
>bam_DMSTimeout_CompletedRelationships
>bam_DMSTimeout_Completed
>bam_DMSTimeout_ActiveRelationships
>bam_DMSTimeout_Active
>
>The RTA table has entries with null values in the TimeTable Dimensions for
>the activity and non-null values for Partition, Timeslice, and count
>
>The bam_DMSTimeout_Completed table has values for RecordID and ActivityID
>but a null values (in all records) for 'Timeout'. Is this the table you are
>referring to?
>
>If the event is getting fired, why would there be an entry in the completed
>table with a <null> value for 'Timeout'?
>
>-eric
>
>"Derek Tan [MSFT]" wrote:
>
is[vbcol=seagreen]
that[vbcol=seagreen]
to[vbcol=seagreen]
the[vbcol=seagreen]
newsgroup/thread[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