34 views

Symptoms


While creating and attempting to run a query using the CMDB Query Builder, you may find the below errors:

Error#1:

Saved query with this sys id does not exist

Error#2:

Problem running query

 

Release


All versions.

 

Description


A new query created by a usr through the CMDBQueryBuilder application generates an entry for that particular query for that user in the [qb_query_status] table.

When the query is run, this produces a REST API call to get the data that match with the criteria, and saves the output into the table [qb_query_result]. The final result set is given back to the CMDBQueryBuilder page.

In certain conditions the ACLs on the above tables (/sys_security_acl_list.do?sysparm_query=nameSTARTSWITHqb_query_) may fail validating, falling back into the default OOB ACL "*.*", which do not grant any access to create the system records in the qb_query tables, ultimately interrupting the query builder.

 

Resolution


Create a new ACL on the table [qb_query_status] as follows:

Operation: create

Type: record

Name: qb_query_status.*

Requires Roles: cmdb_query_builder

 

Additional Information


https://docs.servicenow.com/bundle/kingston-servicenow-platform/page/product/configuration-management/task/use-cmdb-query-builder.html

https://docs.servicenow.com/bundle/kingston-servicenow-platform/page/product/configuration-management/reference/cmdb-query-builder-settings.html

Article Information

Last Updated:2018-08-30 06:30:36
Published:2018-08-30