Skip to content

Instantly share code, notes, and snippets.

/gist:4c8df0a69cf5e2bd0a0741aed8b10019 Secret

Created June 12, 2017 11:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/4c8df0a69cf5e2bd0a0741aed8b10019 to your computer and use it in GitHub Desktop.
Save anonymous/4c8df0a69cf5e2bd0a0741aed8b10019 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Set of BPR on the same resource, one of which has an empty blocking process:
<blocked-process-report monitorLoop="1748823">
<blocked-process>
<process id="process2552c1fc28" taskpriority="0" logused="24223944" waitresource="PAGE: 5:1:7984962 " waittime="141595" ownerId="4916867614" transactionname="user_transaction" lasttranstarted="2017-04-20T16:28:50.153" XDES="0x20532cc3b0" lockMode="U" schedulerid="3" kpid="226936" status="suspended" spid="85" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-04-20T16:28:55.863" lastbatchcompleted="2017-04-20T16:28:55.863" lastattention="2017-04-18T05:46:57.453" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4916867614" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="156" stmtend="436" sqlhandle="0x02000000e0282633a1c3f3eac4c1b7f056a7e6faee99bffe0000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 nvarchar(31),@P2 int,@P3 bigint,@P4 nvarchar(5),@P5 nvarchar(31),@P6 int)UPDATE PRODCALCTRANS SET RESOURCE_=@P1,RECVERSION=@P2 WHERE (((PARTITION=@P3) AND (DATAAREAID=@P4)) AND ((RESOURCE_=@P5) AND (CALCTYPE=@P6))) </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="sleeping" spid="226" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2017-04-20T16:31:17.683" lastbatchcompleted="2017-04-20T16:31:17.683" lastattention="2017-04-20T16:09:47.323" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4916813322" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack/>
<inputbuf>
(@P1 bigint,@P2 nvarchar(5),@P3 bigint,@P4 datetime2,@P5 nvarchar(21),@P6 int,@P7 int,@P8 datetime2)SELECT TOP 1 T1.PROJEMPLTRANSID,T1.TRANSTABLEID,T1.TRANSRECID,T1.DEFAULTDIMENSION,T1.WORKFLOWSTATUS,T1.WORKER,T1.WORKERPILOT,T1.WRKCTRIDPILOT,T1.ACTIVE,T1.PROFILEDATE,T1.STARTDATE,T1.STOPDATE,T1.STARTTIME,T1.STOPTIME,T1.STAMPTYPE,T1.JOBID,T1.CORRSTARTTIME,T1.CORRSTOPTIME,T1.JOBREF,T1.TRANSID,T1.SECONDS,T1.QTYGOOD,T1.QTYERROR,T1.JOBFINISHED,T1.MODULE,T1.JOBTYPE,T1.CORRSTARTDATE,T1.CORRSTOPDATE,T1.LOG,T1.STAMPTYPESPEC,T1.ABSENCEPAYQTY,T1.BREAKSECONDS,T1.SYSQTYSTARTUP,T1.SYSQTYGOOD,T1.SYSQTYERROR,T1.ERRORCAUSE,T1.ROUTEJOBTYPE,T1.BREAKTOLERANCE,T1.OPRNUM,T1.TERMREGSTARTRECID,T1.TERMREGSTOPRECID,T1.JOBIDABS,T1.WRKCTRID,T1.JOURREGTYPE,T1.JOBREFTYPE,T1.JOBPAYTYPE,T1.QTYSTARTUP,T1.SECONDSONREG,T1.SECONDSONTRANS,T1.ACTOPRID,T1.PIECERATEPAYCOSTTYPEMIN,T1.PIECERATEPAYMINRATE,T1.PIECERATEPAYRATE,T1.DOPRODUPDATE,T1.PROJCATEGORY,T1.ERRORSPECIFICATION,T1.SYSERRORSPECIFICATION,T1.ONCALLACTIVITY,T1.TERMSTART,T1.TERMSTOP,T1.PDS </inputbuf>
</process>
</blocking-process>
</blocked-process-report>
<blocked-process-report monitorLoop="1748824">
<blocked-process>
<process id="process2552c1fc28" taskpriority="0" logused="24223944" waitresource="PAGE: 5:1:7984962 " waittime="146611" ownerId="4916867614" transactionname="user_transaction" lasttranstarted="2017-04-20T16:28:50.153" XDES="0x20532cc3b0" lockMode="U" schedulerid="3" kpid="226936" status="suspended" spid="85" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-04-20T16:28:55.863" lastbatchcompleted="2017-04-20T16:28:55.863" lastattention="2017-04-18T05:46:57.453" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4916867614" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="156" stmtend="436" sqlhandle="0x02000000e0282633a1c3f3eac4c1b7f056a7e6faee99bffe0000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 nvarchar(31),@P2 int,@P3 bigint,@P4 nvarchar(5),@P5 nvarchar(31),@P6 int)UPDATE PRODCALCTRANS SET RESOURCE_=@P1,RECVERSION=@P2 WHERE (((PARTITION=@P3) AND (DATAAREAID=@P4)) AND ((RESOURCE_=@P5) AND (CALCTYPE=@P6))) </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process/>
</blocking-process>
</blocked-process-report>
<blocked-process-report monitorLoop="1748825">
<blocked-process>
<process id="process2552c1fc28" taskpriority="0" logused="24223944" waitresource="PAGE: 5:1:7984962 " waittime="151626" ownerId="4916867614" transactionname="user_transaction" lasttranstarted="2017-04-20T16:28:50.153" XDES="0x20532cc3b0" lockMode="U" schedulerid="3" kpid="226936" status="suspended" spid="85" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-04-20T16:28:55.863" lastbatchcompleted="2017-04-20T16:28:55.863" lastattention="2017-04-18T05:46:57.453" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4916867614" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="156" stmtend="436" sqlhandle="0x02000000e0282633a1c3f3eac4c1b7f056a7e6faee99bffe0000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 nvarchar(31),@P2 int,@P3 bigint,@P4 nvarchar(5),@P5 nvarchar(31),@P6 int)UPDATE PRODCALCTRANS SET RESOURCE_=@P1,RECVERSION=@P2 WHERE (((PARTITION=@P3) AND (DATAAREAID=@P4)) AND ((RESOURCE_=@P5) AND (CALCTYPE=@P6))) </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="sleeping" spid="226" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2017-04-20T16:31:27.707" lastbatchcompleted="2017-04-20T16:31:27.707" lastattention="2017-04-20T16:09:47.323" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4916813322" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack/>
<inputbuf>
(@P1 bigint,@P2 nvarchar(5),@P3 nvarchar(21),@P4 int,@P5 int,@P6 int,@P7 int,@P8 int,@P9 int,@P10 int,@P11 int,@P12 int,@P13 int,@P14 int,@P15 int,@P16 int,@P17 int,@P18 int,@P19 int,@P20 int,@P21 int,@P22 int,@P23 int,@P24 int,@P25 int,@P26 int,@P27 int,@P28 int,@P29 int,@P30 int,@P31 int,@P32 int,@P33 int,@P34 int,@P35 int,@P36 int,@P37 int,@P38 int,@P39 int,@P40 int,@P41 int,@P42 int,@P43 int,@P44 int,@P45 int)SELECT T1.NODEID,T1.CODE,T1.DESCRIPTION,T1.TYPE,T1.HEADER,T1.TOTAL,T1.PRICETYPE,T1.COSTGROUPID,T1.PARENTNODEID,T1.LEVEL_,T1.LINENUM,T1.CALCULATIONFACTORPERITEM,T1.SHEETID,T1.CALCULATIONRATESUBTYPE,T1.CALCULATIONSURCHARGESUBTYPE,T1.CALCULATIONUNITBASEDSUBTYPE,T1.DEFAULTDIMENSION,T1.INDIRECTABSORPTIONLEDGERDIMENSION,T1.INDIRECTABSORPTIONOFFSETLEDGERDIMENSION,T1.ESTIMINDIRECTABSORPOFFSETLEDGERDIMENSION,T1.ESTIMATEDINDIRECTABSORPLEDGERDIMENSION,T1.RECVERSION,T1.PARTITION,T1.RECID FROM COSTSHEETNODETABLE T1 WHERE (((PARTITION=@P1) AND (DATAAREAID=@P2)) AND (((SHEETID=@P3) AND (PARENTNODEID=@P4)) AND (((( </inputbuf>
</process>
</blocking-process>
</blocked-process-report>
<blocked-process-report monitorLoop="1748827">
<blocked-process>
<process id="process2552c1fc28" taskpriority="0" logused="24223944" waitresource="PAGE: 5:1:7984962 " waittime="161626" ownerId="4916867614" transactionname="user_transaction" lasttranstarted="2017-04-20T16:28:50.153" XDES="0x20532cc3b0" lockMode="U" schedulerid="3" kpid="226936" status="suspended" spid="85" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-04-20T16:28:55.863" lastbatchcompleted="2017-04-20T16:28:55.863" lastattention="2017-04-18T05:46:57.453" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4916867614" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="156" stmtend="436" sqlhandle="0x02000000e0282633a1c3f3eac4c1b7f056a7e6faee99bffe0000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 nvarchar(31),@P2 int,@P3 bigint,@P4 nvarchar(5),@P5 nvarchar(31),@P6 int)UPDATE PRODCALCTRANS SET RESOURCE_=@P1,RECVERSION=@P2 WHERE (((PARTITION=@P3) AND (DATAAREAID=@P4)) AND ((RESOURCE_=@P5) AND (CALCTYPE=@P6))) </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="sleeping" spid="226" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2017-04-20T16:31:37.710" lastbatchcompleted="2017-04-20T16:31:37.710" lastattention="2017-04-20T16:09:47.323" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4916813322" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack/>
<inputbuf>
(@P1 bigint,@P2 nvarchar(5),@P3 nvarchar(21),@P4 int,@P5 numeric(32,16),@P6 bigint)SELECT SUM(T1.COSTALLOCATIONPCT) FROM PMFPRODCOBY T1 WHERE (((PARTITION=@P1) AND (DATAAREAID=@P2)) AND ((((PRODID=@P3) AND (PRODUCTTYPE=@P4)) AND (COSTALLOCATIONPCT&gt;@P5)) AND (RECID&lt;&gt;@P6))) </inputbuf>
</process>
</blocking-process>
</blocked-process-report>
Data from the requests table
CaptureTime session_id request_id start_time status command sql_handle statement_start_offset statement_end_offset plan_handle database_id user_id connection_id blocking_session_id wait_type wait_time last_wait_type wait_resource open_transaction_count open_resultset_count transaction_id context_info percent_complete estimated_completion_time cpu_time total_elapsed_time scheduler_id task_address reads writes logical_reads text_size language date_format date_first quoted_identifier arithabort ansi_null_dflt_on ansi_defaults ansi_warnings ansi_padding ansi_nulls concat_null_yields_null transaction_isolation_level lock_timeout deadlock_priority row_count prev_error nest_level granted_query_memory executing_managed_code group_id query_hash query_plan_hash statement_sql_handle statement_context_id login_time host_name program_name host_process_id client_version client_interface_name security_id login_name nt_domain nt_user_name memory_usage total_scheduled_time endpoint_id last_request_start_time last_request_end_time is_user_process original_security_id original_login_name last_successful_logon last_unsuccessful_logon unsuccessful_logons authenticating_database_id
2017-04-20 16:29:00.9104260 85 0 2017-04-20 16:28:55.863 suspended UPDATE 0x02000000E0282633A1C3F3EAC4C1B7F056A7E6FAEE99BFFE0000000000000000000000000000000000000000 156 436 0x06000500E02826338091325C0700000001000000000000000000000000000000000000000000000000000000 5 1 8BB1B8B3-9B63-4FE8-A55B-4A698B0E2FB8 226 LCK_M_U 4823 LCK_M_U PAGE: 5:1:7984962 2 1 4916867614 0x 0 0 184 5043 2 0x0000002552C1FC28 0 0 65868 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 48 0 2 0 0 1 0xE8314A4784E8DC70 0xDF6F63781161DCAC NULL NULL 2017-04-18 05:46:33.270 Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 12 41638 4 2017-04-20 16:28:55.863 2017-04-20 16:28:55.863 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-20 16:29:50.7065623 85 0 2017-04-20 16:28:55.863 suspended UPDATE 0x02000000E0282633A1C3F3EAC4C1B7F056A7E6FAEE99BFFE0000000000000000000000000000000000000000 156 436 0x06000500E02826338091325C0700000001000000000000000000000000000000000000000000000000000000 5 1 8BB1B8B3-9B63-4FE8-A55B-4A698B0E2FB8 226 LCK_M_U 54614 LCK_M_U PAGE: 5:1:7984962 2 1 4916867614 0x 0 0 184 54834 2 0x0000002552C1FC28 0 0 65868 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 48 0 2 0 0 1 0xE8314A4784E8DC70 0xDF6F63781161DCAC NULL NULL 2017-04-18 05:46:33.270 Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 12 41638 4 2017-04-20 16:28:55.863 2017-04-20 16:28:55.863 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-20 16:29:10.9571246 85 0 2017-04-20 16:28:55.863 suspended UPDATE 0x02000000E0282633A1C3F3EAC4C1B7F056A7E6FAEE99BFFE0000000000000000000000000000000000000000 156 436 0x06000500E02826338091325C0700000001000000000000000000000000000000000000000000000000000000 5 1 8BB1B8B3-9B63-4FE8-A55B-4A698B0E2FB8 226 LCK_M_U 14869 LCK_M_U PAGE: 5:1:7984962 2 1 4916867614 0x 0 0 184 15089 2 0x0000002552C1FC28 0 0 65868 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 48 0 2 0 0 1 0xE8314A4784E8DC70 0xDF6F63781161DCAC NULL NULL 2017-04-18 05:46:33.270 Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 12 41638 4 2017-04-20 16:28:55.863 2017-04-20 16:28:55.863 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-20 16:29:20.0194495 85 0 2017-04-20 16:28:55.863 suspended UPDATE 0x02000000E0282633A1C3F3EAC4C1B7F056A7E6FAEE99BFFE0000000000000000000000000000000000000000 156 436 0x06000500E02826338091325C0700000001000000000000000000000000000000000000000000000000000000 5 1 8BB1B8B3-9B63-4FE8-A55B-4A698B0E2FB8 226 LCK_M_U 23932 LCK_M_U PAGE: 5:1:7984962 2 1 4916867614 0x 0 0 184 24152 2 0x0000002552C1FC28 0 0 65868 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 48 0 2 0 0 1 0xE8314A4784E8DC70 0xDF6F63781161DCAC NULL NULL 2017-04-18 05:46:33.270 Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 12 41638 4 2017-04-20 16:28:55.863 2017-04-20 16:28:55.863 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-20 16:29:30.0973812 85 0 2017-04-20 16:28:55.863 suspended UPDATE 0x02000000E0282633A1C3F3EAC4C1B7F056A7E6FAEE99BFFE0000000000000000000000000000000000000000 156 436 0x06000500E02826338091325C0700000001000000000000000000000000000000000000000000000000000000 5 1 8BB1B8B3-9B63-4FE8-A55B-4A698B0E2FB8 226 LCK_M_U 34010 LCK_M_U PAGE: 5:1:7984962 2 1 4916867614 0x 0 0 184 34230 2 0x0000002552C1FC28 0 0 65868 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 48 0 2 0 0 1 0xE8314A4784E8DC70 0xDF6F63781161DCAC NULL NULL 2017-04-18 05:46:33.270 Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 12 41638 4 2017-04-20 16:28:55.863 2017-04-20 16:28:55.863 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-20 16:29:40.1755329 85 0 2017-04-20 16:28:55.863 suspended UPDATE 0x02000000E0282633A1C3F3EAC4C1B7F056A7E6FAEE99BFFE0000000000000000000000000000000000000000 156 436 0x06000500E02826338091325C0700000001000000000000000000000000000000000000000000000000000000 5 1 8BB1B8B3-9B63-4FE8-A55B-4A698B0E2FB8 226 LCK_M_U 44088 LCK_M_U PAGE: 5:1:7984962 2 1 4916867614 0x 0 0 184 44308 2 0x0000002552C1FC28 0 0 65868 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 48 0 2 0 0 1 0xE8314A4784E8DC70 0xDF6F63781161DCAC NULL NULL 2017-04-18 05:46:33.270 Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 12 41638 4 2017-04-20 16:28:55.863 2017-04-20 16:28:55.863 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
Another set of BPR
<blocked-process-report monitorLoop="1759480">
<blocked-process>
<process id="processf4e8748c8" taskpriority="0" logused="36060" waitresource="KEY: 5:72057598722834432 (c93b90d0fabe)" waittime="62804" ownerId="4954845452" transactionname="user_transaction" lasttranstarted="2017-04-21T07:19:47.540" XDES="0x1a604530b0" lockMode="U" schedulerid="4" kpid="138692" status="suspended" spid="113" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-04-21T07:19:47.647" lastbatchcompleted="2017-04-21T07:19:47.643" lastattention="2017-04-21T06:03:26.407" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4954845452" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="108" stmtend="332" sqlhandle="0x02000000da94430599ae7ab3cd3f9eaa236f4f42b99094730000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 int,@P2 nvarchar(257),@P3 int,@P4 bigint,@P5 int)UPDATE JMGSTAMPJOURNALTRANS SET STOPTIME=@P1,TERMSTOP=@P2,RECVERSION=@P3 WHERE ((RECID=@P4) AND (RECVERSION=@P5)) </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="running" spid="108" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2017-04-21T07:20:50.160" lastbatchcompleted="2017-04-21T07:20:50.160" lastattention="2017-04-21T05:46:34.530" clientapp="Microsoft Dynamics AX" hostname="xx" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4954744115" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="110" stmtend="678" sqlhandle="0x02000000c1d98d035a22212146870e6198edf0b10f8a148a0000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 bigint,@P2 nvarchar(5),@P3 int,@P4 bigint,@P5 int)SELECT TOP 1 T1.PROFILEDATE,T1.POSTED,T1.TRANSTABLEID,T1.CHANGELOGTYPE,T1.TRANSRECID,T1.WORKER,T1.RECVERSION,T1.PARTITION,T1.RECID,T1.CHANGEDTRANSACTION FROM JMGCHANGELOG T1 WHERE (((PARTITION=@P1) AND (DATAAREAID=@P2)) AND (((TRANSTABLEID=@P3) AND (TRANSRECID=@P4)) AND (POSTED=@P5))) </inputbuf>
</process>
</blocking-process>
</blocked-process-report>
<blocked-process-report monitorLoop="1759481">
<blocked-process>
<process id="processf4e8748c8" taskpriority="0" logused="36060" waitresource="KEY: 5:72057598722834432 (c93b90d0fabe)" waittime="67820" ownerId="4954845452" transactionname="user_transaction" lasttranstarted="2017-04-21T07:19:47.540" XDES="0x1a604530b0" lockMode="U" schedulerid="4" kpid="138692" status="suspended" spid="113" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-04-21T07:19:47.647" lastbatchcompleted="2017-04-21T07:19:47.643" lastattention="2017-04-21T06:03:26.407" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4954845452" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="108" stmtend="332" sqlhandle="0x02000000da94430599ae7ab3cd3f9eaa236f4f42b99094730000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 int,@P2 nvarchar(257),@P3 int,@P4 bigint,@P5 int)UPDATE JMGSTAMPJOURNALTRANS SET STOPTIME=@P1,TERMSTOP=@P2,RECVERSION=@P3 WHERE ((RECID=@P4) AND (RECVERSION=@P5)) </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="running" spid="108" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2017-04-21T07:20:55.257" lastbatchcompleted="2017-04-21T07:20:55.257" lastattention="2017-04-21T05:46:34.530" clientapp="Microsoft Dynamics AX" hostname="xx" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4954744115" currentdb="5" lockTimeout="4294967295" clientoption1="671156256" clientoption2="128056">
<executionStack>
<frame line="1" sqlhandle="0x02000000e9bde022409342c0ab4a164e88799e7c1fb5e3ae0000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
FETCH API_CURSOR0000000000239817 </inputbuf>
</process>
</blocking-process>
</blocked-process-report>
<blocked-process-report monitorLoop="1759482">
<blocked-process>
<process id="processf4e8748c8" taskpriority="0" logused="36060" waitresource="KEY: 5:72057598722834432 (c93b90d0fabe)" waittime="72820" ownerId="4954845452" transactionname="user_transaction" lasttranstarted="2017-04-21T07:19:47.540" XDES="0x1a604530b0" lockMode="U" schedulerid="4" kpid="138692" status="suspended" spid="113" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-04-21T07:19:47.647" lastbatchcompleted="2017-04-21T07:19:47.643" lastattention="2017-04-21T06:03:26.407" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4954845452" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="108" stmtend="332" sqlhandle="0x02000000da94430599ae7ab3cd3f9eaa236f4f42b99094730000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 int,@P2 nvarchar(257),@P3 int,@P4 bigint,@P5 int)UPDATE JMGSTAMPJOURNALTRANS SET STOPTIME=@P1,TERMSTOP=@P2,RECVERSION=@P3 WHERE ((RECID=@P4) AND (RECVERSION=@P5)) </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process/>
</blocking-process>
</blocked-process-report>
<blocked-process-report monitorLoop="1759483">
<blocked-process>
<process id="processf4e8748c8" taskpriority="0" logused="36060" waitresource="KEY: 5:72057598722834432 (c93b90d0fabe)" waittime="77835" ownerId="4954845452" transactionname="user_transaction" lasttranstarted="2017-04-21T07:19:47.540" XDES="0x1a604530b0" lockMode="U" schedulerid="4" kpid="138692" status="suspended" spid="113" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-04-21T07:19:47.647" lastbatchcompleted="2017-04-21T07:19:47.643" lastattention="2017-04-21T06:03:26.407" clientapp="Microsoft Dynamics AX" hostname="" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4954845452" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack>
<frame line="1" stmtstart="108" stmtend="332" sqlhandle="0x02000000da94430599ae7ab3cd3f9eaa236f4f42b99094730000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
(@P1 int,@P2 nvarchar(257),@P3 int,@P4 bigint,@P5 int)UPDATE JMGSTAMPJOURNALTRANS SET STOPTIME=@P1,TERMSTOP=@P2,RECVERSION=@P3 WHERE ((RECID=@P4) AND (RECVERSION=@P5)) </inputbuf>
</process>
</blocked-process>
<blocking-process>
<process status="running" spid="108" sbid="0" ecid="0" priority="0" trancount="1" lastbatchstarted="2017-04-21T07:21:05.210" lastbatchcompleted="2017-04-21T07:21:05.210" lastattention="2017-04-21T05:46:34.530" clientapp="Microsoft Dynamics AX" hostname="xx" hostpid="11800" loginname="xx" isolationlevel="read committed (2)" xactid="4954744115" currentdb="5" lockTimeout="4294967295" clientoption1="671156256" clientoption2="128056">
<executionStack>
<frame line="1" sqlhandle="0x02000000e9bde022409342c0ab4a164e88799e7c1fb5e3ae0000000000000000000000000000000000000000"/>
<frame line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"/>
</executionStack>
<inputbuf>
FETCH API_CURSOR0000000000239817 </inputbuf>
</process>
</blocking-process>
</blocked-process-report>
2017-04-21 07:20:10.9611562 113 0 2017-04-21 07:19:47.647 suspended UPDATE 0x02000000DA94430599AE7AB3CD3F9EAA236F4F42B99094730000000000000000000000000000000000000000 108 332 0x06000500DA944305508ACDF43100000001000000000000000000000000000000000000000000000000000000 5 1 7742FCCF-DC10-42C5-9381-548EA4FCC82F 108 LCK_M_U 23307 LCK_M_U KEY: 5:72057598722834432 (c93b90d0fabe) 2 1 4954845452 0x 0 0 0 23307 3 0x0000000F4E8748C8 0 0 6 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 1 0 2 0 0 1 0xE18AF10DA0AD601A 0x537B53255D5171B1 NULL NULL 2017-04-21 05:45:45.250 xx Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 7 8664 4 2017-04-21 07:19:47.647 2017-04-21 07:19:47.643 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-21 07:20:21.0389978 113 0 2017-04-21 07:19:47.647 suspended UPDATE 0x02000000DA94430599AE7AB3CD3F9EAA236F4F42B99094730000000000000000000000000000000000000000 108 332 0x06000500DA944305508ACDF43100000001000000000000000000000000000000000000000000000000000000 5 1 7742FCCF-DC10-42C5-9381-548EA4FCC82F 108 LCK_M_U 33388 LCK_M_U KEY: 5:72057598722834432 (c93b90d0fabe) 2 1 4954845452 0x 0 0 0 33388 3 0x0000000F4E8748C8 0 0 6 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 1 0 2 0 0 1 0xE18AF10DA0AD601A 0x537B53255D5171B1 NULL NULL 2017-04-21 05:45:45.250 xx Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 7 8664 4 2017-04-21 07:19:47.647 2017-04-21 07:19:47.643 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-21 07:20:40.1635086 113 0 2017-04-21 07:19:47.647 suspended UPDATE 0x02000000DA94430599AE7AB3CD3F9EAA236F4F42B99094730000000000000000000000000000000000000000 108 332 0x06000500DA944305508ACDF43100000001000000000000000000000000000000000000000000000000000000 5 1 7742FCCF-DC10-42C5-9381-548EA4FCC82F 108 LCK_M_U 52506 LCK_M_U KEY: 5:72057598722834432 (c93b90d0fabe) 2 1 4954845452 0x 0 0 0 52506 3 0x0000000F4E8748C8 0 0 6 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 1 0 2 0 0 1 0xE18AF10DA0AD601A 0x537B53255D5171B1 NULL NULL 2017-04-21 05:45:45.250 xx Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 7 8664 4 2017-04-21 07:19:47.647 2017-04-21 07:19:47.643 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-21 07:20:00.8520146 113 0 2017-04-21 07:19:47.647 suspended UPDATE 0x02000000DA94430599AE7AB3CD3F9EAA236F4F42B99094730000000000000000000000000000000000000000 108 332 0x06000500DA944305508ACDF43100000001000000000000000000000000000000000000000000000000000000 5 1 7742FCCF-DC10-42C5-9381-548EA4FCC82F 108 LCK_M_U 13202 LCK_M_U KEY: 5:72057598722834432 (c93b90d0fabe) 2 1 4954845452 0x 0 0 0 13202 3 0x0000000F4E8748C8 0 0 6 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 1 0 2 0 0 1 0xE18AF10DA0AD601A 0x537B53255D5171B1 NULL NULL 2017-04-21 05:45:45.250 xx Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 7 8664 4 2017-04-21 07:19:47.647 2017-04-21 07:19:47.643 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-21 07:20:31.0856150 113 0 2017-04-21 07:19:47.647 suspended UPDATE 0x02000000DA94430599AE7AB3CD3F9EAA236F4F42B99094730000000000000000000000000000000000000000 108 332 0x06000500DA944305508ACDF43100000001000000000000000000000000000000000000000000000000000000 5 1 7742FCCF-DC10-42C5-9381-548EA4FCC82F 108 LCK_M_U 43433 LCK_M_U KEY: 5:72057598722834432 (c93b90d0fabe) 2 1 4954845452 0x 0 0 0 43433 3 0x0000000F4E8748C8 0 0 6 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 1 0 2 0 0 1 0xE18AF10DA0AD601A 0x537B53255D5171B1 NULL NULL 2017-04-21 05:45:45.250 xx Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 7 8664 4 2017-04-21 07:19:47.647 2017-04-21 07:19:47.643 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
2017-04-21 07:19:50.7585487 113 0 2017-04-21 07:19:47.647 suspended UPDATE 0x02000000DA94430599AE7AB3CD3F9EAA236F4F42B99094730000000000000000000000000000000000000000 108 332 0x06000500DA944305508ACDF43100000001000000000000000000000000000000000000000000000000000000 5 1 7742FCCF-DC10-42C5-9381-548EA4FCC82F 108 LCK_M_U 3114 LCK_M_U KEY: 5:72057598722834432 (c93b90d0fabe) 2 1 4954845452 0x 0 0 0 3114 3 0x0000000F4E8748C8 0 0 6 -1 us_english mdy 7 1 0 1 0 1 1 1 1 2 -1 0 1 0 2 0 0 1 0xE18AF10DA0AD601A 0x537B53255D5171B1 NULL NULL 2017-04-21 05:45:45.250 xx Microsoft Dynamics AX 11800 7 ODBC 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx xx xx 7 8664 4 2017-04-21 07:19:47.647 2017-04-21 07:19:47.643 1 0x0105000000000005150000009B0BC11E26EDAA4F828BA628650A0000 xx NULL NULL NULL 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment