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
  • 684 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