none
Monitor BizTalk Server JOB Fails RRS feed

  • Question

  • Unfortunately the Monitor BizTalk Server JOB Fails. 

    When I right click on the failed step I don't get a context menu so I don't know what can be done to figure out what went wrong and how to fix it ?


    Tuesday, May 2, 2017 5:01 PM

Answers

  • Hi,

    The error states "8 Messages with refcount less than 0". Basically 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.

    To fix "messages with refcount less than 0" error run Repair Refcounts for All Messages in BTS Terminator/BHM. 

    Refer: http://sqlserverdungeoncrawl.blogspot.co.uk/2013/12/monitor-biztalk-server-biztalkmgmtdb.html

    Refer this post for your issue: Message with refcount less than 0.

    The steps to be followed to resolve your issue: 

    Run the terminator tool via BHM or standalone.
    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. 

    Open "Terminator" , specify server name and database information. Check all checkboxes in order to confirm that you did backup and stop all instances and SQL jobs. Find task "Repair Refcounts for All Messages" and execute it (no parameters is required). 

    After performing above steps please run SQL job "Monitor BizTalk Server" and  confirmed that issue resolve.



    Rachit Sikroria (Microsoft Azure MVP)

    Tuesday, May 2, 2017 5:26 PM
    Moderator
  • When I right click on the failed step I don't get a context menu so I don't know what can be done to figure out what went wrong and how to fix it ?

    I assume you are on BizTalk 2013 (or R2)?

    BizTalk Health Monitor (BHM) is a great tool to get more in depth help and information when eg Biztalk SQL Jobs fails
    https://www.microsoft.com/en-us/download/details.aspx?id=43716

    BHM includes the terminator tool as well, now called Maintenance

    rgds  /Peter

    Tuesday, May 2, 2017 5:34 PM

All replies

  • Hi,

    The error states "8 Messages with refcount less than 0". Basically 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.

    To fix "messages with refcount less than 0" error run Repair Refcounts for All Messages in BTS Terminator/BHM. 

    Refer: http://sqlserverdungeoncrawl.blogspot.co.uk/2013/12/monitor-biztalk-server-biztalkmgmtdb.html

    Refer this post for your issue: Message with refcount less than 0.

    The steps to be followed to resolve your issue: 

    Run the terminator tool via BHM or standalone.
    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. 

    Open "Terminator" , specify server name and database information. Check all checkboxes in order to confirm that you did backup and stop all instances and SQL jobs. Find task "Repair Refcounts for All Messages" and execute it (no parameters is required). 

    After performing above steps please run SQL job "Monitor BizTalk Server" and  confirmed that issue resolve.



    Rachit Sikroria (Microsoft Azure MVP)

    Tuesday, May 2, 2017 5:26 PM
    Moderator
  • When I right click on the failed step I don't get a context menu so I don't know what can be done to figure out what went wrong and how to fix it ?

    I assume you are on BizTalk 2013 (or R2)?

    BizTalk Health Monitor (BHM) is a great tool to get more in depth help and information when eg Biztalk SQL Jobs fails
    https://www.microsoft.com/en-us/download/details.aspx?id=43716

    BHM includes the terminator tool as well, now called Maintenance

    rgds  /Peter

    Tuesday, May 2, 2017 5:34 PM