Error: Ad-hoc query could not be deleted. This ad-hoc query or a selection created from this ad-hoc query may be in use- when deleting a query after merging a query

After creating two new queries, and merging into one, you may receive the message, "Error: Ad-hoc query could not be deleted. This ad-hoc query or a selection created from this ad-hoc query may be in use." This message can occur even after deleting the merged query and if the original queries were not marked as selections.
Although we can not delete the query, we can avoid it from being used with the following steps:
  1. Navigate to Analysis>Information Library
  2. Click Manage Folders
  3. Add a new query folder name Inactive and Save
  4. Rename the query we want to delete to Inactive or Do Not Use
  5. Add the query to the Inactive folder to avoid it being used

Steps to Duplicate

  1. Navigate to Analysis>Information Library
  2. Create any two queries and save
  3. Click drop down next to either query and select Merge
  4. Select any merge filter, such as Either A or B
  5. Save new query
  6. Click drop down next to either original query and select Delete
  7. Receive error

Was this article helpful?