Syntax error on CMDB Data Manager policy

KavyashriN
Tera Contributor

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-1724391652290.png

 

1 REPLY 1

Tony Branton
ServiceNow Employee
ServiceNow Employee

This is a platform defect that has been fixed in the latest patch releases for Washington DC and  Xanadu.

 

Without the patch, you can close the notifications and continue to work with the Data Manager policy - actual functionality is not impacted by the error notification.