ServiceNow Error Message: Syntax Error or Access Rule Violation detected by database

[David Garcia]

Hello,

I am recently getting this error when trying to filter by Class or Category on the cmdb_ci list:

servicenow error message: Syntax Error or Access Rule Violation detected by database ((conn=38699344) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'null WHERE cmdb0.`sys_class_path` LIKE '/!!%' AND (cmdb0.`sys_class_name` = '...' at line 1)

I have tried troubleshooting this, but I am not getting to the bottom of it.

Does anyone know how to correct this error?

[Sandeep Rajput]

@David Garcia Please refer to this KB article https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0718572 and see if running 

gs.invalidateCache();

 in a background script fixes this issue.

[David Garcia]

Hi, Sandeep. That did not resolve the issue.

[Community Alums · Accepted solution]

Have you seen the following article:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0783599

[David Garcia]

That did the trick! Thank you so much!