AD Sync Issues / SG Inconsistencies in your database Warning

Question

Hi,

SG Version 6.10.0.374

Last nightly full AD sync was successful.

We currently getting the warning prompt when logging into SG "We have found inconsistencies in your database, which shoudl be corrected quickly. Please contact Sophos Support for further assistance"

Support have offered the Keytester tool specific to our SG version. The Keytester tool returns nothing after ‘‘‘‘Check only structure keys’’’’, ‘‘‘‘Check group and structure keys’’’’, ‘‘‘‘Check user and structure keys’’’’ and ‘‘‘‘Check computer and structure keys’’’’. (All Objects selected and under a new MSO account).

We have noticed that we have started to get duplicated users in our database when viewing manually via the MC.

Anyone else experienced this problem or have heard back from support with a fix?

Thanks

This thread was automatically locked due to age.

MarkRobinsonUK · Accepted Answer

Update from support. Given that you are not finding anything with the tool yet the flag is still set in the database to alert you to there being a corruption, it appears a damaged key has been remediate - be it that the key was repairable or had to be deleted. By all means double check and run the tool again and if they are not any issues reported, please apply the SQL query that is found at the bottom of the documentation to remove the flag for that alert when you open the Management Center. Let me know if you have any further questions or whether you would be happy for me to close this case for you. :54902