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

Products

• Endpoint Protection

Issue/Introduction

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...')

Environment

SEPM 14.3 RU3 with SQL database.

Cause

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

 

Resolution

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

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-data-capture-sql-server?view=sql-server-ver15