Received the following error message, Unable to create the report:

Issue:

Receiving the following error message:

Unable to create the report:
Could not execute query.
Unexpected error occurred in PAData:minsExecuteQuery
Timeout expired

Resolution:

  1. Increase the Query time out setting to double what it is now.
    1. Start -> All Programs -> Print Audit 6 -> Administrator
    2. Select Tools -> Set Database
    3. click on Advanced and modify the Query Timeout
  2. Make sure that Auto Close is set to False.
    1. Launch SQL Server Management Studio
    2. select the "Print Audit" database under the list of databases.
    3. Right click and select Properties.
    4. In the left pane click on Options
    5. Set the Auto Close setting to False (located under the Automatic Section).
How did we do with this article?