What does the "a provided value is too large to be processed by the database" error mean?

If you receive the error "a provided value is too large to be processed by the database" when trying to save a query, the most likely reason this happened is that one of your fields has criteria that is over the maximum character limit for being saved. 

  • For example, if you are copying many person ID values into the Person ID field.
  • The character limit for query criteria is 2000 characters. 

Suggested workaround: If you are going by the copy and paste method, a best practice is to save both queries in a workspace, one for the copy and one for the paste, and then add instructions on how to reproduce the desired query that cannot be saved. You can add directions on the "Query" tab of the query design.