In Symantec Endpoint Protection Manager (SEP), when attempting to add an exclusion from a Risk Log for a specific file, you get an error message.
Symantec Endpoint Protection Manager 14.0 RU1 through 14.2 MP1
Symantec Endpoint Protection Manager (SEPM) displays the following message:
Number of policies successfully updated: 0. There was an error: Datastore error.
The log file scm_server.log displays the following:
2018-06-15 10:59:41.656 THREAD 219804180 SEVERE: in: com.sygate.scm.server.consolemanager.requesthandler.ReportActionHandler com.microsoft.sqlserver.jdbc.SQLServerException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
There are invalid SHA1 values in the database associated with specific applications.