Advertisement
Guest User

Untitled

a guest
Dec 30th, 2015
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.13 KB | None | 0 0
  1. <deadlock-list>
  2. <deadlock victim="process390c188">
  3. <process-list>
  4. <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">
  5. <executionStack>
  6. <frame procname="UltraGendaPro.dbo.sp_regvisit_save" line="86" stmtstart="4814" stmtend="5426" sqlhandle="0x03000d0026b4e44fb6610a0175a5000001000000000000000000000000000000000000000000000000000000">
  7. update appointment set ap_is_current = 0 where ap_id = @vlngCurApId
  8.  
  9. -- RQ-3332
  10. -- Haal de ap_id's op van alle afspraken die overlappen met de te af te sluiten afspraak.
  11. -- Dit wordt hier reeds in een temp table gedaan, maar pas later uitgevoerd als de slots
  12. -- en de afspraak zelf zijn losgekoppeld. </frame>
  13. </executionStack>
  14. <inputbuf>
  15. Proc [Database Id = 13 Object Id = 1340388390] </inputbuf>
  16. </process>
  17. <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">
  18. <executionStack>
  19. <frame procname="UltraGendaPro.dbo.SP_GRPVIEW_LOAD" line="63" stmtstart="3440" sqlhandle="0x03000d005a41ca31a3d45d0162a5000001000000000000000000000000000000000000000000000000000000">
  20. SELECT
  21. SCHEDULE_DPART.SCHDP_ID,
  22. case when (DATEDIFF(d, SCHEDULE_DPART.SCHDP_DATE, GETDATE()) &gt;= 0) then 1 else 0 end as isPastOrTodayDate,
  23. SCHEDULE_DPART.SCHDP_TYPE,
  24. SCHEDULE_DPART.SCHDP_START,
  25. SCHEDULE_DPART.SCHDP_END,
  26. SCHEDULE_DPART.SCHDP_NAME,
  27. SCHEDULE_DPART.CONTACTTYPE_NAME,
  28. COALESCE(ScheduleDaySessionChangesIndex.HasIndividualChanges, 0) as SCHDP_CHANGED,
  29. SCHEDULE_DPART.SCHDP_SESCL,
  30. SCHEDULE_DPART.SCHDP_LOCKED,
  31. SITE.SITE_NAME,
  32. ISNULL(SCHEDULE_DPART.SCHDP_BOOKPERC,0) AS SCHDP_BOOKPERC,
  33. ISNULL(SCHEDULE_DPART.SCHDP_BOOK,0) AS SCHDP_BOOK,
  34. ISNULL(SCHEDULE_DPART.SCHDP_TOTALTIME,0) AS SCHDP_TOTALTIME,
  35. SCHEDULE_DPART.SCHDP_TrackProPlanningStarted,
  36. ISNULL(SCHSL_SLOTDURATION,0) AS SCHSL_SLOTDURATION,
  37.  
  38. 0 AS AP_ID,
  39. 0 AS AP_DURATION,
  40. 0 AS AP_BLOCK,
  41. NULL AS AP_LREASON,
  42. NULL AS AP_CREATION,
  43. NULL AS AP_ORIGINAL_CREATION,
  44.  
  45. NULL AS AP_STATUS,
  46.  
  47. ISNULL(PROGRAM_DPT.PRGDPT_ID,0) AS PRGDPT_ID,
  48. PROGRAM_DPT.PRGDPT_NAME,
  49. PROGRAM_DPT.PRGDPT_COLOR,
  50.  
  51. RESOURCE.RSC_ID, </frame>
  52. <frame procname="UltraGendaPro.dbo.sp_grpview_loadFromAsp" line="27" stmtstart="792" sqlhandle="0x03000d009365be32d4d45d0162a5000001000000000000000000000000000000000000000000000000000000">
  53. EXECUTE sp_grpview_load @dptgrp_id, @date </frame>
  54. </executionStack>
  55. <inputbuf>
  56. Proc [Database Id = 13 Object Id = 851338643] </inputbuf>
  57. </process>
  58. </process-list>
  59. <resource-list>
  60. <keylock hobtid="72057594059489280" dbid="13" objectname="UltraGendaPro.dbo.APPOINTMENT" indexname="I_APPOINTMENT_005" id="lock4e9479800" mode="S" associatedObjectId="72057594059489280" databaseName="UltraGendaPro">
  61. <owner-list>
  62. <owner id="process2d5a928" mode="S" />
  63. </owner-list>
  64. <waiter-list>
  65. <waiter id="process390c188" mode="X" requestType="wait" />
  66. </waiter-list>
  67. </keylock>
  68. <keylock hobtid="72057594057981952" dbid="13" objectname="UltraGendaPro.dbo.APPOINTMENT" indexname="PK_APPOINTMENT" id="lock4f03ad580" mode="X" associatedObjectId="72057594057981952" databaseName="UltraGendaPro">
  69. <owner-list>
  70. <owner id="process390c188" mode="X" />
  71. </owner-list>
  72. <waiter-list>
  73. <waiter id="process2d5a928" mode="S" requestType="wait" />
  74. </waiter-list>
  75. </keylock>
  76. </resource-list>
  77. </deadlock>
  78. </deadlock-list>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement