4/20/16

DTS package BAM_DM_ResendJournalActivity already exists on server

I have seen many peoples have faced this issue when trying to reconfigure the BizTalk EDI/AS2 Runtime. Due to any reason if you unconfigure and uninstall the BizTalk Server and trying to Configure it again you will get below error.

"DTS package BAM_DM_ResendJournalActivity already exists on server <ServerName>"




It is because the EDI/AS2 DTS (Data Transformation Services) packages are not automatically removed when you uninstall it from SQL Integration Services after you unconfigure the EDI/AS2 Runtime feature.

There are two methods to resolve this issue.
Solution 1: 
Use the Bm.exe utility from the command prompt to remove the DTS packages:

  1. Click Start, click Run, type cmd, and then click OK.
  2. Use the CD command to locate the folder where the Bm.exe file is located.

Note: By default, the Bm.exe file is located in the following folder:

  • BizTalk Server 2006: Microsoft BizTalk Server 2006\Tracking
  • BizTalk Server 2009: Microsoft BizTalk Server 2009\Tracking
  • BizTalk Server 2010: Microsoft BizTalk Server 2010\Tracking
  • BizTalk Server 2013: Microsoft BizTalk Server 2013\Tracking
  • BizTalk Server 2013R2: Microsoft BizTalk Server 2013R2\Tracking
Please use below command to locate Tracking folder (For BizTalk 2013),

CD C:\Program Files (x86)\Microsoft BizTalk Server 2013\Tracking


  • Bm.exe remove-all -DefinitionFile:"C:\Program Files (x86)\Microsoft BizTalk Server 2013\AS2ReportingActivityDefs.xml"
  • Bm.exe remove-all -DefinitionFile:"C:\Program Files (x86)\Microsoft BizTalk Server 2013\EdiReportingActivityDefs.xml"
  • Bm.exe remove-all -DefinitionFile:"C:\Program Files (x86)\Microsoft BizTalk Server 2013\EdiReportingActivityIndexes.xml"

Once remove the DTS packages, Try to configure the BizTalk Server EDI/AS2 Runtime feature again.

Solution 2: 
Use SQL Server Management Studio to remove the DTS packages:

To resolve this problem, use SQL Server Management Studio to remove the DTS packages. To do this, follow these steps:

  1. Start SQL Server Management Studio, click Connect, and then select Integration Services.
  2. In the Server type box, click Integration Services, enter the server name that you want in the Server name box, and then click Connect.
  3. Expand Stored Packages, and then expand MSDB.
  4. Right-click BAM_DM_InterchangeStatusActivity, click Delete, and then click Yes.
  5. Repeat step 4 for the following packages:
  • BAM_DM_AS2InterchangeActivity
  • BAM_DM_AS2MessageActivity
  • BAM_DM_AS2MdnActivity
Try to configure the BizTalk Server EDI/AS2 Runtime feature again.

Please visit the below support article for more information;
https://support.microsoft.com/en-us/kb/939549

No comments:

Post a Comment

About BizTalk Server Part - 2

This is next part of What is BizTalk Server blog article. Why do people still use BizTalk? In Microsoft stack, when it comes to In...