Symptoms:
SEPM console displays “Query Failed” error in Monitors -> Summary Tab ->
Virus and Spyware Protection Summary type (Default) view.
Reporting.log shows following errors for all stored procedures above:
2015-11-17 13:46:14 ERROR:<br>QUERY: EXEC SEM_AV_SUMMARY_RISK_DIST …
12:46:00','2015-11-17 12:46:59'<br>EXCEPTION: exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime.' in D:\Applications\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php:526
…
Error message: <b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en datetime.<br>Error code: -2147352567<br>File and line: D:\Applications\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(526)<br>Trace: #0 D:\Applications\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(526): com->Execute('EXEC SEM_AV_SUM...', -1)
Translated error: “Error converting data type varchar to datetime.'“
According to etrack: 3830629 - From version RU6 few stored procedures have been incorrectly modified, so they do accept data type only in specific format.
This problem is fixed in Symantec Endpoint Protection 14. For information on how to obtain the latest build of Symantec Endpoint Protection, read
Download the latest version of Symantec Endpoint Protection
Workaround:
Set English language for sem5 account: