Restore lost user access to SAS® Fraud Management after switching between production and disaster recovery systems


When you switch SAS Fraud Management between production and disaster recovery systems, on rare occasions, SAS® Metadata Repository users might get out of sync, which causes some users to lose their access.

To restore access for any user who has lost access, complete the instructions below.

Instructions

The SAS Fraud Management system of record (SOR) database contains the FCM_USER table, which contains information about every authorized user. This table also includes a flag for OMR_PROCESSED, which indicates whether the SAS Fraud Management batch Job 3 has already added this user to SAS Metadata Repository. 

Replication keeps the production and disaster recovery SOR tables in sync, but the production and disaster recovery SAS Metadata Repository servers might get out of sync depending on the file system and network points. By updating the OMR_PROCESSED flag to 0 (zero) and running SAS Fraud Management batch Job 3, you can reapply the user updates from the SOR database to the current SAS Metadata Repository.

Restore Access

To restore access to the SAS Fraud Management Web apps that were lost after a switch between production and disaster recovery, complete the following steps using your preferred database and job tools.

  1. Select * from FCM_USER, where user_id = <userWhoLostAccess>;. This step will confirm that the user is defined in the SOR.
  2. Update fcm_user set OMR_PROCESS_IND = 0, where user_id = <userWhoLostAccess>;. This will reset the flag so that the next run of SAS Fraud Management Job 3 updates the SAS Metadata Repository with this user’s information.
  3. COMMIT; /* To ensure that the change is permanent.
  4. Run your bat_run_job.sh -j 3 as usual with your SAS Metadata Repository user ID. See your SAS Fraud Management System Administrator’s Guide for help with Job 3.

Confirm that the User was Restored

To confirm that the user was restored to SAS Metadata Repository, complete the following steps:

  1. Log on to your SAS® Metadata Server with your SAS install user.
  2. Change the directory to !SASHome/SASManagementConsole/9.4.
  3. Run ./sasmc.
  4. Select SAS Management Console ► User Manager ► and search for the user name that you loaded. In the example below, the user name is sasdemo.   

 User Manager is open, Search is selected, and Name or Display name is filled in with "sasdemo"

If your search does not return the user name, check the log files for job 3. You can find these files in the SASFMCP_IMPLEMENT_HOME/dbmaint/logs/ directory. The log files are named YY_MM_DD_HH_MM_job_3_.log.