Thursday, 20 November 2014

Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation ARERR - 94

Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation ARERR - 94
or
Timeout during data retrieval due to busy server -- retry the operation ARERR - 93

This error is caused by database server overhead due to unqualified search and it should be disabled. To disable unqualified search perform the following:

a) Go to Server Information form.
b) Go to Configuration tab
c) Disable "Allow Unqualified Searches"

If the issue still occurs, Enable the server logs and look out for the code that took time to retrieve data from DB. Fine Tune the code, if necessary.

No comments:

Post a Comment