Applying Patch Version 105.6.0-102 Directly On Top Of 105.1.x Fails With "ORA-00904" In Oracle Analytics
(Doc ID 2695574.1)
Last updated on AUGUST 01, 2020
Applies to:
Oracle Analytics Cloud - Classic - Version 105.5.0 to 105.6.0 [Release 105.3]Information in this document applies to any platform.
Symptoms
Applying Oracle Analytics Cloud (OAC) patch version 105.6.0-102 directly on top of 105.1.x fails with ORA-00904: "TG"."STRIPE_ID": invalid identifier
Patch log shows below exception :
DEBUG [ERR] INFO: Running script task oracle.bi.web.datasetsvc.rcu.ModelOutputDatasetTagCreator
DEBUG [ERR] <TIMESTAMP> oracle.bi.web.datasetsvc.cloud.schemaplugin.DSSSchemaPlugin update
DEBUG [ERR] WARNING: Could not install or upgrade DSS database schema
DEBUG [ERR] oracle.bi.web.datasetsvc.api.core.exception.DatabaseInitializationException: java.sql.SQLException: Error running script task oracle.bi.web.datasetsvc.rcu.ModelOutputDatasetTagCreator
DEBUG [ERR] at oracle.bi.web.datasetsvc.extension.SchemaInstallerHelper.installDatabase(SchemaInstallerHelper.java:161)
DEBUG [ERR] at oracle.bi.web.datasetsvc.cloud.schemaplugin.DSSSchemaPlugin.update(DSSSchemaPlugin.java:112)
DEBUG [ERR] at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.lambda$executeSchemaPlugins$8(SchemaPluginsProcessor.java:355)
DEBUG [ERR] at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.lambda$runSchemaPlugins$7(SchemaPluginsProcessor.java:300)
DEBUG [ERR] at java.lang.Iterable.forEach(Iterable.java:75)
DEBUG [ERR] at com.oracle.bi.schema.plugin.impl.PluginManager.forEach(PluginManager.java:160)
DEBUG [ERR] at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.runSchemaPlugins(SchemaPluginsProcessor.java:297)
DEBUG [ERR] at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.executeSchemaPlugins(SchemaPluginsProcessor.java:355)
DEBUG [ERR] at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.processSchemaPlugins(SchemaPluginsProcessor.java:404)
DEBUG [ERR] at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.processSchemaPlugins(SchemaPluginsProcessor.java:388)
DEBUG [ERR] at com.oracle.bi.schema.plugin.impl.SchemaPluginsProcessor.process(SchemaPluginsProcessor.java:144)
DEBUG [ERR] at com.oracle.bi.upgrade.schema.BIPlatformPlugin.doAdditionalUpgradeSteps(BIPlatformPlugin.java:45)
DEBUG [ERR] at com.oracle.bi.upgrade.schema.AbstractJDBCEnginePlugin.runUpgradeTasks(AbstractJDBCEnginePlugin.java:147)
DEBUG [OUT] 0%
- 5%
-- 10%
------------------------- 100%
Oracle Business Intelligence Schema schema upgrade finished with status: failed
DEBUG [ERR] at com.oracle.bi.upgrade.schema.AbstractJDBCEnginePlugin.upgrade(AbstractJDBCEnginePlugin.java:101)
DEBUG [ERR] at com.oracle.bi.upgrade.schema.BIPlatformPlugin.upgrade(BIPlatformPlugin.java:16)
DEBUG [ERR] at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
DEBUG [ERR] at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
DEBUG [ERR] at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:775)
DEBUG [ERR] at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:382)
DEBUG [ERR] at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1178)
DEBUG [ERR] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
DEBUG [ERR] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
DEBUG [ERR] at java.lang.Thread.run(Thread.java:748)
DEBUG [ERR] Caused by: java.sql.SQLException: Error running script task oracle.bi.web.datasetsvc.rcu.ModelOutputDatasetTagCreator
DEBUG [ERR] at oracle.bi.web.datasetsvc.dbstorage.schema.SchemaInstaller.installSchema(SchemaInstaller.java:395)
DEBUG [ERR] at oracle.bi.web.datasetsvc.dbstorage.schema.SchemaInstaller.installSchemas(SchemaInstaller.java:194)
DEBUG [ERR] at oracle.bi.web.datasetsvc.dbstorage.schema.SchemaInstaller.installSchema(SchemaInstaller.java:64)
DEBUG [ERR] at oracle.bi.web.datasetsvc.extension.SchemaInstallerHelper.installDatabase(SchemaInstallerHelper.java:99)
DEBUG [ERR] ... 22 more
DEBUG [ERR] Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "TG"."STRIPE_ID": invalid identifier
DEBUG [ERR]
DEBUG [ERR] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
DEBUG [ERR] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
DEBUG [ERR] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
DEBUG [ERR] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
DEBUG [ERR] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
DEBUG [ERR] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
DEBUG [ERR] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:271)
DEBUG [ERR] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:92)
DEBUG [ERR] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:808)
DEBUG [ERR] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1044)
DEBUG [ERR] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1243)
DEBUG [ERR] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3719)
DEBUG [ERR] at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1427)
DEBUG [ERR] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3766)
DEBUG [ERR] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1168)
DEBUG [ERR] at oracle.bi.web.datasetsvc.tagging.DBUtils.enumerateObjectTags(DBUtils.java:91)
DEBUG [ERR] at oracle.bi.web.datasetsvc.tagging.DBUtils.tagObject(DBUtils.java:109)
DEBUG [ERR] at oracle.bi.web.datasetsvc.rcu.ModelOutputDatasetTagCreator.createTags(ModelOutputDatasetTagCreator.java:89)
DEBUG [ERR] at oracle.bi.web.datasetsvc.rcu.ModelOutputDatasetTagCreator.execute(ModelOutputDatasetTagCreator.java:30)
DEBUG [ERR] at oracle.bi.web.datasetsvc.dbstorage.schema.SchemaInstaller.installSchema(SchemaInstaller.java:382)
DEBUG [ERR] ... 25 more
DEBUG [ERR] Caused by: Error : 904, Position : 268, Sql = SELECT /*<BIPLATFORM SCHEMA>*/ tgMap.OBJECT_NAME, tgMap.NAMESPACE, tg.TAG_NAME, obtp.OBJECT_TYPE AS OBJECT_TYPE_NAME, tgMap.OBJECT_FQDN FROM S_NQ_DSS_TAG_MAPPINGS tgMap INNER JOIN S_NQ_DSS_TAGS tg ON tg.TAG_ID = tgMap.TAG_ID AND (tg.STRIPE_ID = tgMap.STRIPE_ID OR tg.STRIPE_ID IS NULL) INNER JOIN S_NQ_DSS_OBJECT_TYPES obtp ON obtp.OBJECT_TYPE_ID = tgMap.OBJECT_TYPE_ID WHERE tg.TAG_NAME in (:1 ) AND tgMap.OBJECT_TYPE_ID = :2 AND tgMap.STRIPE_ID = :3 AND tgMap.NAMESPACE = :4 AND tgMap.OBJECT_NAME = :5 , OriginalSql = SELECT /*OAC353393477_BIPLATFORM*/ tgMap.OBJECT_NAME, tgMap.NAMESPACE, tg.TAG_NAME, obtp.OBJECT_TYPE AS OBJECT_TYPE_NAME, tgMap.OBJECT_FQDN FROM S_NQ_DSS_TAG_MAPPINGS tgMap INNER JOIN S_NQ_DSS_TAGS tg ON tg.TAG_ID = tgMap.TAG_ID AND (tg.STRIPE_ID = tgMap.STRIPE_ID OR tg.STRIPE_ID IS NULL) INNER JOIN S_NQ_DSS_OBJECT_TYPES obtp ON obtp.OBJECT_TYPE_ID = tgMap.OBJECT_TYPE_ID WHERE tg.TAG_NAME in (?) AND tgMap.OBJECT_TYPE_ID = ? AND tgMap.STRIPE_ID = ? AND tgMap.NAMESPACE = ? AND tgMap.OBJECT_NAME = ?, Error Msg = ORA-00904: "TG"."STRIPE_ID": invalid identifier
DEBUG [ERR]
DEBUG [ERR] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
DEBUG [ERR] ... 44 more
DEBUG [ERR]
DEBUG [ERR] The command failed to complete successfully
DEBUG RETCODE:255
INFO Result of running upgrade script: 255
ERROR Error running patch process on Admin Node: Domain configuration upgrade steps failed.
Traceback (most recent call last):
File "/u01/app/5.6.0.0.0-20200617201803-0.0.0/fmw/bi/modules/oracle.bi.cloudprovisioning/verb/pod_operations/patching/impl/patch.py", line 113, in patch
patch_admin_vm(admin_vm, undo_list, patch_config, is_zero_downtime, provision_args)
File "/u01/app/5.6.0.0.0-20200617201803-0.0.0/fmw/bi/modules/oracle.bi.cloudprovisioning/verb/pod_operations/patching/impl/patch.py", line 376, in patch_admin_vm
run_upgrade_script(patch_config, zero_downtime)
File "/u01/app/5.6.0.0.0-20200617201803-0.0.0/fmw/bi/modules/oracle.bi.cloudprovisioning/verb/pod_operations/patching/impl/patch.py", line 254, in run_upgrade_script
raise Exception("Domain configuration upgrade steps failed.")
Exception: Domain configuration upgrade steps failed.
Changes
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 |