Wednesday, August 02, 2017

BizTalk 2013 R2 Orphaned BizTalk DTA service instances are not removed

In one of our BizTalk 2013 R2 environments, after running Message Box Viewer, a warning was reported: "DTA Orphaned Instances (Incompleted Instances in DTA but not in Msgbox). 2 (Large number can impact DTA Size and so perfs) - one possible cause is described in KB 978796 - Contact Microsoft CSS for more info !"

We have found links that share how to solve it manually:

https://www.biztalkadmin.com/orphaned-messages-in-the-tracking-database/

But with the last Cumulative Update 6 for Microsoft BizTalk Server 2013 R2, this problem is solved.

You should install Cumulative Update 6 for Microsoft BizTalk Server 2013 R2 and after install this update, you must manually update the DTA Purge and Archive job definition to pass the additional parameter.

The new parameter is @fHardDeleteRunningInstances if you want to clean up running service instances that are older than @nHardDeleteDays.

By default, this new parameter is set to 0. This continues the current behavior. If you require the new behavior, set this parameter to 1. This is an example:


No comments: