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')

[Serigne Mansour]

Hi Nakata1,

To solve this issue, you need to create an index on the table.

This action should be perform by servicenow support.

[Victor10]

Refer to the article from SNow: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0783599

Sort your list/search by any field and normally this should solve your issue. At least it solved for me.