Syntax Error or Access Rule Violation detected by database ((conn=1999638) Key 'qjozrwqi_for_table_cleaner' doesn't exist in table 'cmdb_par10')

[Nakata1]

Hi All

When I open the reference list of cmdb_ci, I get the following error How should I handle this?

Syntax Error or Access Rule Violation detected by database ((conn=1999638) Key 'qjozrwqi_for_table_cleaner' doesn't exist in table 'cmdb_par10')

[Bert_c1]

I guess you didn't see my recommendation to create a Support Case. That is what I would do.

[Sourabh26]

Hi,

Run the following code as a background script:

gs.invalidateCache();

[Pedro Ruiz]

The message indicates the index is on the primary table partition (cmdb) but not the secondary (cmdb_par10). Open a support case and ask them to create the same index in the secondary partition.

[Glenn Dickerson]

I had this issue as well.  I found an obscure reference about function fields being related to this issue.  So, I de-activated all function fields on tables related to cmdb_ci and that fixed the issue.  We didn't have that many and they were only used once for some validation reporting.  1. Open a report that uses the function field. 2. Configure function fields 3. Deactivate any that are related to cmdb_ci 4. test

[Serigne Mansour]

Hi All, 

This issue is coming from the sorting (ASC or DESC) on one of the fields on your cmdb_ci list.

For my case, a user has this issue because he has sorted the status (install_status) on cmdb_ci. The sort performed on this field must be removed to resolve this issue (sort list with another field).

Regards, 

Mansour NIANG