search cancel

"Query Failed" when viewing SEPM Security Status details after upgrading to SEP 12.1 RU5


Article ID: 161673


Updated On:


Endpoint Protection


"Query Failed" when viewing SEPM Security Status details. This may occur particularly after upgrading SEPM with embedded database to version 12.1 RU5.

Error in SEPM reporting.log: "Procedure 'SEM_HOMEPAGE_UNMANAGED_DISTINCT_MACHINES' not found"


Symantec is aware of this issue and is investigating. For some reason, the SEM_HOMEPAGE_UNMANAGED_DISTINCT_MACHINES procedure was dropped from the database procedure table during the upgrade.


This article will be updated as new information becomes available. Please contact Symantec Technical support to confirm symptoms against this issue and obtain instructions for manually restoring the missing procedure. Workaround otherwise is to un-/re-install the SEPM.

Applies To

SEPM 12.1 RU5 using embedded database.