3275188 - Deadlock 1205 on E071 and E071~ occurred in SUM phase MAIN_SHDRUN/SQLSELEXE_CP2SINI_LIMUCOMM  - NetWeaver

• SQLDBSCRIPT<nn>.SQL log shows  
  1 ETQ000 ==================================================
  ...
  3 ETQ398 SQL: UPDATE [E071~] SET LOCKFLAG = '2' WHERE TRKORR = 'SAPKCCR750'
  3 ETQ398XSQL:           AND OBJ_NAME IN (SELECT OBJ_NAME FROM E071 WHERE TRKORR =
  3 ETQ398XSQL: 'SAPKCCR750' AND LOCKFLAG = '2')
  3 ETQ400 Rows affected: 0
  3 ETQ398 SQL: UPDATE [E071~] SET LOCKFLAG = '2' WHERE TRKORR = 'SAPKCCL750'
  3 ETQ398XSQL:           AND OBJ_NAME IN (SELECT OBJ_NAME FROM E071 WHERE TRKORR =
  3 ETQ398XSQL: 'SAPKCCL750' AND LOCKFLAG = '2')
  3 ETQ400 Rows affected: 0
  3 ETQ398 SQL: UPDATE [E071~] SET LOCKFLAG = '2' WHERE TRKORR = 'SAPKCCI752'
  3 ETQ398XSQL:           AND OBJ_NAME IN (SELECT OBJ_NAME FROM E071 WHERE TRKORR =
  3 ETQ398XSQL: 'SAPKCCI752' AND LOCKFLAG = '2')
  
  1EETQ008 Error message: DBSL error 99 (db code 1205):
  1EETQ009XTransaction (Process ID 101) was deadlocked on lock resources with
  1EETQ009Xanother process and has been chosen as the deadlock victim. Rerun the
  1EETQ009Xtransaction.
  1EETQ003 exit code: "20"
  4 ETQ399 Rollback.
  4 EPU202X======MARK ANALYZED SECTION==== PHASE SQLSELEXE_CP2SINI_LIMUCOMM 
  
  
• deadlock profiler trace shows page lock.

• Microsoft SQL Server Database

 MAIN_SHDRUN/SQLSELEXE_CP2SINI_LIMUCOMM, deadlock, 1205 , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem