Solution : https://service.sap.com/sap/support/notes/409250 (SAP Service marketplace login required)
Summary :
SAP Note targets deadlock issues in workflows, specifically addressing tables such as SWWWIHEAD, SWWWIRET, SWWCONT, and SWWCONTOB. It introduces a new locking mechanism with options for adjusting enqueue locks, influenced by a revised commit logic aimed at avoiding changes to work items without explicit database locks. Key components include Report RSWP_MODIFY_ENQUEUE_FLAG, function module sets for enqueues, and enhancements to RSWWERRE and table SWP_SUSPEN. The solution allows toggling between new and old locking behaviors and provides system administration guidance on managing transaction SM58 and scheduling RSWWERRE report to address enqueue failures effectively.
Key words :
extremely comprehensive correction essentially consists, report rswp_modify_enqueue_flag function module set, modelled deadline monitoring, solve deadlock problems, explicit database locks, completed --> completing event, explicit database lock, report rswwerre enhancement, cancelled --> work item, additional workflow tables
Related Notes :
| 642607 | Terminating events are not received |
| 622581 | Deadlocks in the Business Workflow |
| 565710 | SQL Server: Database error 1205 (deadlock) |
| 510544 | Problems with new locking mechanism |
| 350802 | SAPSQL_ARRAY_INSERT_DUPREC in SWW_WI_LOG_FLUSH |