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
On the Endpoint Protection Manager computer, go to C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\.
In a text editor such as Notepad, open the file conf.properties.
Locate the line that begins with "scm.report.isstoredprocedurevalid" and edit it to the following:
Save and close conf.properties.
Open Microsoft SQL Server Management Studio, and log on as the sa or other administrator account.
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.
Restart the Symantec Endpoint Protection Manager service.
If you have a replication environment, repeat this action for each site.
ID: 2039616, 1926711
Imported Document ID: TECH136691
Subscribing will provide email updates when this Article is updated. Login is required.