"Query Failed" error in Symantec Endpoint Protection Manager (SEPM) console home
Typical error from Reporting.log:
2019-06-25 20:02:43 Login:start 2019-06-25 20:02:47 INFO:Value for timechoice not set: 2019-06-25 20:02:49 INFO:Value for timechoicePEP not set: 2019-06-25 20:02:49 INFO:Value for changeTime not set: 2019-06-25 20:02:49 INFO:DashboardPEPActionSummary>> fresh PEP summary from DB at 2019-06-25 13:02:49 2019-06-25 20:02:54 INFO:EndpointStatus>> cache miss at 2019-06-25 13:02:54 2019-06-25 20:02:54 ERROR:<br>QUERY: select count(*) as ________ from SEM_AGENT SA with (NOLOCK) LEFT OUTER JOIN PATTERN PAT on PAT.PATTERN_IDX = SA.PATTERN_IDX with (NOLOCK) where SA.DELETED=0 and SA.AGENT_TYPE='105' and SA.AP_ONOFF not in (2, 127) and SA.MAJOR_VERSION != '5' and (PAT.VERSION is NULL or PAT.VERSION < (select MAX(PAT.VERSION) from VIRUS as V with (NOLOCK) INNER JOIN PATTERN PAT on PAT.PATTERN_IDX=V.PATTERN_IDX with (NOLOCK) where V.LATEST_THREAT= 1)) <br>EXCEPTION: com_exception: <b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. in C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php:584 Stack trace: #0 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(584): com->Execute(' select count(*...', -1) #1 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(340): ado_doPreparedStatement(' select count(*...', Object(com)) #2 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\connectdb.php(246): ado_query('select count(*)...', Object(com), false) #3 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Dashboard\getTopAndLatestThreats.php(198): sav_query('select count(*)...', Object(com)) #4 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Dashboard\ajax.php(613): getTopAndLatestThreats() #5 {MAIN.EN_US}Error message: <b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.<br>Error code: -2147352567<br>File and line: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(584)<br>Trace: #0 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(584): com->Execute(' select count(*...', -1) #1 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(340): ado_doPreparedStatement(' select count(*...', Object(com)) #2 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\connectdb.php(246): ado_query('select count(*)...', Object(com), false) #3 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Dashboard\getTopAndLatestThreats.php(198): sav_query('select count(*)...', Object(com)) #4 C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Dashboard\ajax.php(613): getTopAndLatestThreats() #5 {MAIN.EN_US}<br>
Error is cause by an improperly constructed SQL query.
This issue is fixed in Symantec Endpoint Protection 14.2 RU2. For information on how to obtain the latest build of Symantec Endpoint Protection, see Download the latest version of Symantec software here.