Orphaned DTA Service Instances
Info
Receive instant alerts and take action when the number of Orphaned DTA Service Instances exceeds your user-defined monitoring threshold.
When the DTA Archive and Purge SQL Server Agent job archives and deletes tracking data from the BizTalk Server Tracking database (BizTalkDTADb), orphaned rows can accumulate in the dta_ServiceInstanceExceptions table. This issue often occurs when a message instance is resumed and then fails again, generating multiple rows with the same uidServiceInstanceId and uidActivityId. If these orphaned DTA service instances are not removed by the DTA Purge and Archive job, the BizTalkDTADb database can grow excessively large.

The Orphaned DTA service instances Resource in a Monitor View; it turns Warning or Error when orphaned instances exceed your thresholds.
Category Name = "Health Check"
Resource Name = "Orphaned DTA Service Instances"
What's evaluated for Orphaned DTA Service Instances?
Nodinite evaluates the state of the Resource Orphaned DTA Service Instances based on your user-defined thresholds:
| State | Status | Description | Actions |
|---|---|---|---|
| 🚫 Unavailable | Resource not available | Evaluation of the 'BizTalk Orphaned DTA Service Instances' is not possible due to network or security issues | Review prerequisites |
| ❌ Error | Too many instances exist | Number of instances exceeds the configured threshold | Details |
| ⚠️ Warning | Too many instances exist | Number of instances exceeds the configured threshold | Details |
| ✅ OK | Not too many instances exist | Number of instances is below configured thresholds | Details |
Tip
You can reconfigure the evaluated state using the Expected State feature on every Resource within Nodinite.
What remote actions are available?
- Details – Show the number of instances and remove orphaned instances.
- Edit – Manage thresholds (not yet available on Resource level).
- Metrics chart – Not yet available for this Resource.

Example of available Remote Actions. Every Health Check Resource has the same Action menu.
Details
Click the Action button, then select Details to view the orphaned instances and their row count.

Example of the Details menu item.

The Details modal when no orphaned instances exist, with an explanation and the prerequisites for the Remove action.
When Orphaned DTA Service Instances exist, click the Actions button in the Details modal and select Remove to set the dtEndTime values for orphaned instances. This enables the DTA Purge and Archive job (SQL Agent job) to clean these rows on the next run.

Example with the Actions button.
Click the Remove menu item to initiate the operation.

Edit thresholds
Change monitoring thresholds from the Health Check | Misc tab in the Configuration for your Nodinite Microsoft BizTalk Server Monitoring Agent.
If you click the Edit menu item in the Action button, a modal says This view is not available yet for the resource 'Orphaned DTA service instances'.

Example of the Edit menu item.

The Edit modal for Orphaned DTA Service Instances: change the thresholds in the Configuration instead.
Metrics chart
Not yet available for this Resource: the modal says No metrics found for this Resource.
Click the Action button and select Metrics chart.

Example of the Metrics chart menu item.

The Metrics chart modal for this Resource.
Next Steps
Related Topics
Nodinite Microsoft BizTalk Server Monitoring Agent Monitor Views