APM CMDB Query Builder reports throwing fetching and ACL ErrorIssue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } When trying to view 8 OOB Reports under the 'CMDB Query Builder' module, users are seeing the following error messages: ---------------- An error occured while fetching items. ERROR: Cannot generate the report. Access to this content denied based on report_on ACLs. ---------------- List of reports affected (can be fold by typing 'cmdb query builder' in the filter navigator) ------------------------------------------ 1. Business Applications providing a Business Capability 2. Business Capabilities provided by Business Application 3. Application Services consumed by Business Application 4. Business Services provided by a Business Capability 5. Business Applications using an Information Object 6. Information Objects used by a Business Application 7. Demands on a Business Application 8. Projects on a Business Application ------------------------------------------Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Any release with APM plugin installedCause<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Cause 1. Result Tables (u_cmdb_qb_result_"sys_id") have not yet exist on [sys_db_object] table. As a result, the reports can not reference the table that they are pulling data from. Cause 2. Or, the result table exists, but there is a in incorrect pre-fix before the "u_cmdb_qb_result_". Example: "sn_hr_core_u_cmdb_qb_result_78fe0c5a81c9b7b52a4e90c37002735efa619d7d" instead of u_cmdb_qb_result_78fe0c5a81c9b7b52a4e90c37002735efa619d7d This is due to PRB1513486 and can be confirmed by going to [sys_db_object] table and searching for *u_cmdb_qb_result in the 'name' column. if there is a scoped application name 'sn_hr_core' or 'application_name" before the "u_cmdb...", the PRB above applies. Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } ---To resolve issue for ACL error message--- 1. Open CMDB Query Builder module2. Open each saved query one at a time and Run and then Save the query.3. Afterwards go to the [sys_db_object] table and confirm by searching for *u_cmdb_qb_result in the name columnResult: The number of records should be equivalent to the name of queries ran in step 2. 4. Try opening any of the 8 APM reports under CMDB Query Builder Application ---To resolve the ACL issue due to PRB1513486--- 1. Go to saved queries table [qb_saved_query], note there are 6 records. 2. While on this table, add the 'result table' column and make note of each of the values (e.g. u_cmdb_qb_result_ae6de....) for each of the records. 3. Go to [sys_db_object] table 4. In name column (or condition builder), search for for each of the unique result tables (noted in step#2)5. Open both records and click delete ui action and then type 'delete' in the pop-up modal and click OK to confirm deletion. Note: User will need to change your scope in order to delete, afterwards make sure to change scope back to 'global' post deletion before re-running the query to prevent the pre-fixing issue from happening again.6. Go to CMDB query builder application, there are 6 saved queries, open and "run" each one and then click "save". /$queryBuilder.do 7. This should re-generate the new records (u_cmdb_qb_result....) on the [sys_db_object] table. 8. After running the saved queries, there should be 6, check here: /sys_db_object_list.do?sysparm_query=nameLIKEu_cmdb_qb_result&sysparm_view= Afterwards, the 8 modules/reports under 'CDMB query builder', should load without the ACL error. ------------------------------------------ 1. Business Applications providing a Business Capability 2. Business Capabilities provided by Business Application 3. Application Services consumed by Business Application 4. Business Services provided by a Business Capability 5. Business Applications using an Information Object 6. Information Objects used by a Business Application 7. Demands on a Business Application 8. Projects on a Business Application ------------------------------------------ After ACL error has been fixed, reports may show 'no data to display' message is appearing, this is expected if the are no records matching the query condition. When executing the saved queries (via CMDB Query Builder app), if conditions are met, the result tables (u_cmdb_qb_result....) will populate with data, otherwise, they will be empty.