Biztalk SQL job blocked process report

Nam Phan 1 Reputation point
2022-09-27T03:25:29.347+00:00

Hi all,

I'm having SQL block process issue which is related to Biztalk SQL job MessageBox_Message_ManageRefCountLog and has no blocking process in the report as follows
REPORT:
<TextData><blocked-process-report monitorLoop="162141">
<blocked-process>
<process>
<executionStack>
<frame line="28" stmtstart="1692" stmtend="2578" sqlhandle="0x03000b00695213734bdeb30049ae000001000000000000000000000000000000000000000000000000000000"></frame>
<frame line="81" stmtstart="4908" stmtend="5056" sqlhandle="0x03000b0014bfef754ddeb30049ae000001000000000000000000000000000000000000000000000000000000"></frame>
<frame line="1" stmtend="64" sqlhandle="0x01000b0051b8d93690bfcc7f4b02000000000000000000000000000000000000000000000000000000000000"></frame>
</executionStack>
<inputbuf>
exec bts_ManageMessageRefCountLog </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process></process>
</blocking-process>
</blocked-process-report>
</TextData>

The issue does not happen very often and the SQL job still continue executing normally so could someone please advise if it is fine to ignore the issue?

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
349 questions
0 comments No comments
{count} votes