Error: Query failed when running Comprehensive Risk Report for 24 hours

Article:TECH136691  |  Created: 2010-01-26  |  Updated: 2010-11-12  |  Article URL
Article Type
Technical Solution


You are using Symantec Endpoint Protection Manager with Microsoft SQL Server. In Symantec Endpoint Protection Manager, you run Reports > Risk > Comprehensive Risk Report > 24 hours on a site. The report fails, and returns the message "Query Failed." In Temp\Reporting.log, you see the error "Timeout expired."


To work around the problem

  1. On the Endpoint Protection Manager computer, go to C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\.
  2. In a text editor such as Notepad, open the file
  3. Locate the line that begins with "" and edit it to the following:
  4. Save and close
  5. Open Microsoft SQL Server Management Studio, and log on as the sa or other administrator account.
  6. Execute the following:


    If Symantec Endpoint Protection Manager is using a different user than sem5, substitute the appropriate user name.
  7. Restart the Symantec Endpoint Protection Manager service.

If you have a replication environment, repeat this action for each site.

Supplemental Materials

Value2039616, 1926711

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices