While creating and attempting to run a query using the CMDB Query Builder, you may find the below errors:
Saved query with this sys id does not exist
Problem running query
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.
Create a new ACL on the table [qb_query_status] as follows:
Requires Roles: cmdb_query_builder