Resolving "DTS Package BAM_DM_ResendJournalActivity Already Exists On Server" Error

I have seen many people 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 an error : "DTS package BAM_DM_ResendJournalActivity already exists on server "

I have seen many people 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 try to configure it again you will get an 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 the 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 you 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

G

M

T

Detect languageAfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBelarusianBengaliBosnianBulgarianCatalanCebuanoChichewaChinese (Simplified)Chinese (Traditional)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHausaHebrewHindiHmongHungarianIcelandicIgboIndonesianIrishItalianJapaneseJavaneseKannadaKazakhKhmerKoreanLaoLatinLatvianLithuanianMacedonianMalagasyMalayMalayalamMalteseMaoriMarathiMongolianMyanmar (Burmese)NepaliNorwegianPersianPolishPortuguesePunjabiRomanianRussianSerbianSesothoSinhalaSlovakSlovenianSomaliSpanishSundaneseSwahiliSwedishTajikTamilTeluguThaiTurkishUkrainianUrduUzbekVietnameseWelshYiddishYorubaZulu

AfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBelarusianBengaliBosnianBulgarianCatalanCebuanoChichewaChinese (Simplified)Chinese (Traditional)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHausaHebrewHindiHmongHungarianIcelandicIgboIndonesianIrishItalianJapaneseJavaneseKannadaKazakhKhmerKoreanLaoLatinLatvianLithuanianMacedonianMalagasyMalayMalayalamMalteseMaoriMarathiMongolianMyanmar (Burmese)NepaliNorwegianPersianPolishPortuguesePunjabiRomanianRussianSerbianSesothoSinhalaSlovakSlovenianSomaliSpanishSundaneseSwahiliSwedishTajikTamilTeluguThaiTurkishUkrainianUrduUzbekVietnameseWelshYiddishYorubaZulu

Text-to-speech function is limited to 200 characters

Options : History : Feedback : Donate

Close

G

M

T

Detect languageAfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBelarusianBengaliBosnianBulgarianCatalanCebuanoChichewaChinese (Simplified)Chinese (Traditional)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHausaHebrewHindiHmongHungarianIcelandicIgboIndonesianIrishItalianJapaneseJavaneseKannadaKazakhKhmerKoreanLaoLatinLatvianLithuanianMacedonianMalagasyMalayMalayalamMalteseMaoriMarathiMongolianMyanmar (Burmese)NepaliNorwegianPersianPolishPortuguesePunjabiRomanianRussianSerbianSesothoSinhalaSlovakSlovenianSomaliSpanishSundaneseSwahiliSwedishTajikTamilTeluguThaiTurkishUkrainianUrduUzbekVietnameseWelshYiddishYorubaZulu

AfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBelarusianBengaliBosnianBulgarianCatalanCebuanoChichewaChinese (Simplified)Chinese (Traditional)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHausaHebrewHindiHmongHungarianIcelandicIgboIndonesianIrishItalianJapaneseJavaneseKannadaKazakhKhmerKoreanLaoLatinLatvianLithuanianMacedonianMalagasyMalayMalayalamMalteseMaoriMarathiMongolianMyanmar (Burmese)NepaliNorwegianPersianPolishPortuguesePunjabiRomanianRussianSerbianSesothoSinhalaSlovakSlovenianSomaliSpanishSundaneseSwahiliSwedishTajikTamilTeluguThaiTurkishUkrainianUrduUzbekVietnameseWelshYiddishYorubaZulu

Text-to-speech function is limited to 200 characters

Options : History : Feedback : Donate

Close