EDI/AS2 BizTalk Configuration Failed: DTS package BAM_DM_InterchangeStatusActivity already exists

During the Configuration of EDI/AS2 on BizTalk Server Configuration Wizard, sometimes you may encounter the following error, this is due to the BAM Activity, BAM Activity Definitations, BAM Indexes are already configured or available on the machine where you configuring the EDI/AS2 feature.

Error: The BAM deployment failed. DTS package BAM_DM_InterchangeStatusActivity already exists on server <SQL Server Name>.

To over come this issue, there are two options.

1) one you follow the Microsoft support page and download the fix (Refer Link#1).

2) Manually remove the BAM Activities, Denifitions and Indexes using the following command.


Use the BM.exe which will be located at the %btsinstallpath%\Tracking folder


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

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

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

After successful above command execution Re-Configure the EDI/AS2 features in BizTalk Configuration wizard and it will successful configure the EDI/AS2 Runtimes.


Link#1 https://support.microsoft.com/en-in/help/2269514/the-biztalk-edi-as2-runtime-configuration-may-fail-with-error-dts-pack


Hope this Helps!!!!

Accessing UNC Path folders like local drive

When there is need to access the UNC Path folders with local command prompt functionality we can achieve this with the help of NET USE command

following is the syntax of NET USE command

 NET USE
[devicename | *] [\\computername\sharename[\volume] [password | *]]
        [/USER:[domainname\]username]
        [/USER:[dotted domain name\]username]
        [/USER:[username@dotted domain name]
        [/SMARTCARD]
        [/SAVECRED]
        [[/DELETE] | [/PERSISTENT:{YES | NO}]]

NET USE {devicename | *} [password | *] /HOME

NET USE [/PERSISTENT:{YES | NO}]

Example : NET USE X: \\123.456.78.9\somesharedfolder\

after successfully execution of above command newly mapped drive X: is available to use it like a local machine drive.

Hope this Helps!!!

BizTalk Server Read-Only access

Once we move application to Production environment, it is become necessary to provide very tight security to BizTalk Administration Console as well as the users (Developers, Production Monitoring Users or Support Professionals) who need to monitor the application on regular basis.

To overcome the issue  out-of-box Biztalk provides the role BizTalk Operator who will have limited access to BizTalk Administration Console, though there are some area where out-of-box biztalk functionality needs some alteration.

One instance is Default BizTalk Operators Group users can Start/Stop Receive Locations, Send Port and Orchestrations, To maintain high level of security some client require us not to provide any update access to these areas as well.

We can achieve this by revoking Execute Permissions from 'BTS_Operators' database role on following stored procedures of BizTalkMgmtDB database.

[bts_ReceiveLocation_Status_Update]

[bts_SendPort_Status_Update]

[bts_SendPortGroup_Status_Update]


[bts_Orchestration_Status_Update]


Hope this Helps!!!!