Deadlock encountered .... Printing deadlock information
Wait-for graph
NULL
Node:1

KEY: 66:72057594059882496 (e94412002af8) CleanCnt:2 Mode:X Flags: 0x1
 Grant List 2:
   Owner:0x00000001228A2280 Mode: X        Flg:0x40 Ref:0 Life:02000000 SPID:78 ECID:0 XactLockInfo: 0x00000002E4A5CEC0
   SPID: 78 ECID: 0 Statement Type: INSERT Line #: 89
   Input Buf: RPC Event: Proc [Database Id = 66 Object Id = 517576882]
Requested by:
  ResType:LockOwner Stype:'OR'Xdes:0x00000001714EFCF0 Mode: RangeS-S SPID:257 BatchID:0 ECID:0 TaskProxy:(0x000000012B7D6540) Value:0xa7350a80 Cost:(0/0)
NULL
Node:2

OBJECT: 66:516196889:0         CleanCnt:2 Mode:S Flags: 0x1
 Grant List 2:
 Grant List 3:
   Owner:0x0000000141136940 Mode: S        Flg:0x40 Ref:2 Life:02000000 SPID:257 ECID:0 XactLockInfo: 0x00000001714EFD30
   SPID: 257 ECID: 0 Statement Type: SELECT Line #: 33
   Input Buf: RPC Event: Proc [Database Id = 66 Object Id = 1296723672]
Requested by:
  ResType:LockOwner Stype:'OR'Xdes:0x00000002E4A5CE80 Mode: IX SPID:78 BatchID:0 ECID:0 TaskProxy:(0x000000014A296540) Value:0x21b86480 Cost:(0/488)
NULL
Victim Resource Owner:
 ResType:LockOwner Stype:'OR'Xdes:0x00000001714EFCF0 Mode: RangeS-S SPID:257 BatchID:0 ECID:0 TaskProxy:(0x000000012B7D6540) Value:0xa7350a80 Cost:(0/0)
deadlock-list
 deadlock victim=process139a8db88
  process-list
   process id=process139a8db88 taskpriority=0 logused=0 waitresource=KEY: 66:72057594059882496 (e94412002af8) waittime=996 ownerId=72432528267 transactionname=SELECT lasttranstarted=2014-09-24T08:48:41.243 XDES=0x1714efcf0 lockMode=RangeS-S schedulerid=5 kpid=25688 status=suspended spid=257 sbid=0 ecid=0 priority=0 trancount=0 lastbatchstarted=2014-09-24T08:48:41.243 lastbatchcompleted=2014-09-24T08:48:41.243 clientapp=.Net SqlClient Data Provider hostname=WGIIS1 hostpid=864 loginname=web_app isolationlevel=serializable (4) xactid=72432528267 currentdb=66 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128056
    executionStack
     frame procname=eForms.dbo.Widget_PreApprovalForms_Search line=33 stmtstart=2172 sqlhandle=0x03004200d86e4a4d569d8d0079a300000100000000000000
SELECT DISTINCT
            DT.* ,
            ISNULL(NULLIF(CAST(DT.FormRegionCode AS VARCHAR(50)), ''),
                   Region.short_name) AS Region
    FROM    ( SELECT    FBD.FormId ,
                        FBD.AlternateId ,
                        FBD.VerificationValue ,
                        FBD.TypeId AS FormTypeId ,
                        FBD.FormTypeDescription AS Description ,
                        FBD.DashboardIcon ,
                        FBD.CreatedByName AS CreatedByUser ,
                        CAST(NULL AS VARCHAR(20)) AS NonEmployeeName ,
                        CAST(NULL AS VARCHAR(20)) AS ForUser ,
                        FBD.EmployeeOrUserName AS ForDisplayName ,
                        FBD.EmployeeIndex AS ForEmployeeIndex ,
                        FBD.FormStatusId ,
                        FBD.FormStatus AS FormStatusDescription ,
                        FBD.CreatedDate ,
                        FBD.ClosedDate ,
                        DATEDIFF(d, FBD.Create
    inputbuf
Proc [Database Id = 66 Object Id = 1296723672]
   process id=process6fb9708 taskpriority=0 logused=488 waitresource=OBJECT: 66:516196889:0  waittime=1314 ownerId=72432528155 transactionname=user_transaction lasttranstarted=2014-09-24T08:48:41.090 XDES=0x2e4a5ce80 lockMode=IX schedulerid=5 kpid=33964 status=suspended spid=78 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2014-09-24T08:48:41.440 lastbatchcompleted=2014-09-24T08:48:41.430 clientapp=.Net SqlClient Data Provider hostname=WGIIS2 hostpid=2744 loginname=web_app isolationlevel=serializable (4) xactid=72432528155 currentdb=66 lockTimeout=4294967295 clientoption1=673185824 clientoption2=128056
    executionStack
     frame procname=eForms.dbo.RoutePlan_Save line=89 stmtstart=5540 stmtend=7444 sqlhandle=0x03004200b298d91e3a67110132a000000100000000000000
INSERT
	    INTO [RoutePlan]
    	(
            [RoutePlan].[FormId],
            [RoutePlan].[UserId],
            [RoutePlan].[Rank],
            [RoutePlan].[RoutePlanStatusId],
            [RoutePlan].[StatusDate],
            [RoutePlan].[Notes],
            [RoutePlan].[IsStrict],
            [RoutePlan].[RoutePlanResponsibilityId],
            [RoutePlan].[IsPostApproval],
            [RoutePlan].[ProcessedByUserId],
            [RoutePlan].[Deleted],
            [RoutePlan].[CreatedById],
            [RoutePlan].[CreatedDate]
    	)
    	VALUES
    	(
      		@localFormId,
      		@localUserId,
      		@localRank,
      		@localRoutePlanStatusId,
      		@localStatusDate,
      		@localNotes,
      		@localIsStrict,
      		@localRoutePlanResponsibilityId,
      		@localIsPostApproval,
      		@localProcessedByUserId,
      		@localDeleted,
      		@localCreatedById,
      		GETDATE()
	    )
    inputbuf
Proc [Database Id = 66 Object Id = 517576882]
  resource-list
   keylock hobtid=72057594059882496 dbid=66 objectname=eForms.dbo.Form indexname=PK_Forms id=lock204d08500 mode=X associatedObjectId=72057594059882496
    owner-list
     owner id=process6fb9708 mode=X
    waiter-list
     waiter id=process139a8db88 mode=RangeS-S requestType=wait
   objectlock lockPartition=0 objid=516196889 subresource=FULL dbid=66 objectname=eForms.dbo.RoutePlan id=lock2044c5080 mode=S associatedObjectId=516196889
    owner-list
     owner id=process139a8db88 mode=S
    waiter-list
     waiter id=process6fb9708 mode=IX requestType=convert