Page Comparison

\uD83E\uDD14 Problem

The synch service seemes Description: The sync service seems to have deleted all users and then added them again a few minutes later. After this all users has have lost their group belongings.

\uD83C\uDF31 Solution

Solution: To resolve the issue by restoring the database the SQL scripts used are given below :

Step 1: 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

Step 2: 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.

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.

...