MsgBox Database Integrity in biztalk BHM Report

Question

Hi Guys

I am getting MsgBox Database Integrity  issue in prod environment , i used terminator tool couple time to delete this messages but this occuring very frequently.

I want to know integrity issue will occurs due to Zombie message or orphane messages or both ?

Is there any query to check zombie message count in biztalk database ? 

how can get rid of Integrity issue in biztalk permanently is there any way? 

Answer 1

Zombies are a different issue and shouldn't be picked up by the BHM report, they will just suspend.

To see the issue you can run the same stored procedure that the SQL Agent job does to get the error string, but BHM should be showing you that anyway.

Orphaned instances can be automatically cleaned up see The BizTalk Purge & Archive Job now supports clean-up of orphaned instances

Answer 2

Thanks colin for providing information

---

BizTalk User