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

[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