How to recreate Access Review db's after installation

  • 7018399
  • 19-Dec-2016
  • 19-Dec-2016

Environment

Mirco Focus Access Review 1.5
Mirco Focus Access Review 2.0+

Situation

How to recreate Access Review db's after installation.

Resolution

1. Stop Tomcat /etc/init.d/idmapps_tomcat_init stop

2. Drop the three (3) databases in postgres (ardcs, arops, arwf).  Drop just the databases

3. Copy the command from the /opt/netiq/idm/apps/accessreview/logs/dbtool-create-log.txt.  Fix the database passwords of xxx to the real values.  Then issue the command

4. Go to /opt/netiq/idm/apps/accessreview/bin and issue ./db-init.sh -password %password%

*Note, you may want to redirect this to a file*

5. Copy command from  /opt/netiq/idm/apps/accessreview/logs/configinit-log.txt.  Fix the database passwords of xxx to the real values.  Then issue the command

6. Copy the command from the /opt/netiq/idm/apps/accessreview/logs/dbtool-rptuser-log.txt.   Fix the database passwords of xxx to the real values.  Then issue the command

7. Clear out temp, work/Catalina, logs directories under/opt/netiq/idm/apps/tomcat

8. Start Tomcat /etc/init.d/idmapps_tomcat_init start