\uD83E\uDD14 Problem
The synch service 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
SQL used to import data to production
create table eln.groupexport(usera nvarchar(40), groupb nvarchar(40));
Run insert statements from output of statement in previous comment.
begin tran
insert into eln.DIRUSERGROUP
select ua.PKEY, ub.pkey
from eln.groupexport ge
inner join eln.USER_DETAILS ua on GE.usera=ua.USERID
inner join eln.USER_DETAILS ub on GE.groupb=ub.USERID
where not exists (select pkeya, pkeyb from eln.DIRUSERGROUP where PKEYA=ua.PKEY and pkeyb=ub.pkey)
rollback tran
(rollback is to be able to check before, change to commit tran)
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.