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

Products

• Endpoint Protection

Issue/Introduction

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."

Resolution

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 conf.properties.
3. Locate the line that begins with "scm.report.isstoredprocedurevalid" and edit it to the following:
   
   scm.report.isstoredprocedurevalid=1
   
4. Save and close conf.properties.
5. Open Microsoft SQL Server Management Studio, and log on as the sa or other administrator account.
6. Execute the following:
   
   SQL: GRANT EXECUTE TO sem5
   
   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.