If you encounter an error in your environment and need to delete and recreate your idmuserappdb database tables, you can run the following Java command to rebuild the database:
/JavaPath/jdk1.7.0_65/bin/java -Xms256m -Xmx256m -Dwar.context.name=Context -Ddriver.dn="DriverDN" -Duser.container="UserDN" -jar /UserAppPath/liquibase.jar --databaseClass=liquibase.database.core.PostgresDatabase --driver=org.postgresql.Driver --classpath=/PostgreSQLPath/postgresql/postgresql-8.4-701.jdbc4.jar:/DeployPath/IDMProv.war --changeLogFile=DatabaseChangeLog.xml --url="jdbc:postgresql://localhost:5432/idmuserappdb" --contexts="prov,newdb" --logLevel=info --logFile=/LogPath/db.out --username=DBAdmin --password=DBAdminPassword update
Where JavaPath is the path to your updated JDK or JRE, Context is the context you specified when you installed the User Application (IDMProv, by default), DriverDN is the full DN of the User Application driver, UserDN is the container where users reside, UserAppPath is the path to your main User Application installation directory, PostgreSQLPath is the path to your PostgreSQL installation directory, DeployPath is the path to your User Application and Identity Manager Home Tomcat deploy directory, LogPath is the path to the directory where you want to save the database log, DBAdmin is the database administrator account, and DBAdminPassword is the database administrator password.
For example:
/opt/netiq/idm/jre/bin/java -Xms256m -Xmx256m -Dwar.context.name=IDMProv -Ddriver.dn="cn=User Application Driver,cn=driverset1,o=system" -Duser.container="o=data" -jar /opt/netiq/idm/apps/UserApplication/liquibase.jar --databaseClass=liquibase.database.core.PostgresDatabase --driver=org.postgresql.Driver --classpath=/opt/netiq/idm/apps/postgresql/postgresql-9.3-1101.jdbc41.jar opt/netiq/idm/apps/UserApplication/IDMProv.war --changeLogFile=DatabaseChangeLog.xml --url="jdbc:postgresql://localhost:5432/idmuserappdb" --contexts="prov,newdb" --logLevel=info --logFile=/opt/netiq/idm/apps/UserApplication/db.out --username=******** --password=******** update