Today lots of messages were getting suspended in the production env and to find the exact reason for this sudden messages getting suspended, looked into the Event Log and found below two errors:
As can be interpreted from error message, the allocated space for BizTalkMsgBoxDb was full.
Why it happened:
What to do:
The first thing was to check if AutoGrowth is enabled or not on BizTalkMsgBoxDb, and it was.
Then had a look at the jobs and found that DTA Purge and Archive Job was disabled since a week (don't know how) and that was the reason for this issue.
So to fix the issue, reconfigured the job and enabled it and also purged the Tracking database.
If you have questions or suggestions, feel free to do in comments section below !!!
Do share if you find this helpful .......
Knowledge Sharing is Caring !!!!!!
Nice post. Maintenance job are important to be running for health environment.
ReplyDelete