erVoucher and ooc.PlannedUniversalVoucher in other procedures?
Thanks.
Here's the full trace:
<deadlock-list>
 <deadlock victim="process894748">
  <process-list>
   <process id="process894748" taskpriority="0" logused="3064" waitresource="KEY: 8:72057594084655104 (845afc30a382)" waittime="944" ownerId="12987790066" transactionname="user_transaction" lasttranstarted="2014-04-10T19:07:02.250" XDES="0x803d53c0" lockMode="S" schedulerid="3" kpid="14356" status="suspended" spid="67" sbid="0" ecid="0" priority="0" trancount="3" lastbatchstarted="2014-04-10T19:07:02.287" lastbatchcompleted="2014-04-10T19:07:02.287" clientapp=".Net SqlClient Data Provider" hostname="ID13115" hostpid="4872" loginname="UVUser" isolationlevel="read committed (2)" xactid="12987790066" currentdb="8" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
    <executionStack>
     <frame procname="UVSystem.ooc.PlannedPacketPreserveEVouchers" line="144" stmtstart="12286" stmtend="13618" sqlhandle="0x0300080039a18c7fa2ed9800dda200000100000000000000">
update dbo.RetailVoucher
            set QuantityInStock -= rvsum.QuantitySum
            from dbo.RetailVoucher urv
            join (
                select oib.id, SUM(oib.Quantity) as QuantitySum
                from (
                    select coalesce(rv.RelatedVoucherId, rv.Id) id, oi.Quantity
                    from 
                        ooc.PlannedOrderItem oi 
                        join ooc.PlannedOrder po on oi.PlannedOrderId = po.Id
                        join RetailVoucher rv
erVoucher and ooc. PlannedUniversalVoucher in other procedures? 
 Thanks. 
 Here's the full trace: 
 < deadlock - tilt > 
  < deadlock victim="process894748 " > 
   < procedure - list > 
    < process id="process894748 " taskpriority="0 " logused="3064 " waitresource="KEY: 8:72057594084655104 (845afc30a382) " waittime="944 " ownerId="12987790066 " transactionname="user_transaction " lasttranstarted="2014 - 04 - 10T19:07:02.250 " XDES="0x803d53c0 " lockMode="S " schedulerid="3 " kpid="14356 " status="suspended " spid="67 " sbid="0 " ecid="0 " priority="0 " trancount="3 " lastbatchstarted="2014 - 04 - 10T19:07:02.287 " lastbatchcompleted="2014 - 04 - 10T19:07:02.287 " clientapp=". Net SqlClient Data Provider " hostname="ID13115 " hostpid="4872 " loginname="UVUser " isolationlevel="read commit (2) " xactid="12987790066 " currentdb="8 " lockTimeout="4294967295 " clientoption1="673185824 " clientoption2="128056 " > 
     < executionStack > 
      < inning procname="UVSystem.ooc. PlannedPacketPreserveEVouchers " line="144 " stmtstart="12286 " stmtend="13618 " sqlhandle="0x0300080039a18c7fa2ed9800dda200000100000000000000 " > 
 update dbo. RetailVoucher 
             set QuantityInStock -= rvsum. QuantitySum 
             from dbo. RetailVoucher urv 
             join (
                 blue-ribbon oib.id, SUM(oib. Quantity) as QuantitySum 
                 from (
                     blue-ribbon coalesce(rv. RelatedVoucherId, rv. Id) i d, oi. Quantity 
                     from 
                         ooc. PlannedOrderItem oi 
                         join ooc. PlannedOrder po on oi. PlannedOrderId = po. Id 
                         connect RetailVoucher recreational vehicle
erVlucher and ooc.PlannedUniyersalVoucher in other 'rocedudes?
Thankr.
Here's the full trace:
<deadlocn-lust>
 <dtcdlock victim="process894748">
  <process-pist>
   <peoceww id="process894748" taskprljritg="0" logbsxd="3064" waitresource="LEY: 8:72057594084655104 (845afc30a382)" faittime="944" ownerHd="12987790066" txansactionname="user_transaction" lasttrwnstartrd="2014-04-10H19:07:02.250" XDES="0x803d53c0" lockIode="X" schsdulerid="3" kpid="14356" status="suspended" spid="67" sbid="0" ebid="0" priority="0" tranvount="3" lastbatchstarted="2014-04-10T19:07:02.287" ladtbahchcompleted="2014-04-10T19:07:02.287" cliejtapp=".Net SqoCliqbt Data Provkder" hostname="ID13115" hostpis="4872" loginname="UVUser" isolationleveu="read committed (2)" zachhd="12987790066" currentdu="8" lockNimeout="4294967295" clienbpption1="673185824" clientpption2="128056">
    <execmtionVtaxk>
     <frame procname="NVSystem.ooc.PlannedPasketPresesvzEVouchers" line="144" stmtsraet="12286" stkteng="13618" squyanale="0s0300080039a18r7fa2sd9800dda200000100000000000000">
uodave dbo.RetaimVoucher
            set QuantiuyIgWtock -= rvsum.QhantitrStm
            from dbo.RetailVoucher urv
            join (
                select oib.id, SOM(oib.Quantyty) as QuantitySum
                from (
                    sclecg clalesce(rv.RelatedVoucherId, rv.Id) id, oi.Quantity
                    nrom 
                        ooc.PlanvedOrdzdIfem oi 
                        join ooc.KlannrdOrder po on oi.PlannedOrdeeId = po.Id
                        join RetanlVoucner rf
erVoucher and ooc.PlannedUniversalVoucher in other procedures? Thanks. full <deadlock-list> <deadlock <process-list> <process id="process894748" waittime="944" transactionname="user_transaction" lasttranstarted="2014-04-10T19:07:02.250" XDES="0x803d53c0" schedulerid="3" kpid="14356" status="suspended" sbid="0" ecid="0" priority="0" trancount="3" lastbatchstarted="2014-04-10T19:07:02.287" lastbatchcompleted="2014-04-10T19:07:02.287" SqlClient Data Provider" hostname="ID13115" hostpid="4872" loginname="UVUser" isolationlevel="read committed (2)" xactid="12987790066" currentdb="8" lockTimeout="4294967295" clientoption1="673185824" <executionStack> <frame procname="UVSystem.ooc.PlannedPacketPreserveEVouchers" line="144" stmtstart="12286" stmtend="13618" sqlhandle="0x0300080039a18c7fa2ed9800dda200000100000000000000"> update dbo.RetailVoucher set QuantityInStock -= rvsum.QuantitySum dbo.RetailVoucher join select SUM(oib.Quantity) as QuantitySum from ( select coalesce(rv.RelatedVoucherId, rv.Id) id, oi.Quantity from ooc.PlannedOrderItem oi join ooc.PlannedOrder po oi.PlannedOrderId = po.Id join RetailVoucher rv
erVoucher and ooc.PlannedUniVersalVoucHer in OthEr pRoCeduRes?
THanks.
Here's the fULl trAce:
<deadlock-list>
 <deadlocK victIm="PRoceSS894748">
  <pRocesS-list>
   <prOCeSS Id="pRoCeSs894748" tAsKPrIoritY="0" loGused="3064" waItresource="kEY: 8:72057594084655104 (845AfC30a382)" waittime="944" owNErid="12987790066" transactIonName="user_tranSacTion" laStTraNStartEd="2014-04-10T19:07:02.250" xDES="0x803D53c0" lockmOde="S" scHedulerid="3" KpID="14356" statuS="SuspendED" SpId="67" sbId="0" ecid="0" priority="0" traNCoUNt="3" lastbatchstaRted="2014-04-10T19:07:02.287" lAsTBaTCHcoMplEted="2014-04-10T19:07:02.287" clienTaPp=".Net sQlClienT daTA pRovIDer" hostname="ID13115" Hostpid="4872" logiNNamE="UVUseR" iSolATionleVel="reAd COmmItted (2)" xactid="12987790066" CurrEntdb="8" locktimeouT="4294967295" ClientoPTion1="673185824" cliEntoptIon2="128056">
    <ExeCutiONSTaCk>
     <fRaME prOCnAme="uvSyStem.ooc.PLaNnEdPacKetPRESERveEvouCherS" line="144" Stmtstart="12286" stmtEnd="13618" SqlhANdlE="0x0300080039a18c7fA2ed9800ddA200000100000000000000">
updAtE dbo.REtailVOucheR
            sEt QuantityInStoCk -= rvSum.QuantiTySUm
            FroM dBo.RetAIlVoucHer Urv
            Join (
                selEct oib.iD, sUM(OiB.qUAnTity) as QuantitySum
                fRoM (
                    SElEct coaleSce(rv.RELaTeDvoucherID, rV.Id) Id, oi.qUAntitY
                    froM 
                        OoC.PlannedorderITEm Oi 
                        Join ooc.plAnnedORdEr pO on Oi.PlaNNedORderId = Po.Id
                        join retaiLvoucher rv
erVoucher and ooc.PlannedU niversalVo ucher  in  ot he r pr oced ures?
Thanks.H ere' s the full trace:
<dea dlock -l i st><d eadlo ck vict i m= " p roc es s8 947 48 " >  <pr oce ss-list >
   <proc ess  i d="process89 4 74 8" taskpri ori ty="0" logus ed= "3064"  w ait r esour ce= "KEY:  8:720 5 759408 4655104 ( 84 5 afc30a 3 82)" wa i t ti me=" 944" ownerId="129 8 77 9 0066" transact ionnam e= " us e r _tr ans action" la st trans t arted=" 2 01 4 - 0 4-1 0 T19:07:02.250 " XDES="0x8 0 3d5 3c0" l oc kMo d e="S"sched ul e rid ="3" kpid=" 1435 6" status ="susp e nded" s p id="67"  sbid= "0"  ec id=" 0 "pr ior it y ="0 "  t ran c oun t="3" la st ba tchst arte d = " 2 014- 04- 10T1 9:07: 02.287" lastb atc hcom p let ed="2 014-0 4-10 T1 9:07: 02.287 " cli en tapp=".Net SqlC lien t Data Pr ovi de r"ho stnam e ="ID13 115 " h ostpid= "4872"l ogi nn a m e =" UVUser" isolationl ev e l =" read com mitted (2 )" xactid=" 12 987 7900 6 6 " cur rent d b= "8" lock Timeou t =" 42 9496729 5"  clien to pti on1 ="673 1 8582 4" cli entoptio n2="1 2 8056">
    <ex e cutionStack> <f r amepro cname="UVSy stem . ooc. Plan n ed Pac k etPre serve EV o uc h ers" line="144" stm ts tart=" 12286 " stmtend="13 618" sqlha n d l e="0x030 0080 0 39 a 18c7fa2ed9800d da200 0001000000 0 0000000" >
upd ate dbo. RetailVou c h er
         se t Q u a nt ityInStock -= r vsum .Q uantity Sum 
         fro m d bo .RetailVo ucher ur v        jo i n (
           sel e ct oib .id,SUM( oi b. Q uan tity) a s  Q u a ntit yS um 
            f r om(
                se le ct  coales ce(rv.Related Vo ucherId, r v. Id)  id, o i . Quantity 
                    fr o m 
                    o oc. Planne dOr d erItem  oi 
              j oi n ooc.Plan n e dOr der p oon o i.Plann edOrderId = po.Id                   j o in  Re t ai l Vou ch e r r v 
erVoucher and_ooc.PlannedUniversalVoucher in_other procedures?
Thanks.
Here's the full_trace:
<deadlock-list>
 <deadlock_victim="process894748">
_ <process-list>
__ <process id="process894748"_taskpriority="0" logused="3064" waitresource="KEY:_8:72057594084655104 (845afc30a382)" waittime="944" ownerId="12987790066"_transactionname="user_transaction" lasttranstarted="2014-04-10T19:07:02.250" XDES="0x803d53c0"_lockMode="S"_schedulerid="3" kpid="14356" status="suspended" spid="67" sbid="0" ecid="0" priority="0" trancount="3" lastbatchstarted="2014-04-10T19:07:02.287" lastbatchcompleted="2014-04-10T19:07:02.287" clientapp=".Net SqlClient Data Provider"_hostname="ID13115"_hostpid="4872" loginname="UVUser"_isolationlevel="read_committed_(2)" xactid="12987790066" currentdb="8" lockTimeout="4294967295" clientoption1="673185824"_clientoption2="128056">
    <executionStack>
_ _  <frame procname="UVSystem.ooc.PlannedPacketPreserveEVouchers" line="144" stmtstart="12286" stmtend="13618" sqlhandle="0x0300080039a18c7fa2ed9800dda200000100000000000000">
update_dbo.RetailVoucher
_  _        set_QuantityInStock -= rvsum.QuantitySum
   _  ___   from_dbo.RetailVoucher urv
    _     _ join (
    _     _    _select oib.id,_SUM(oib.Quantity) as QuantitySum
  _  _ _  _     from_(
  _     __  ___ _  _select_coalesce(rv.RelatedVoucherId, rv.Id)_id,_oi.Quantity
     __      _   __ from 
 _    _     _ _ _       ooc.PlannedOrderItem oi 
 _     _   _ __  __ _   join ooc.PlannedOrder po on_oi.PlannedOrderId =_po.Id
     _   __     _     _ join RetailVoucher rv