Syntax error on CMDB Data Manager policy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-22-2024 10:41 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-25-2024 01:17 PM
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.