I've already verified the two spid, one of those was call a stored procedure that have nothing to do with that SELECT that you can see in

<frame...

Sorry, I've checked it with np++ now it's a valid XML.

The latest frame in blocking process stacktrace (SELECT COLUMN_LIST FROM TABLE_NAME "Tbl1005") it's the wrong one as that query is...

Sure, here it is with sensitive parte anonimized

Thanks!

<blocked-process-report id="116d394e-ac5c-4519-ba1c-1f637f5a9181" monitorLoop="544980" monitorDate="2024-10-15T10:49:38.31+02:00">
<blocked-process>
<process id="process16c893b1088" taskpriority="0" logused="0" waitresource="PAGE: 14:1:5803256 " waittime="5494" ownerId="6431344971" transactionname="user_transaction" lasttranstarted="2024-10-15T10:49:32.437" XDES="0x1610d03c040" lockMode="S" schedulerid="6" kpid="8784" status="suspended" spid="93"...