BTSTerminator is a handy tool for managing your BizTalk database environment. Unfortunately it's design is a little confusing.
1. Enter the database server name
2. Enter the name of the management database
BTSTerminator requires that you verify that all the BT databases are backed up, that all host instances on the application server have been stopped, and that all BT SQL Agent jobs are stopped before you can proceed. The thing to note here is that BTSTerminator does not verify these things for you so you need to verify that these are done and then check the check boxes before proceeding. Once everything is checked you can click the Connect button.
The next screen is where things get confusing.
The bottom row of buttons are not actions, they are categories. So if you want to delete orphaned instances you first click the Delete button which changes the options in the top drop down menu.
Basically, all BTSTerminator is, is a collection of various SQL Scripts that are accessed and executed through the (clunky) UI.
1. Select the category of action you want to do (View, Delete, Manage, etc)
2. Select the appropriate task from the drop down menu
3. Click the Parameters tab and verify the parameters (usually just a confirmation of the server and database names)
4. Click Execute
BTSTerminator will then execute the chosen script on the server/database and display the results on the Results tab.
Showing posts with label BTS Terminator. Show all posts
Showing posts with label BTS Terminator. Show all posts
Monday, December 30, 2013
Monitor BizTalk Server (BizTalkMgmtDb) job failing
In BizTalk Server 2010 there's a job called Monitor BizTalk Server (BizTalkMgmtDb). This job checks the management and tracking databases and looks for any inconsistencies. If there are none then the job completes successfully. If there are inconsistencies, then the job fails.
The job failing is simply telling you that you must take care of the inconsistencies.
Error message:
Executed as user: [ my user]. 2 Orphaned DTA Service Instances in USWBIZDBSTG01.BizTalkDTADb, 1 Messages with refcount less than 0 in USWBIZDBSTG01.BizTalkMsgBoxDb [SQSTATE 42000] (Error 50000). The step failed.
The numbers may change based on how many inconsistencies the job finds. So don't be surprised if you have more than what I've specified here.
To fix the issue simply run BizTalk Terminator. A search on Microsoft.com will point you to the free download.
The job failing is simply telling you that you must take care of the inconsistencies.
Error message:
Executed as user: [ my user]. 2 Orphaned DTA Service Instances in USWBIZDBSTG01.BizTalkDTADb, 1 Messages with refcount less than 0 in USWBIZDBSTG01.BizTalkMsgBoxDb [SQSTATE 42000] (Error 50000). The step failed.
The numbers may change based on how many inconsistencies the job finds. So don't be surprised if you have more than what I've specified here.
To fix the issue simply run BizTalk Terminator. A search on Microsoft.com will point you to the free download.
- To fix "messages with refcount less than 0" error run Repair Refcounts for All Messages in BTS Terminator.
- To fix "orphaned DTA service instances" error run DELETE Orphaned DTA Service Instance Expections in BTS Terminator.
Subscribe to:
Posts (Atom)