[CMDB\QueryBuilder] Error "Problem running query" while running/saving the CMDB Query Builder


Description

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/csh?topicname=use-cmdb-query-builder.html&version=latest

https://docs.servicenow.com/csh?topicname=cmdb-query-builder-settings.html&version=latest