"Query Failed" error in Endpoint Protection Manager console home

Products

• Endpoint Protection

Issue/Introduction

"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>

 

Cause

Error is cause by an improperly constructed SQL query.

Resolution

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.