When running a report in the Symantec Endpoint Protection Manager (SEPM) or generating a log on a reporting server. The server does not respond, or you see the following error message:
The database query timed out. Try reducing the number of filters, or increasing the SQL Server query timeout value.
This problem can happen when you run reports or generate logs with large amounts of data. To fix the problem, increase the MS SQL server connection timeout value and command timeout value.
To change the MS SQL server connection timeout value and command timeout value
Note: If you specify zero, or leave either of the values blank, Reporting Server uses the default value, which is 300 seconds (five minutes).
When you run reports or generate logs with large amounts of data, and you get CGI or terminated process errors, you might want to change any of the following timeout values:
To change the max_execution_time timeout value
To change the Transaction timeout value
To change Apache timeout parameters in httpd.conf
When you finish setting you must restart the services of Symantec Endpoint Protection Manager and Symantec Endpoint Protection Manager Webserver or restart the Server.