<deadlock>
<victim-list>
<victimProcess id="process28bd48c1088" />
</victim-list>
<process-list>
<process id="process28bd48c1088" taskpriority="0" logused="4324" waitresource="OBJECT: 5:206779944:12 " waittime="4540" ownerId="107618166" transactionname="user_transaction" lasttranstarted="2023-01-12T09:15:13.437" XDES="0x28f83bd4428" lockMode="IS" schedulerid="13" kpid="1936" status="suspended" spid="173" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2023-01-12T09:15:13.433" lastbatchcompleted="2023-01-12T09:15:13.437" lastattention="1900-01-01T00:00:00.437" clientapp="JTL-Wawi C# - Sven Braun (16)" hostname="WIN-MOJH10SLCKB" hostpid="3980" loginname="sa" isolationlevel="read committed (2)" xactid="107618166" currentdb="5" currentdbname="eazybusiness" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame procname="eazybusiness.FulfillmentNetwork.spStockUpdate" line="77" stmtstart="4678" stmtend="6616" sqlhandle="0x030005002c1edf50a9765a0175ae000001000000000000000000000000000000000000000000000000000000">
INSERT INTO FulfillmentNetwork.tStockRef
(
kArtikel,
kBenutzer,
cJfsku,
kBuchungsart,
kWarenLagerPlatz,
kLieferantenBestellungPos,
fAnzahl,
dCreatedAt,
nChangeState,
cLieferscheinNr,
cOwnerId,
dMHD,
cCharge,
cKommentar,
kWarenLagerEingang,
kSessionId,
cFulfillerStockChangeId,
nType
)
SELECT kArtikel,
kBenutzer,
cJfsku,
kBuchungsart,
kWarenLagerPlatz,
kLieferantenBestellungPos,
fAnzahl,
dCreatedAt,
0 AS nChangeState,
cLieferscheinNr,
cOwnerId,
dMHD,
cCharge,
cKommentar,
kWarenLagerEingang,
kSessionId,
NEWID() AS cFulfillerStockChangeId,
2 as nType
FROM @stockUpdate </frame>
<frame procname="eazybusiness.dbo.spWarenlagerEingangSchreiben" line="302" stmtstart="25554" stmtend="25702" sqlhandle="0x030005004ca5636fd3765a0175ae000001000000000000000000000000000000000000000000000000000000">
EXEC FulfillmentNetwork.spStockUpdate @Daten = @fulfillmentStockUpdateDate </frame>
</executionStack>
<inputbuf>
Proc [Database Id = 5 Object Id = 1868801356] </inputbuf>
</process>
<process id="process286e33c4ca8" taskpriority="0" logused="34101044" waitresource="PAGE: 5:1:3546347 " waittime="1995" ownerId="107612946" transactionname="UPDATE" lasttranstarted="2023-01-12T09:15:11.850" XDES="0x28ddd458428" lockMode="U" schedulerid="44" kpid="10228" status="suspended" spid="103" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2023-01-12T09:15:00.377" lastbatchcompleted="2023-01-12T09:15:00.377" lastattention="1900-01-01T00:00:00.377" clientapp="SQLAgent - TSQL JobStep (Job 0x1B99FADDFBEFF04388D047312F6A626D : Step 1)" hostname="WIN-MOJH10SLCKB" hostpid="8944" loginname="NT SERVICE\SQLAgent$JTLWAWI" isolationlevel="read committed (2)" xactid="0" currentdb="5" currentdbname="eazybusiness" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056">
<executionStack>
<frame procname="eazybusiness.dbo.tgr_tArtikel_Sync_INSUP" line="254" stmtstart="27772" stmtend="28602" sqlhandle="0x03000500e28c25328e775a0175ae000000000000000000000000000000000000000000000000000000000000">
UPDATE tArtikelShop
SET tArtikelShop.nAktion = tArtikelShop.nAktion | 1,
tArtikelShop.cInet = 'Y',
tArtikelShop.nInBearbeitung = 0
FROM dbo.tArtikelShop
JOIN #tgrtArtikelSync ON #tgrtArtikelSync.kArtikel = tArtikelShop.kArtikel
WHERE #tgrtArtikelSync.nConnectorBlock = 1
AND (tArtikelShop.cInet = 'N'
OR tArtikelShop.nAktion IN (0,2,4,6,8)
OR tArtikelShop.nInBearbeitung = 1 </frame>
<frame procname="adhoc" line="389" stmtstart="42218" stmtend="43468" sqlhandle="0x02000000ba4a6022534e0705c9feedd7c82ae19ac1a56f080000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
SET QUOTED_IDENTIFIER ON
--Jako kLieferant = 24
update tartikel set nBearbeitungszeit = 5 where nistvater = 0 and kartikel in(
select tartikel_kartikel from tliefartikel where tLieferant_kLieferant = 24
)and nbearbeitungszeit <> 5 and kartikel in(
select kartikel from tlagerbestand where kartikel in (
select tartikel_kartikel from tliefartikel where tLieferant_kLieferant = 24
)and (fLagerbestandEigen - finAuftraegen) < 1
) and kartikel not in (select kartikel from tartikelattribut where kattribut = 24)
--Jako Merchandise kLieferant = 75
update tartikel set nBearbeitungszeit = 5 where nistvater = 0 and kartikel in(
select tartikel_kartikel from tliefartikel where tLieferant_kLieferant = 75
)and nbearbeitungszeit <> 5 and kartikel in(
select kartikel from tlagerbestand where kartikel in (
select tartikel_kartikel from tliefartikel where tLieferant_kLieferant = 75
)and (fLagerbestandEigen - finAuftraegen) < 1
) and kartikel not in (select kartikel from tartikelattribut where katt </inputbuf>
</process>
</process-list>
<resource-list>
<objectlock lockPartition="12" objid="206779944" subresource="FULL" dbid="5" objectname="eazybusiness.dbo.tArtikel" id="lock28da7612380" mode="X" associatedObjectId="206779944">
<owner-list>
<owner id="process286e33c4ca8" mode="X" />
</owner-list>
<waiter-list>
<waiter id="process28bd48c1088" mode="IS" requestType="wait" />
</waiter-list>
</objectlock>
<pagelock fileid="1" pageid="3546347" dbid="5" subresource="FULL" objectname="eazybusiness.dbo.tArtikelShop" id="lock28da68f5a80" mode="IX" associatedObjectId="72057707754422272">
<owner-list>
<owner id="process28bd48c1088" mode="IX" />
</owner-list>
<waiter-list>
<waiter id="process286e33c4ca8" mode="U" requestType="wait" />
</waiter-list>
</pagelock>
</resource-list>
</deadlock>