RSA Identity Governance & Lifecycle upgrade or migration error "ORA-00942: table or view does not exist"
Originally Published: 2018-04-11
Article Number
Applies To
RSA Version/Condition: 7.0.2 P05 or earlier
Issue
The following error is logged in the aveksaServer.log
04/04/2018 23:41:17.752 ERROR (Schema Migration) [com.aveksa.migration.jdbctool.CheckDatabase] ORA-00942: table or view does not exist
ORA-06512: at "AVUSER_TEST.REPORT_VIEWS_PKG", line 10967
ORA-06512: at line 1
04/04/2018 23:41:17.753 FATAL (Schema Migration) [com.aveksa.migration.jdbctool.CheckDatabase]
****************************************
Migration has failed!
ORA-00942: table or view does not exist
ORA-06512: at "AVUSER_TEST.REPORT_VIEWS_PKG", line 10967
ORA-06512: at line 1
****************************************
The following error is logged in the migration.log
-------
SQL/line#: /usr/wls/domains/DOMAINNAME/servers/AveksaSrv1/tmp/_WL_user/aveksa/32gp3v/aveksa.war/WEB-INF/database/migration/createReportViews.sql(1):
Start time [Wed Apr 04 23:41:06 UTC 2018]
begin Report_Views_Pkg.create_av_report_views; end;
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ORA-06512: at "AVUSER_TEST.REPORT_VIEWS_PKG", line 10967
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1707)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1670)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:310)
at weblogic.jdbc.wrapper.Statement.executeUpdate(Statement.java:535)
at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:221)
at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:107)
at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:98)
at com.aveksa.migration.jdbctool.IncrementalUpdate.update(IncrementalUpdate.java:481)
at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:140)
at com.aveksa.migration.jdbctool.CheckDatabase.migrateSchema(CheckDatabase.java:1375)
at com.aveksa.migration.jdbctool.CheckDatabase.migrateSchema(CheckDatabase.java:1349)
at com.aveksa.migration.jdbctool.CheckDatabase.runMigration(CheckDatabase.java:2045)
at com.aveksa.migration.jdbctool.CheckDatabase.run(CheckDatabase.java:1991)
at java.lang.Thread.run(Thread.java:745)Cause
Resolution
- RSA Identity Governance & Lifecyle 7.1.0 GA version
- RSA Identity Governance & Lifecyle 7.0.2 P06
Workaround
Notes
- If possible, upgrade to the 7.1.0 version that does not have this issue.
- If you must upgrade to the 7.0.2 version:
- If you are upgrading on WebSphere or WebLogic, you can upgrade directly to the patch by applying the 7.0.2 P06 ear file directly.
- If you encounter this error while upgrading on WildFly, there is no supportable in-place upgrade path to 7.0.2. (There is no means of upgrading to a patch, you must first upgrade to the 7.0.2 GA version.) Customers should install a new version of 7.0.2 and patch to 7.0.2 P06 and then import the database from a backup.
Related Articles
Failed to connect to the database error during upgrade to RSA Identity Governance & Lifecycle 7.0.1 226Number of Views How to query a public database schema table for Segregation of Duties (SOD) violations in RSA Identity Governance & Lifecycle 98Number of Views How to resolve an ORA-30036 UNDO Tablespace error in RSA Identity Governance & Lifecycle 540Number of Views 'ORA-00942: Table or View does not exist' error when referencing a custom table/view in a report query in RSA Identity Gov… 228Number of Views How to generate Oracle database performance statistics in RSA Governance & Lifecycle 60Number of Views
Trending Articles
Oracle 12c TEMP_UNDO_ENABLED parameter for managing GTT UNDO activity in RSA Identity Governance & Lifecycle RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Unable to attach a replica instance due to a configuration error when enabling replication for the RADIUS server for RSA A… RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle
Don't see what you're looking for?