Hi Martin,
Thanks for the quick reply.
These queries are reason for blocking, even though we tried to kill them again it happens.
I guess one query is blocking the other and both trying to fetch same record at a time causing this issue.
Please suggest the solution to release the lock and make them work accordingly.
Query 1:
(@P1 bigint,
@P2 nvarchar(5),@P3 bigint,@P4 bigint,@P5 bigint,@P6 bigint,@P7 bigint)SELECT TOP 1 T1.RECID FROM TAXTRANS T1 WHERE ((T1.PARTITION=@P1) AND (T1.DATAAREAID=@P2)) AND EXISTS (SELECT TOP 1 'x' FROM SUBLEDGERJOURNALENTRY T2 WHERE ((T2.PARTITION=@P3) AND ((T2.TRANSFERID=@P4) AND (T2.LEDGER=@P5)))AND EXISTS (SELECT TOP 1 'x' FROM ACCOUNTINGEVENT T3WHERE ((T3.PARTITION=@P6) AND (T3.RECID=T2.ACCOUNTINGEVENT))AND EXISTS (SELECT TOP 1 'x' FROM SOURCEDOCUMENTLINE T4 WHERE ((T4.PARTITION=@P7) AND ((T4.SOURCEDOCUMENTHEADER=T3.SOURCEDOCUMENTHEADER) AND (T1.SOURCEDOCUMENTLINE=T4.RECID))))))
Query 2:
(@P1 numeric(32,16),@P2 datetime2,@P3 int,@P4 bigint,@P5 nvarchar(5),@P6 bigint,@P7 nvarchar(5),@P8 numeric(32,16),@P9 nvarchar(21),@P10 nvarchar(21))UPDATE PURCHLINE SET PURCHRECEIVEDNOW=@P1,MODIFIEDDATETIME=@P2,RECVERSION=@P3 WHERE ((PARTITION=@P4) AND (DATAAREAID=@P5)) AND EXISTS (SELECT 'x' FROM VENDINVOICEINFOLINE T2 WHERE (((T2.PARTITION=@P6) AND (T2.DATAAREAID=@P7)) AND ((((PURCHLINE.PURCHRECEIVEDNOW<>@P8) AND (T2.INVENTTRANSID=PURCHLINE.INVENTTRANSID)) AND (T2.PARMID=@P9)) AND (T2.TABLEREFID=@P10))))
Query 3:
(@P1 int,@P2 bigint,@P3 nvarchar(5),@P4 nvarchar(21),@P5 bigint,@P6 nvarchar(5),@P7 bigint)UPDATE T1 SET RECEIVENOW=(T1.RECEIVENOW-T3.SUMOFQUANTITY),INVENTNOW=(T1.INVENTNOW-T3.SUMOFINVENTQUANTITY),PDSCWINVENTNOW=(T1.PDSCWINVENTNOW-T3.SUMOFPDSCWQUANTITY),RECVERSION=@P1 FROM VENDINVOICEINFOSUBLINE T1 CROSS JOIN VENDPACKINGSLIPTRANS T2 CROSS JOIN VENDINVOICEPACKINGSLIPQUANTITYMATCHSUM T3 WHERE (((T1.PARTITION=@P2) AND (T1.DATAAREAID=@P3)) AND (T1.PARMID=@P4)) AND (((T2.PARTITION=@P5) AND (T2.DATAAREAID=@P6)) AND ((T2.RECID=T1.JOURNALREFRECID) AND (T2.INVENTTRANSID=T1.DOCUMENTID))) AND ((T3.PARTITION=@P7) AND (T3.PACKINGSLIPSOURCEDOCUMENTLINE=T2.SOURCEDOCUMENTLINE))
Query 4:
(@P1 numeric(32,16),@P2 datetime2,@P3 int,@P4 bigint,@P5 nvarchar(5),@P6 bigint,@P7 nvarchar(5),@P8 numeric(32,16),@P9 nvarchar(21),@P10 nvarchar(21))UPDATE PURCHLINE SET PURCHRECEIVEDNOW=@P1,MODIFIEDDATETIME=@P2,RECVERSION=@P3 WHERE ((PARTITION=@P4) AND (DATAAREAID=@P5)) AND EXISTS (SELECT 'x' FROM VENDINVOICEINFOLINE T2 WHERE (((T2.PARTITION=@P6) AND (T2.DATAAREAID=@P7)) AND ((((PURCHLINE.PURCHRECEIVEDNOW<>@P8) AND (T2.INVENTTRANSID=PURCHLINE.INVENTTRANSID)) AND (T2.PARMID=@P9)) AND (T2.TABLEREFID=@P10))))
Many thanks in advance
