The SEP 12.1 Home Page console (Summary tab) displays a query failed error after upgrading from Symantec Endpoint Protection version 11.0.x to version 12.1.
On the Home Page (Summary tab) the following message is displayed:
Query Failed This query could not be processed for one of the following reasons:
1. The database query timed out. Try reducing the number of filters, or increasing the SQL server timeout value.
2. An unexpected error occurred. Try running the query again by using the default filter values.
3. String encoding was possibly not UTF-8, and may result from copying and pasting data instead of typing data. Try typing data in the input fields.
The reporting.log on the Symantec Endpoint Protection Manager contains the following exception:
QUERY: EXEC SEM_HOMEPAGE_DISABLED_COUNTS '', ''
EXCEPTION: exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'SEM_HOMEPAGE_DISABLED_COUNTS', database 'SEM5', schema 'dbo'.' in C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php:500
The sem5 database user lacks EXECUTE permissions to one or more stored procedures. You can use the reporting.log to identify additional stored procedures that are failing due to lack of permissions.
During the installation of Symantec Endpoint Protection 12.1 the product ensures that the sem5 database user receives the correct permissions to the database. You may need to work with your SQL database administrator (dba) to restore the appropriate permissions.
Symantec Endpoint Protection Manager 12.1 with SQL database configuration. The issue is not migration specific and can also happen on a fresh install of Symantec Endpoint Protection Manager 12.1.
Imported Document ID: TECH164854
Subscribing will provide email updates when this Article is updated. Login is required.