My Oracle Support Banner

Upgrade Of OBIEE 12.2.1.4 To OAS 5.5 Fails with the following error message: WARNING: Could not install or upgrade BISEARCH database schema java.sql.SQLException: Error running SQL commands in script /rcu/oracle/search/upgrade/upgradetable-bisearch-from- (Doc ID 2667966.1)

Last updated on OCTOBER 26, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
Upgrade of OBIEE 12.2.1.4 to OAS 5.5 Fails, RCU to create schemas during OAS upgrade, the BIPLATFORM schema creation failed

Problem Description
---------------------------------------------------
Running the upgrade assistant to upgrade OBIEE 12.2.1.4 to OAS 5.5 fails with the following errors message:

 

WARNING: Could not install or upgrade BISEARCH database schema
java.sql.SQLException: Error running SQL commands in script /rcu/oracle/search/upgrade/upgradetable-bisearch-from-0.4-to-0.5.sql

[BI-PLATFORMSCHEMA] [INCIDENT_ERROR] [] [upgrade.BI-PLATFORMSCHEMA.SCHEMA] [tid: 90] [ecid: xxxxxxxxx,0] [[
oracle.ias.update.exception.UpgradeException: doUpgrade Failed
at com.oracle.bi.upgrade.schema.BIPlatformPlugin.doAdditionalUpgradeSteps(BIPlatformPlugin.java:51)
at com.oracle.bi.upgrade.schema.AbstractJDBCEnginePlugin.runUpgradeTasks(AbstractJDBCEnginePlugin.java:142)
at com.oracle.bi.upgrade.schema.AbstractJDBCEnginePlugin.upgrade(AbstractJDBCEnginePlugin.java:100)
at com.oracle.bi.upgrade.schema.BIPlatformPlugin.upgrade(BIPlatformPlugin.java:16)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:775)
at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:382)
at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1178)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Caused by: java.lang.RuntimeException: java.sql.SQLException: Error running SQL commands in script /rcu/oracle/search/upgrade/upgradetable-bisearch-from-0.4-to-0.5.sql
at oracle.bi.search.schema.plugin.BISearchSchemaPlugin.update(BISearchSchemaPlugin.java:163)
at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.lambda$executeSchemaPlugins$10(SchemaPluginsProcessor.java:403)
at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.lambda$runSchemaPlugins$9(SchemaPluginsProcessor.java:349)
at java.lang.Iterable.forEach(Iterable.java:75)
at com.oracle.bi.schema.plugin.impl.PluginManager.forEach(PluginManager.java:160)
at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.runSchemaPlugins(SchemaPluginsProcessor.java:346)
at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.executeSchemaPlugins(SchemaPluginsProcessor.java:403)
at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.processSchemaPlugins(SchemaPluginsProcessor.java:452)
at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.processSchemaPlugins(SchemaPluginsProcessor.java:436)
at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.process(SchemaPluginsProcessor.java:148)
at com.oracle.bi.upgrade.schema.BIPlatformPlugin.doAdditionalUpgradeSteps(BIPlatformPlugin.java:45)
... 11 more
Caused by: java.sql.SQLException: Error running SQL commands in script /rcu/oracle/search/upgrade/upgradetable-bisearch-from-0.4-to-0.5.sql
at oracle.bi.search.dbstorage.schema.SchemaInstaller.installSchema(SchemaInstaller.java:378)
at oracle.bi.search.dbstorage.schema.SchemaInstaller.installSchemas(SchemaInstaller.java:164)
at oracle.bi.search.dbstorage.schema.SchemaInstaller.installSchema(SchemaInstaller.java:58)
at oracle.bi.search.schema.plugin.BISearchSchemaPlugin.update(BISearchSchemaPlugin.java:153)
... 21 more
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)

******

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)

************

[Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 90] [ecid: xxxxxxx,0] Finished upgrading BI-PLATFORMSCHEMA.SCHEMA with status: FAILURE.
[Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 90] [ecid: xxxxxxxxx,0] Finished concurrent plugin: BI-PLATFORMSCHEMA.SCHEMA

 



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


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