There is abap dump DBIF_RSQL_SQL_ERROR in my production system tied with deadlock in table USROBJECTS. Who know, what is this table usrobjects? For what this is need?
Database error text........: "ORA-00060: deadlock detected while waiting for
Thanks for answer! I will check this note. Abap dump arose in ERP system during data handling. But my qustion is what is table USROBJECTS, for what this table does need?
USROBJECTS is the table of previous initial object in structure overview. It is a transparent table and mainly used in product structure browser module to store and manage data.
To find more details about deadlock, you can check in "alert<SID>.log" file.
its a bit lengthy. Sometime, background jobs create deadlocks. In a BW system, may be, the process chain. In both the cases, an object is locked by one process while another process is waiting for that object. Please try to follow the procedures if it is caused by the background jobs.
1. Try to find out time frame of deadlock occurrence.
2. Filter all the jobs between the time frame found in step 1.
3. Get the OS process IDs those tried to use the table from the alert<SID>.log.
4. Find out the jobs used by those OS process IDs.
5. Validate the jobs, means reschedule those jobs accordingly.
OR
In transaction DB02, try to find out the SQL commands those accessed this table and analyse it further.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.