Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <deadlock-list>
- <deadlock victim="process390c188">
- <process-list>
- <process id="process390c188" taskpriority="5" logused="2908" waitresource="KEY: 13:72057594059489280 (25a04f35fc40)" waittime="4257" ownerId="26935569" transactionguid="0x5fcfb5317383b441aee5d15a8d4c4d16" transactionname="DTCXact" lasttranstarted="2015-12-22T12:11:55.303" XDES="0x4ed36ee40" lockMode="X" schedulerid="4" kpid="9288" status="suspended" spid="133" sbid="0" ecid="0" priority="-5" trancount="2" lastbatchstarted="2015-12-22T12:11:55.420" lastbatchcompleted="2015-12-22T12:11:55.410" lastattention="1900-01-01T00:00:00.410" clientapp="Internet Information Services" hostname="SI-S-SERV341" hostpid="2824" loginname="ugdbm" isolationlevel="read committed (2)" xactid="26935569" currentdb="13" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056" databaseName="UltraGendaPro">
- <executionStack>
- <frame procname="UltraGendaPro.dbo.sp_regvisit_save" line="86" stmtstart="4814" stmtend="5426" sqlhandle="0x03000d0026b4e44fb6610a0175a5000001000000000000000000000000000000000000000000000000000000">
- update appointment set ap_is_current = 0 where ap_id = @vlngCurApId
- -- RQ-3332
- -- Haal de ap_id's op van alle afspraken die overlappen met de te af te sluiten afspraak.
- -- Dit wordt hier reeds in een temp table gedaan, maar pas later uitgevoerd als de slots
- -- en de afspraak zelf zijn losgekoppeld. </frame>
- </executionStack>
- <inputbuf>
- Proc [Database Id = 13 Object Id = 1340388390] </inputbuf>
- </process>
- <process id="process2d5a928" taskpriority="0" logused="0" waitresource="KEY: 13:72057594057981952 (0f016ce5ca76)" waittime="4252" ownerId="26935587" transactionname="SELECT" lasttranstarted="2015-12-22T12:11:55.357" XDES="0x55bd3fcc0" lockMode="S" schedulerid="1" kpid="10116" status="suspended" spid="99" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2015-12-22T12:11:55.353" lastbatchcompleted="2015-12-22T12:11:55.343" lastattention="1900-01-01T00:00:00.343" clientapp="Internet Information Services" hostname="SI-S-SERV341" hostpid="2824" loginname="ugdbm" isolationlevel="read committed (2)" xactid="26935587" currentdb="13" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056" databaseName="UltraGendaPro">
- <executionStack>
- <frame procname="UltraGendaPro.dbo.SP_GRPVIEW_LOAD" line="63" stmtstart="3440" sqlhandle="0x03000d005a41ca31a3d45d0162a5000001000000000000000000000000000000000000000000000000000000">
- SELECT
- SCHEDULE_DPART.SCHDP_ID,
- case when (DATEDIFF(d, SCHEDULE_DPART.SCHDP_DATE, GETDATE()) >= 0) then 1 else 0 end as isPastOrTodayDate,
- SCHEDULE_DPART.SCHDP_TYPE,
- SCHEDULE_DPART.SCHDP_START,
- SCHEDULE_DPART.SCHDP_END,
- SCHEDULE_DPART.SCHDP_NAME,
- SCHEDULE_DPART.CONTACTTYPE_NAME,
- COALESCE(ScheduleDaySessionChangesIndex.HasIndividualChanges, 0) as SCHDP_CHANGED,
- SCHEDULE_DPART.SCHDP_SESCL,
- SCHEDULE_DPART.SCHDP_LOCKED,
- SITE.SITE_NAME,
- ISNULL(SCHEDULE_DPART.SCHDP_BOOKPERC,0) AS SCHDP_BOOKPERC,
- ISNULL(SCHEDULE_DPART.SCHDP_BOOK,0) AS SCHDP_BOOK,
- ISNULL(SCHEDULE_DPART.SCHDP_TOTALTIME,0) AS SCHDP_TOTALTIME,
- SCHEDULE_DPART.SCHDP_TrackProPlanningStarted,
- ISNULL(SCHSL_SLOTDURATION,0) AS SCHSL_SLOTDURATION,
- 0 AS AP_ID,
- 0 AS AP_DURATION,
- 0 AS AP_BLOCK,
- NULL AS AP_LREASON,
- NULL AS AP_CREATION,
- NULL AS AP_ORIGINAL_CREATION,
- NULL AS AP_STATUS,
- ISNULL(PROGRAM_DPT.PRGDPT_ID,0) AS PRGDPT_ID,
- PROGRAM_DPT.PRGDPT_NAME,
- PROGRAM_DPT.PRGDPT_COLOR,
- RESOURCE.RSC_ID, </frame>
- <frame procname="UltraGendaPro.dbo.sp_grpview_loadFromAsp" line="27" stmtstart="792" sqlhandle="0x03000d009365be32d4d45d0162a5000001000000000000000000000000000000000000000000000000000000">
- EXECUTE sp_grpview_load @dptgrp_id, @date </frame>
- </executionStack>
- <inputbuf>
- Proc [Database Id = 13 Object Id = 851338643] </inputbuf>
- </process>
- </process-list>
- <resource-list>
- <keylock hobtid="72057594059489280" dbid="13" objectname="UltraGendaPro.dbo.APPOINTMENT" indexname="I_APPOINTMENT_005" id="lock4e9479800" mode="S" associatedObjectId="72057594059489280" databaseName="UltraGendaPro">
- <owner-list>
- <owner id="process2d5a928" mode="S" />
- </owner-list>
- <waiter-list>
- <waiter id="process390c188" mode="X" requestType="wait" />
- </waiter-list>
- </keylock>
- <keylock hobtid="72057594057981952" dbid="13" objectname="UltraGendaPro.dbo.APPOINTMENT" indexname="PK_APPOINTMENT" id="lock4f03ad580" mode="X" associatedObjectId="72057594057981952" databaseName="UltraGendaPro">
- <owner-list>
- <owner id="process390c188" mode="X" />
- </owner-list>
- <waiter-list>
- <waiter id="process2d5a928" mode="S" requestType="wait" />
- </waiter-list>
- </keylock>
- </resource-list>
- </deadlock>
- </deadlock-list>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement