Running many queries periodically deadlock INS on table RSIX

[alex_wiebe]

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.

[john_hawk]

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