My Oracle Support Banner

Upgrade Of OBIEE 12.2.1.4 To OAS 5.5 Fails With The Error message "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist" (Doc ID 2713914.1)

Last updated on DECEMBER 03, 2021

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

Running the upgrade assistant to upgrade OBIEE 12.2.1.4 to OAS 5.5 fails with the following errors message though the patch 31143182 already applied.

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:271)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:92)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:971)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1280)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:37
19)
at
oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1427)
at
oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.jav
a:3809)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:378
9)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatement
Wrapper.java:1064)
at
oracle.bi.search.dbstorage.scripting.oracle.SQLPlusScriptRunner.executeScript(SQLPlusScript
Runner.java:57)
at
oracle.bi.search.dbstorage.schema.SchemaInstaller.installSchema(SchemaInstaller.java:348)
... 24 more
Caused by: Error : 942, Position : 0, Sql = ALTER TABLE
S_NQ_SEARCH_CRAWL_JOB_INFO5 RENAME TO
S_NQ_SEARCH_CRAWL_JOB_INFO_TBL, OriginalSql = ALTER TABLE
S_NQ_SEARCH_CRAWL_JOB_INFO5 RENAME TO
S_NQ_SEARCH_CRAWL_JOB_INFO_TBL, Error Msg = ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)

 

Changes

 Upgrading from 12c to OAS 5.5

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.