Solution : https://service.sap.com/sap/support/notes/565710 (SAP Service marketplace login required)
Summary :
The SAP Note discusses frequent DBIF_RSQL_SQL_ERROR short dumps due to SQL Server error 1205 (deadlock) in an SAP System. Typical deadlock issues involve database tables like TSP02, TSP02FX, and others specified. The system's problems stem from table access conflicts during simultaneous read-write operations by different processes, particularly during operations like SELECT and DELETE on the same tables without suitable indexes, leading to process termination. Recommended solutions include adjusting indexes and reviewing existing SAP Notes for specific tables. Implementing correct indices and operational checks can mitigate or resolve the deadlocks.
Key words :
//bas/46d/src/krn/runt/absapsql, simultaneously executed delete sets locks, lists sql server-specific solutions, byo deadlock occurredby4 database error 1205, committed read isolation level, creatime pjident pjnumber ascending, import support package sapkipmd11, client = sy-mandt order, spool work process executes, sql server error log
Related Notes :
| 1774085 | Deadlock analysis for SQL Server (Advanced) |
| 580018 | Deadlock on the D020S or DYNPLOAD tables |
| 579765 | DB deadlock on DB tables REPOLOAD and REPOSRC |
| 576097 | Deadlock through complex DELETE statement |
| 574849 | RSDRC/FORM DISPATCHER_RECEIVE An SQL Error occurred |
| 572390 | Deadlock during complex deletion in table J_3GABEST |
| 570924 | Deadlocks via "Debugging -> Sessions -> Save/Delete" |
| 570168 | Deadlocks in table /sapapo/dmcp |
| 551298 | DB deadlock on table REPOSRC during system installation |
| 548184 | Deadlock during parallel delete on TNROT |
| 536564 | Deadlocks on the /sapapo/pegkey table (part 2) |
| 527829 | Deadlock on table /sapapo/pegkey |
| 524919 | Deadlock during update on table /SAPAPO/PEGKEY |
| 513757 | APO->R/3: Deadlocks on table MDVM/DBVM (2) |
| 509243 | Deadlocks/performance MDVM during BOM changes |
| 507874 | Deadlocks MDVM/DBVM when deleting planned order |
| 506272 | Dead lock on tables S009 and S014 |
| 503787 | Deadlock when you access table /sapapo/pegkey |
| 499858 | Storage parameter maintenance with MS SQL Server |
| 499428 | Deadlock with table T77OMAHQ_GARBAGE |
| 498668 | Deadlocks on the TSP01 table (deleting spool requests) |
| 493899 | Deadlock on the TMDIR table (Microsoft SQL Server) |
| 459528 | APO->R/3: Deadlocks on table MDVM/DBVM |
| 419165 | deadlock with job execution |
| 409250 | Deadlocks in the Business Workflow: New blocking mechanism |
| 391677 | Deadlock problems in business workflow: background steps |
| 363085 | SQL error 60 during order transfer |
| 323302 | SQL error60 when accessing table SWWWIHEAD/SWWWIRET |
| 206571 | Deadlock between SWWWIHEAD and SWWWIDH |
| 149724 | Deadlock in the workflow runtime system |
| 111291 | FAQ: SQL server analysis and avoiding deadlocks |
| 32129 | Deadlock analysis for the SQL server |