ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Endpoint Protection Manager Home/dashboard page error "Query Failed"


Article ID: 239577


Updated On:


Endpoint Protection


After login into the Symantec Endpoint Protection Manager (SEPM), the Home page, Monitor, and Reports page show as Error message Query failed.

Endpoint protection Manager Apache reporting.logs at %Symantec Endpoint Protection Manager%\apache\logs
Show below error 

2022-04-14 04:47:03 INFO:Login start
2022-04-14 04:47:16 INFO:Value for timechoice not set:
2022-04-14 04:47:19 INFO:Value for timechoicePEP not set:
2022-04-14 04:47:19 INFO:Value for changeTime not set:
2022-04-14 04:47:19 INFO:DashboardPEPActionSummary>> fresh PEP summary from DB at 2022-04-14 10:17:19
2022-04-14 04:47:22 INFO:EndpointStatus>> cache miss at 2022-04-14 10:17:22
2022-04-14 04:47:25 ERROR:<br>QUERY: EXEC SEM_GET_OUTOFDATE_CLIENTS_EE_COUNT '2', 'E12BA97D0A620B467BEA6B4C276CD03B', '08968B7D0A6C2D6C00F9CCBE62D49C7F', '', '', '2022-04-03 rev. 999', '2022-03-14 rev. 999', '2022-03-14 rev. 999', '2022-04-03 rev. 999', '2022-03-23 rev. 999', '2022-03-14 rev. 999', '2022-03-14 rev. 999', '1', '1', '1', '1', '', ''<br>EXCEPTION: com_exception: <b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot truncate table 'AGENT_DEF_CACHE' because it is published for replication or enabled for Change Data Capture. in D:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php:587
Stack trace:
#0 D:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(587): com->Execute('EXEC SEM_GET_OU...', -1)
#1 D:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(343): ado_doPreparedStatement('EXEC SEM_GET_OU...', Object(com))
#2 D:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\connectdb.php(239): ado_query('EXEC SEM_GET_OU...', Object(com), false)
#3 D:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting*Dashboard\endpoint_status.php*(195): sav_query('EXEC SEM_GET_OU...', Object(com))
#4 D:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Dashboard\ajax.php(601): include('D:
Program File...')


SQL Replication or the CDC(Change Data Capture) for SEPM SQL Db or some table is enabled.



SEPM 14.3 RU3 with SQL database.


Disable SQL replication or CDC(Change Data Capture) enabled on SEPM SQL DB or tables