Skip to Content

dump DBIF_RSQL_SQL_ERROR usrobjects table

Dear all,

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 resource" Internal call code.........: "[RSQL/DELE/USROBJECTS ]" Please check the entries in the system log (Transaction SM21).
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 08:28 AM

    Hi Albert,

    Is it happening in BW system? and can you please let me know the exact situation of this error causes?

    Also check this SAP note 84348 if helps.

    Regards,

    Gopi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Albert Samigullin

      Hi,

      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.

      Regards,

      Ganesan

  • Posted on Jul 22, 2016 at 01:08 PM

    Many thanks for your answers! Abaper will correct abap code,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.