Error: An error occurred before executing the process ' Ad-hoc Query Refresh Static Selection Process' : Unable to save keys to static selection table - when running a static selection refresh process

When users run the queue process containing an Ad-hoc Query Refresh Static Selection business processes, these steps fail with this error after 20 minutes each:

An error occurred before executing the process ' Ad-hoc Query Refresh Static Selection Process' : Unable to save keys to static selection table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.  The statement has been terminated.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 3.0.516
 3.0.516, Service Pack 4 ; 2.93.2034, patch 96 ; 2.94.1524, patch 88

Was this article helpful?