The infamous BAM EventBus Service event ID 25

There are 8 tables in each BizTalk Message Box database which store the tracking data before it is imported by the BAM EventBus Service (a.k.a. TDDS or Tracking Data Decoding Service) into the DTA/HAT and the BAM Primary Import databases. The tables are named TrackingData_x_y where 0 ≤ x ≤ 1 and 0 ≤ y…


How do I get data into BAM Archive?

“… It seems that the DTS/SSIS package BAM_DM_<activity name> should be moving it into the Instance and Relationship tables in the BAM Archive database but it doesn’t.” The BAM Data Maintenance DTS/SSIS package will only move data that is out of the activity online window. This is a setting on the BAM activities which can…


Developing with BAM and BAM FAQ are now available

I meant to post this earier so you might have already seen it but here it is. A short FAQ covering common questions and a document on using the BAM APIs.


How is BAM Archive database used?

I get different flavors of this question a lot so I’ll put some Q&A here. Q. Is there a way to view the data stored in the BAM Archive database in the BAM Portal?A. The short answer is NO.The BAM Archive database is the final destination for the BAM data. Once the online data is…


bts_CleanupMsgbox doesn’t work well with TDDS

DISCLAIMER –The bts_CleanupMsgbox stored procedure IS NOT SUPPORTED. IT IS NOT TO BE USED ON PRODUCTION SYSTEMS!!! The steps to workaround the bts_CleanupMsgbox issue outlined below ARE NOT TO BE USED ON PRODUCTION SYSTEMS!!! You can use bts_CleanupMsgbox and the steps in this posting in a test environment at your own risk. This posting is…


BAM Web Services and SQL Server mixed mode authentication

This is an issue I see every once in while so let’s see what causes it and how to diagnose and fix it. You have created and deployed a BAM definition with some BAM views in it but when you hit the BAM Portal with IE all you see in the “My Views” pane on…


Drop all indexes from a SQL table

After spending some time to find out that there is no easy way to drop all indexes from a SQL table I came up with this script. DECLARE @indexName NVARCHAR(128)DECLARE @dropIndexSql NVARCHAR(4000) DECLARE tableIndexes CURSOR FORSELECT name FROM sysindexesWHERE id = OBJECT_ID(N’tableName’) AND   indid > 0 AND indid < 255 AND  INDEXPROPERTY(id, name, ‘IsStatistics’)…