So i did an upgrade to hopefully fix this issue but still im getting this + the "Replication Status: Failed"
At this point, I would suggest getting a support case open.
What Exact SEPM version are you using ?
May be it's bug in SEPM 12.1.5,You need to contact symantec support
see below thread same issue
https://www-secure.symantec.com/connect/forums/query-failed-accessing-security-status-after-1215-upgrade
Hello,
Basically this happens that for some reason when the database is not upgraded during the migration from a previous version . In that case go to
\Program Files\Symantec\Symantec Endpoint Protection Manager\bin (substitute Program Files (x86) in this path if working on a 64 bit system ) and run upgrade.bat then repair the SEP manager installation through Control Panel - Add / Remove programs
Also - Check this document -
Query Failed returned on Home page in SEPM console after a successful migration from 11.0.6 to SEP 12.1
Hope this works for you!!
SEPM 12.1.6 are released
“Query Failed” when switching between log content tables
Fix ID: 3741906
Symptom: “Query Failed” error screen displays when switching between log content tables if the previous table was sorted by a column that is not in the new table.
Solution: Updated sorting column to default to Time if the previous sorting column is not in the new table
https://support.symantec.com/en_US/article.TECH230558.html
12.1.6 just released
Symantec Endpoint Protection 12.1.6 Release Notes
http://www.symantec.com/docs/DOC8626
New fixes in Symantec Endpoint Protection 12.1.6
http://www.symantec.com/docs/TECH230558