Solution : https://service.sap.com/sap/support/notes/1614802 (SAP Service marketplace login required)
Summary :
During the upgrade or when importing an Enhancement Package, MAIN_SHDRUP/ACT_UPG phase may hang due to a deadlock in DDFTX table on SAP NetWeaver 7.02 or higher. Processes may wait indefinitely for database lock releases during INSERT operations in DDFTX, which are triggered post a DELETE operation on DD30V activation, without a subsequent database commit to release the lock. The deadlock occurs when the same process tries accessing a lock held by itself in a different session leading to unresolvable hangs. Resolution involves importing a Support Package or applying a preemptive fix via SNOTE.
Key words :
19 function saplsdifruntime lsdifruntimeu03 dd_int_update_ddftx 18 function saplsdifruntime lsdifruntimeu02 ddif_fieldinfo_get 17 form radshchk radackin field_values 16 form radshchk radshchk check_selmtypeok 15 form radshchk radshchk check_dcshhdchk 14 form radshchk radshchk check_dcshactchk 13 form radshchk radshchk check_shlp 12 form radshact radshact dd_shlp_activate_inner 11 form radshact radshact dd_shlp_activate 10 function saplsdsa lsdsau02 dd_shlp_act 9 form saplsdva lsdvaf02 check_view_shlp_dep 8 form saplsdva lsdvaf02 check_view_dep 7 function saplsdva lsdvau01 dd_view_inner_act 6 form saplsdmp radmasutc mt_view_act 5 form saplsdmp radmasutc mt_act 4 function saplsdmp lsdmpu02 dd_mass_act_parallel 3 form saplsdmp lsdmpu02 dd_mass_act_parallel 2 form sapmssy1 sapmssy1 remote_function_call 1 module, function ddif_fieldinfo_get, sapmssy1 sapmssy1 %_rfc_startthis problem, dd_int_update_ddftx, dd_view_inner_act, phase main_shdrun/act_upg hangs, phase main_newbas/xpras_aimmrg, netweaver target release, delete statement remain, preceding delete statement
Related Notes :
| 1702617 | Timeout or deadlock on table DDFTX when generating screens |
| 1155807 | Database deadlock when executing DD_INT_UPDATE_DDFTX |
| 745639 | FAQ: Oracle enqueues |