How to replace Old UserID with New UserId in ELN?

How to replace Old UserID with New UserId in ELN?

Updating the ELN UserID

Explanation:

After changing the UserID in ELN, it will not update the DB Schema. We need to manually update DB tables.

Resulting Errors:

1. Error initialization field waiting documents: the user name UserID is not recognized.
2. Unauthorized user/User not defined - If the users are as witness in the earlier experiments.

Steps to apply the changes:

1. Login into ELN with admin user, right click on the UserID (Which had to be renamed) > UserInfo > Change the UserID as required.
2. Go to - ELN installation location...\CSDocStore\DataBase\Change_LTA_User_Name\
1. Run CREATE_Change_LTA_User batch file (Execute only once).
2. Enter Oracle System User Name & Password and LTA Schema Name accordingly.
3. It creates Stored Procedure and Audit table.
3. Run Call_SP_Change_LTA_User batch file (This needs to be executed individually every time after updating UserID in ELN individually).
1. Enter Oracle System User Name & Password and LTA Schema Name accordingly.
2. Enter “Administrator Name” , “New User Name” and “Old User Name”.
3. It updates all tables and enters details to Audit table.

Important:

This script is required only when the User is being used as a Witness or Author or Coauthor in Sign and Close of any experiment and thereafter changing the UserID of that particular User.

1. Do not execute these batch files on a deactivated UserID.
2. While changing the OLD UserID to New UserID, Make Sure the New UserID is unique (As unique check would not be performed by this batch file). If New UserID overrides any existing UserID, those changes cannot be rolled back.
3. This process works for both ELN authentication (LDAP and Oracle).

Please contact Enterprise Support if you need more assistance on the same.