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
RSA Identity Governance and Lifecycle migration script insertMigrationReportDefinitions.sh fails with error ORA-01017: tab… 184Number 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… 230Number of Views How to resolve an ORA-30036 UNDO Tablespace error in RSA Identity Governance & Lifecycle 541Number of Views RSA January 2025 Release Announcements 84Number of Views 'WFLYDM0085: The alias specified 'server' does not exist in the KeyStore' error in RSA Identity Governance & Lifecycle 288Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?