You can recreate the database tables after installation without having to reinstall. This section helps you create the database schema.
Stop Tomcat.
For example:
/etc/init.d/idmapps_tomcat_init stop
(Conditional) Delete the existing database
(Conditional) Create a new database with the same name as the one that you deleted in Step 2
(Conditional) Clear the database checksums
Log in to your database as idm_rpt_cfg.
Execute the following command for PostgresSQL:
DO $do$ BEGIN IF EXISTS (select table_name from information_schema.tables where table_schema = 'public' and table_name = 'databasechangelog') THEN update databasechangelog set md5sum = null; END IF; END $do$
or
Execute the following command for Oracle:
BEGIN FOR i IN (select null from ALL_TABLES where OWNER = user and TABLE_NAME = 'DATABASECHANGELOG') LOOP EXECUTE IMMEDIATE 'update DATABASECHANGELOG set MD5SUM = NULL'; END LOOP; END;
Log in to your database as idm_rpt_data.
Repeat the commands issued in Step 4.b as the idm_rpt_data user.
Define the JAVA_HOME variable. For example:
export JAVA_HOME=/opt/netiq/idm/apps/jre
Re-initialize the database using the installed script:
Regenerate the database tables by executing the following command:
/opt/netiq/idm/apps/IdentityReporting/bin/db-init.sh -cfg_password *** -data_password ***
Generate the SQL files by executing the following command:
/opt/netiq/idm/apps/IdentityReporting/bin/db-init.sh -cfg_password *** -data_password *** -sql > /opt/netiq/idm/apps/IdentityReporting/sql/output.sql
You use SQL files to regenerate the database tables.
Start Tomcat. For example:
/etc/init.d/idmapps_tomcat_init start