Skip to Content

Running many queries periodically deadlock INS on table RSIX

We have a dashboard with a number of queries. Sometimes users will click through multiple tabs quite quickly and periodically we will see errors in our system:

"Database error 60 with INS access to table RSIX"

And yet, when I look in this table there are no entries for the given time and/or user.

Doesn't seem to negatively affect the user - but would like to understand what is happening and what we can do to correct.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 11, 2016 at 09:13 PM

    Hi Alex,

    Table RSIX is a Basis table. It appears that when multiple queries are executed simultaneously, the underlying database cannot INS (insert) a row into the table. SM12 might be able to show the cross-locking.

    This a database error.The database is overwhelmed. Your DBA might be able to help, but I doubt he can help - you may need a new or higher version of your database.

    Consider lowering the number of queries per dashboard as a workaround.

    Please don't forget to record your final solution and to mark the question as answered.

    Good luck,

    John Hawk

    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.