Manually purge DTA

Hi everyone, on development and validation server, I frequently got space disk issue due to DTA log size.

So, if your developpers don’t want to configure all biztalk jobs, or you forget to configure those job on validation stage please follow the next instructions :

  • Stop all BizTalk Host Instance
  • Stop IIS Server
  • Stop SSO service
  • Connect to BizTalk SQL server with SQL Server Management Studio (Run ssms)
  • In Object explorer go to BizTalkDtaDb
  • Execute Stored procedure dtasp_PurgeAllCompletedTrackingData
  • After execution, I recommend to shrink the database
  • Now check the Database size, and you’ll see that it’s empty 🙂

 

For more information please go on http://msdn.microsoft.com/en-us/library/aa561918.aspx

No instance in « track message service instance »

This is a problem that I saw recently. After a BizTalk Configuration step with domain account.

When you execute a BizTalk Application you can see the Active Service Instance, but after you can’t see any tracking data.

Three checks :

  • First one verify you have an host with tracking active
  • Second one check that activity tracking is enable on orchestration or port
  • Third one go on SQL server log and verify that you don’t have « access failed login » event, if you found it give the right g to read write to the DTA for the Host Instance with Tracking enable