This is my first post so please go easy on me. I recently deployed the BigFix WebUI based on some posts I read in here with regards to making it easier to do patches. When I deployed this last week it was working fine for a few days but then out of the blue the login page changed from an IBM login page to an HCL login page and I can no longer login.
After entering my credentials I get all green check marks except for “Loading Device Groups” and I just get a spinning white circle that says please wait.
In the datasync.log file I am seeing the below error message which seems to be related to the collation setting of some fields in the SQL database. I have searched for hours and can’t find anyone with a similar problem.
Tue, 07 Apr 2020 19:27:00 GMT bf:datasync:storedProcedures:error Failed to execute “exec WEBUI.COMPUTE_DEVICE_GROUPS ?, ?;” after 5 attempts. Error message: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the not equal to operation.
Does anyone know how to fix this?