\uD83E\uDD14 Problem
The synch service seemes seems to have deleted all users and then added them again a few minutes later. After this all users has lost their group belongings.
\uD83C\uDF31 Solution
To resolve the issue by restoring the database the SQL scripts used are given below
SQL used to extract data from copy database
select pkeya, ua.userid usera, PKEYB, ub.USERID groupb, 'insert into eln.groupexport values(''' + ua.USERID + ''', ''' + ub.userid + ''');' as insertstatement
from eln.DIRUSERGROUP du
inner join eln.user_details ua on du.PKEYA = ua.pkey
inner join eln.user_details ub on du.PKEYB = ub.pkey
where PKEYB != 89
...
Support team have confirmed with DS on this topic and the planned fix for the issue is scheduled around June 2022 and DS recommends not to perform any upgrades or install any patches until then. If urgent we can always check with them if its okay to go ahead.
The suggestion is to monitor the directory sync service and get their help if any restores are needed. We can also check the request-responses from the client-server when these happen and see if it gives us any insight to the cause on the server, we can help if needed.
| Info |
|---|
Highlight important information in a panel like this one. To edit this panel's color or style, select one of the options in the menu. |
...