Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Syntax error on CMDB Data Manager policy

KavyashriN
Tera Contributor

‎08-22-2024 05:37 AM

I have requirement to create CMDB Data Manager Archive/Delete/Retired Policy. after creating the policies when i have opened data filter, it is showing an error "Syntax Error or Access Rule Violation detected by database ((conn=2117821) 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 'distinct cmdb0.`sys_id` HAVING count(sj0.`sys_id`) = 0 ) sub /* <instance name>, ...' at line 1)"

Manage Retirement Definition is active true only for the table cmdb_ci, retirement policy is install status = retired.

KavyashriN_0-1724329681934.png


Thanks
KavyaN

0 Helpfuls
  • 756 Views
1 REPLY 1

DonnaOlsen
Tera Expert

‎09-07-2024 08:11 PM

I am getting the same error.  If I go to the Data Manager directly and not through CMDB Workspace, I do not get these errors. I am curious to know why these errors are popping up in CMDB Workspace. 

0 Helpfuls