Hi All,

We had an IDM 4.6 installation using the default PostgreSQL DB.
We now are trying to use a new Oracle 12c DB for that installation (new Database, it's not necessary to migrate content since we are creating a new empty DB).

All the Tables, Indexes, Function and Sequences were created using the liquibase process:

Code:
/opt/netiq/idm/apps/jre/bin/java -Xms256m -Xmx256m -Dwar.context.name=Context -Ddriver.dn="xxxxxxxx" -Duser.container="xxxxxxx" -jar /opt/netiq/idm/apps/UserApplication/liquibase.jar --databaseClass=liquibase.database.core.OracleDatabase --driver=oracle.jdbc.OracleDriver --classpath=/opt/netiq/idm/apps/tomcat/lib/ojdbc6.jar:/opt/netiq/idm/apps/tomcat/webapps/IDMProv.war --changeLogFile=DatabaseChangeLog.xml --url="jdbc:oracle:thin:@xxxxxxx:xxxx:xxxxx" --contexts="prov,newdb" --logLevel=info --logFile=/tmp/db.out --username=xxxx --password=xxxxxx update

Our server.xml file has the following lines within it:

Code:
<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory" initialSize="10" maxActive="50" maxIdle="10" maxWait="30000" minIdle="10" name="shared/IDMUADataSource" password="<encypted-password>" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@xxxxxxxxxx:xxxx:xxxxx" username="xxxx" validationInterval="120000" validationQuery="SELECT 1 from DUAL"/>

However, when we start our app server we received the following error:

Code:
2017-08-14 20:04:20,327 [ERROR] EboBootServlet [RBPM] Runtime exception initializing.
com.netiq.persist.PersistenceException: ORA-00942: table or view does not exist


        at com.netiq.persist.HibernateUtil.isTableFound(HibernateUtil.java:611)
        at com.netiq.persist.HibernateUtil.isTableFound(HibernateUtil.java:566)
        at com.novell.soa.persist.DatabaseSchemaUpdate.analyzeSchema(DatabaseSchemaUpdate.java:280)
        at com.novell.soa.persist.DatabaseSchemaUpdate.validateDatabaseSchema(DatabaseSchemaUpdate.java:225)
        at com.sssw.fw.servlet.EboBootServlet.init(EboBootServlet.java:98)
        at com.sssw.portal.servlet.EboPortalBootServlet.init(EboPortalBootServlet.java:58)
        at javax.servlet.GenericServlet.init(GenericServlet.java:158)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4913)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5223)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
        at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
        at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
        at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
        at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210)
        at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:210)
        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:151)
        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:69)
        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:62)
        at com.netiq.persist.HibernateUtil.isTableFound(HibernateUtil.java:592)
        ... 22 more
After the first time we saw this, we tried to update the database with the liquibase command (--contexts="prov,updatedb") and also verified all the tables with the liquibase updateSQL command.

However, the error is still there.

We also set the com.netiq.idm.create-db-on-startup = true , but ended up with the same errors.

Any ideas how can we continue troubleshooting this?

Thanks in Advance.