I'm trying to run a job in sql server agent for BiztalkMgmtDb and it is failing.
I'm getting below error
I downloaded BT terminator 2.1 and I'm not sure which category I need to select then execute
job failed for BiztalkMgmtDb failed
March 31st, 2015 12:28pm
Hi,
You need to share the error message with us from SQL server agent.
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.
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 12:48pm
For the complete list refer: Using BizTalk Terminator to resolve issues identified by BizTalk MsgBoxViewer and the BizTalk 2010 Monitor BizTalk Server Job
| Issue Identified by Monitor BizTalk Server Job | Terminator Resolution Task | Terminator View Task |
| Messages without any references | Repair Refcounts for All Messages
(in Manage task category) |
No view task - rely on the Monitor job to identify these |
| Messages without reference counts | Repair Refcounts for All Messages
(in Manage task category) |
View Count of Messages Without RefCounts |
| Messages with reference count less than 0 | Repair Refcounts for All Messages
(in Manage task category) |
No view task - rely on the Monitor job to identify these |
| Message references without spool rows | Run the View task first. If the InstanceExists value is true, use the uidInstanceID value to find the instance in Admin Console and terminate it. If the InstanceExists value is false, that means this message ref is missing spool row AND instances row. In that case you can run the DELETE Orphaned Messages Terminator task (in Delete task category) |
View Message References Without Spool Rows. |
| Message references without instances | DELETE Orphaned Messages in All Hosts
DELETE Orphaned Messages in Specific Host (both in Delete task category) |
View Count of Orphaned Messages by Host |
| Instance state without instances | No resolution task - contact MS support | No view task - rely on the Monitor job or MBV to identify these |
| Instance subscriptions without corresponding instances | DELETE Orphaned Instance Subscriptions
(in Delete task category) |
View Count of Orphaned Instance Subscriptions |
| Orphaned DTA service instances | Repair Orphaned DTA Service Instances
(in Manage task category) |
View Count of Orphaned DTA Service Instances |
| Orphaned DTA service instance exceptions | DELETE Orphaned DTA Service Instance Exceptions
(in Delete task category) |
View Count of Orphaned DTA Service Instance Exceptions |
| TDDS is not running on any host instance when global tracking option is enabled | No resolution task within terminator - BizTalk Administrator needs to make sure one of the hosts has Tracking enabled and there is a running host instance for that host | No view task - rely on the Monitor job or MBV to identify these |
March 31st, 2015 12:51pm
I'm not sure which category this falls into (Repair Refcounts for All Messages)
from the list below? can you specify?
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 1:03pm
You said (You need to share the error message with us from SQL server agent.)
This is the error:
March 31st, 2015 1:10pm
For Repair Refcounts for All Messages, Its -> View Count of Messages Without RefCounts
Rachit
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 1:11pm
Before running Terminator, always make sure you have a BizTalk Backup of your databases, all the BTS hosts have been stopped, BTS SQL Agent jobs have been disabled.
Rachit
March 31st, 2015 1:18pm
Hold on! Don't do anything yet, especially running Terminator!
First, the Monitor BizTalk Server job is, well...not too reliable. I always leave it disabled.
If you suspect any issues, run MessageBox Viewer or BizTalk Health Monitor.
If MBV/BHM reports any issues, please ask for advice on those.
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 1:30pm
on the biztalk side, when I try to debug an orchestration for example, I receive below error even though I have tracking enabled on orchestration, receive ports and hosts tracking are enabled too.
March 31st, 2015 1:47pm
Well, that is a completely different issue.
Do you have at least one Tracking Host running?
Are all of the other SQL Agent jobs running without error?
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 2:09pm
You should verify that:
1) Hosts of your application are running
2) Tracking host is running. If the tracking host is not running Data cant be moved to tracking database in consequence it cannot be seen by the Orchestration debugger.
It will resolve your error.
Just as a note related to this message: When an orchestration instance is suspended by a breakpoint and you want to eliminate the breakpoint, you must query an older instance (no the current) and delete the breakpoint on it.
Rachit
March 31st, 2015 2:10pm
host that is running the application has tracking enabled.
other sql agent jobs are running fine.
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 4:10pm
Hold on! Don't do anything yet, especially running Terminator!
First, the Monitor BizTalk Server job is, well...not too reliable. I always leave it disabled.
If you suspect any issues, run MessageBox Viewer or BizTalk Health Monitor.
If MBV/BHM reports any issues, please ask for advice on those.
- Marked as answer by Christiane0696 14 hours 48 minutes ago
March 31st, 2015 5:27pm
Hold on! Don't do anything yet, especially running Terminator!
First, the Monitor BizTalk Server job is, well...not too reliable. I always leave it disabled.
If you suspect any issues, run MessageBox Viewer or BizTalk Health Monitor.
If MBV/BHM reports any issues, please ask for advice on those.
- Marked as answer by Christiane0696 Wednesday, April 01, 2015 4:15 PM
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 5:27pm
Hold on! Don't do anything yet, especially running Terminator!
First, the Monitor BizTalk Server job is, well...not too reliable. I always leave it disabled.
If you suspect any issues, run MessageBox Viewer or BizTalk Health Monitor.
If MBV/BHM reports any issues, please ask for advice on those.
- Marked as answer by Christiane0696 Wednesday, April 01, 2015 4:15 PM
March 31st, 2015 5:27pm
Well, that is a completely different issue.
Do you have at least one Tracking Host running?
Are all of the other SQL Agent jobs running without error?
- Marked as answer by Christiane0696 14 hours 48 minutes ago
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 6:06pm
Well, that is a completely different issue.
Do you have at least one Tracking Host running?
Are all of the other SQL Agent jobs running without error?
- Marked as answer by Christiane0696 Wednesday, April 01, 2015 4:15 PM
March 31st, 2015 6:06pm
Well, that is a completely different issue.
Do you have at least one Tracking Host running?
Are all of the other SQL Agent jobs running without error?
- Marked as answer by Christiane0696 Wednesday, April 01, 2015 4:15 PM
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 6:06pm
I would also suggest you to turn off the BizTalk Monitor job as it may fail even if some CU was missing:)
So if you want to check the health of your environment run Message Box Viewer. This will give the actual state of your enviroment. It will also generate CleanupScript.xml file which can be imported in Terminator tool and this will only list tasks which are relevant to your environment.
Regarding the tracking issue, it can happen because of multiple reasons.
Have a look into the below article which gives all the checkpoints to troubleshoot this issue.
April 1st, 2015 12:10am
This topic is archived. No further replies will be accepted.
Other recent topics
