locked
BAM: BAM data not visible RRS feed

  • Question

  • Hi,

    I have created a simple solution a receive port(File) and a send port(File) and I pass a text file through pass through pipeline.

    I have created a simple activity definition received time and sent time.

    I have mapped the received time and Sent Time to PortStartTime and PortEndTime respectively in Tracking profile editor.

    I have successfully applied the Tracking profile.

    Still when I browse the BAM portal I am not seeing any records for the file transfers I made.

    does anybody know why this is happening ? Does anybody know how to fix it ?

    PLEASE HELP

    cheers

    Vikram

    Wednesday, January 28, 2015 4:43 PM

Answers

    • Ensure you have recycled the appropriate host instance for you deployment of the tracking profiles to take effect
    • Check the SQL view for your BAM activities by querig the dbo.bam_[ActivityName]_AllInstances.
    • If not, then if the tracking fails due to any issue you must have data in te TTDS error table (TDDS_FailedTrackingData). Check if this tables is populated.
    • If tracking fails for any reason, you should some entries in eventlog, check the eventlog.

    If event log is clean, no data in TDDS_FailedTrackingData, no data in AllInstances view , you have checked the above suggestions like TDDS means you have not deployed the tracking profiles properly which is used to track the data to BAM

    Regards,

    M.R.Ashwin Prabhu


    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.


    • Edited by M.R.Ashwin Prabhu Thursday, January 29, 2015 6:57 PM
    • Marked as answer by Angie Xu Tuesday, February 3, 2015 2:17 AM
    Thursday, January 29, 2015 6:57 PM

All replies

  • Check the BAM Activity tables directly to see the data are tracked.

    If data are not being populated in BAM Activity tables, ensure the following is been done:

    • Ensure your host instance is configured to run "Tracking Data Decode Service (TDDS)" in your environment. When an asynchronous event stream is used, the BAM data will be first  written to the BizTalk message box database and it’s the job of the TDDS      service to move the BAM data from BizTalk message box database to BAMPrimaryImport database. http://msdn.microsoft.com/en-us/library/ee308950(v=bts.10).aspx
    • I you have deployed your TPE correctly, and if engine faces any issue while data being tracked, you will have entry in the eventlog and if the tracking fails due to any issue you must have data in te TTDS error table (TDDS_FailedTrackingData).
    • TPE is not deployed property (host instances are recycled)

    Regards,

    M.R.Ashwin Prabhu



    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.

    Wednesday, January 28, 2015 4:48 PM
  • Hi Vikram,

    • Ensure “allow host tracking" is enable on one of the host. This is required because a BizTalk Host that hosts tracking is responsible for moving the DTA and BAM tracking data from the MessageBox database to the BizTalk Tracking (DTA) and BAM Primary Import databases.

    • TDDS service (Tracking Data Decode Service) is responsible for decoding and moving the data to BAM Primary Import DB and DTA DB. Make sure its running.

    For startups I found this article very useful for implementing BAM - BizTalk's Business Activity Monitoring(BAM)

    Rachit


    Please mark as answer or vote as helpful if my reply does


    Wednesday, January 28, 2015 5:49 PM
    Moderator
  • A Receive Port and a Send port are distinct events and unless you correlate between the two (using a continuation token) you are like to run into the issues that you are seeing. So the steps you follow should be

    1. Open TPE and select the Receive Location
    2. Navigate to the Message Properties and assign the instance ID to the Activity ID
    3. Assign the Port Start Time to your receive time
    4. Create a continuation and map the Message Id or Interchange Id to the Continuation Token
    5. Select the Send Port
    6. From the message properties map the Interchange Id to the Activity Id
    7. Then map the Port End Time to the Send Time

    Refer https://masteringbiztalkserver.wordpress.com/2013/02/08/how-to-enable-bam-continuation-between-receive-send-ports-using-tracking-profile-editor/ for detailed screen shot based instructions. Needless to say you would have to adapt the scenario to suit your requirements.

    Regards.


    • Edited by Shankycheil Thursday, January 29, 2015 5:22 AM EDIT
    Thursday, January 29, 2015 5:21 AM
  • Hi,

    have you mapped the id's (activity id) in TPE to the message instance id or service instance id.


    Bali ... Mark As Answer or Vote As Helpful if this helps.

    Thursday, January 29, 2015 6:59 AM
  • Hi,

    1. Activity id is set to message instance id.

    2. Dedicated host instance for tracking data.

    3. Set port mappings in TPE.

    4. applied Tracking profile.

    still no data in any of the tables in BAMPrimaryImport.

    Any ideas why this is happening. Its a simple plain vanilla BAM application.

    PLEASE HELP 

    Regards

    Vikram

    Thursday, January 29, 2015 3:40 PM
    • Ensure you have recycled the appropriate host instance for you deployment of the tracking profiles to take effect
    • Check the SQL view for your BAM activities by querig the dbo.bam_[ActivityName]_AllInstances.
    • If not, then if the tracking fails due to any issue you must have data in te TTDS error table (TDDS_FailedTrackingData). Check if this tables is populated.
    • If tracking fails for any reason, you should some entries in eventlog, check the eventlog.

    If event log is clean, no data in TDDS_FailedTrackingData, no data in AllInstances view , you have checked the above suggestions like TDDS means you have not deployed the tracking profiles properly which is used to track the data to BAM

    Regards,

    M.R.Ashwin Prabhu


    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.


    • Edited by M.R.Ashwin Prabhu Thursday, January 29, 2015 6:57 PM
    • Marked as answer by Angie Xu Tuesday, February 3, 2015 2:17 AM
    Thursday, January 29, 2015 6:57 PM
  • Is it mandatory to have a Tracking Profile? I am facing similar issue for a simple messaging solution in a test environment. There are no Tracking profiles set.

    However,  the BAM tracking is working in a Production environment without a tracking profile. I used below query to check Tracking Profiles in both environments:
    SELECT * FROM [BAMPrimaryImport].[dbo].[bam_Metadata_TrackingProfiles]

    Wednesday, September 28, 2016 1:46 AM
  • Hi Abhijeet,

    Please open a new thread for your questions as this us really old thread.

    Regards,


    Mandar Dharmadhikari

    Wednesday, September 28, 2016 3:34 AM
    Moderator
  • Hi Vikram,

    I was having the same problem: After reinstalling BAM, tracked data was not posted on BAM databases. Not a single sign of error in any log so far. I did what this post https://kentweare.blogspot.com/2009/01/biztalk-2006-missing-tracking-data-hat.html suggests, and it still didn't work, but it gave the idea of truncating a few more tables:
    BAMPrimaryImport.bam_Metadata_TrackingProfiles
    BizTalkMgmtDb.bam_TrackingProfiles
    [BizTalkMsgBoxDb].[TrackingData_X_X]
    [BizTalkDTADb].[TrackingData_X_X]
    This I did because nID did not match between BAMPrimaryImport and bam_TrackingProfiles.
    So, before truncating the tables, I remove all BAM profile definitions, then I truncate tables and then I deploy all definitions and profiles again.
    It all finally worked after this! Hope it helps. Peace!!

    Wednesday, May 2, 2018 5:30 PM