Error: Server was unable to process request - This ad-hoc query cannot be processed because the current user does not have rights to one or more of the source query views. When selecting a designation for a donation form.

A designation query was working with an Advanced Donation Form and was no longer loading designations into its search or drop down functions. If you inspected the page you could see a few errors happening when trying to select a designation.
 

Error: 500 Internal Server Error
Error: Server was unable to process request - This ad-hoc query cannot be processed because the current user does not have rights to one or more of the source query views.

The ad-hoc query used to populate the designation drop down is generating the error message. Advanced Donation Forms do not run ad-hoc queries, so this can happen for out of box donation forms as well. The ad-hoc query will run with the credentials of the owner. Review any changes that have happened recently with users, security or query since the error message started appearing. 

Steps to Duplicate

1. Go to donation page
2. Try to select a designation from the drop down or search feature
3. See that you are unable
4. Right click on the page
5. Click 'Inspect'
6. See error messages

Environment

 Blackbaud CRM
 4.0
 4.0.180

Was this article helpful?