Solution : https://service.sap.com/sap/support/notes/843166 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the occurrence of deadlocks on the RSMDATASTATE table, typically caused by concurrent loading processes modifying the QULAOK and TECHOK fields. The deadlock arises from a "select single * for update" lock in a primary connection, followed by a premature DB_COMMIT in a secondary R/3 connection before the primary's DB_COMMIT. This issue categorizes as a program/kernel error. Users are advised to consult SAP Note 843042 for detailed resolution steps. Key terms include deadlock, Oracle DB, lock waits, and SELECT FOR UPDATE.
Key words :
program error/kernel error, solution read note 843042, oracle lock reason, note 843042 describes, database lock, lock waits, rare cases, deadlocks occur, loading processes, techok fields
Related Notes :
| 843042 | Oracle: Database locks for SELECT FOR UPDATE |