On login to Symantec Endpoint Protection Manager (SEPM), the Home page shows a "Query Failed" message.
Following error is found in scm-server-0.log:2025-02-23 00:00:41.527 THREAD 632086 WARNING: DatabaseUtilities>>executeUpdateByChunk Exception:com.microsoft.sqlserver.jdbc.SQLServerException: Internal Query Processor Error: The query processor encountered an unexpected error during execution (HRESULT = 0x80040e19).
SEPM 14.3 RU1+
This error is indicating an issue with index corruption on SEPM database tables.
Take a backup of SEPM database (default sem5). Then perform the below steps:
Few other articles with the same error but different causes:
Endpoint Protection Manager Home page displays error: Query Failed
Endpoint Protection Manager Home/dashboard page error "Query Failed"