My Oracle Support Banner

OBIA 11g: Upgrade 11.1.18.1 BP6 TO 11.1.19.2 'ORA-01430: column being added already exists in table' (Doc ID 2245614.1)

Last updated on JUNE 08, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.
Upgrade from OBIA Version 11.1.18.1 BP6 to OBIA 11.1.19.2

Symptoms

  1. BI Apps upgrade from Version 11.1.1.8.1 BP6 to 11.1.1.9.2
  2. Following Doc ID 2002382.1
  3. Step "5. Upgrading BIACOMP schema"  on PSA is failing. 

 

 

psaxxxxxxPM.out ERROR 1:

rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 1430SQLState:72000 Message: ORA-01430: column being added already exists in table

'/<MW_HOME>/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.1/from11.1.1.8.1/schema/oracle/obiacm/upgrade.sql'Line Number: 28
2017-03-16 22:22:06.769 rcu:Extracted SQL Statement: [ALTER TABLE C_FACT_GROUP ADD
(
USED_IN_LP CHAR(1 BYTE) DEFAULT 'Y'
)]

 

psaxxxxxxPM.out ERROR 2:

 

rcu:Extracting Statement from File Name: '/<MW_HOME>/Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.1/from11.1.1.8.1/schema/oracle/obiacm/upgrade.sql'Line Number: 34
rcu:Extracted SQL Statement: [CREATE SEQUENCE CUSTOM_DOMAIN_KEY_SEQ INCREMENT BY 1 START WITH 1]
2017-03-18 18:37:23.126 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 955SQLState:42000 Message: ORA-00955: name is already used by an existing object

 

psaxxxxxxPM.log ERROR 3:

java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Error in Seed Data Task Util. Exit error code 255
at oracle.as.biapps.upgrade.biacm.CMUpgradePlugin.upgradeBIACM(CMUpgradePlugin.java:225)
at oracle.as.biapps.upgrade.biacm.CMUpgradePlugin.upgrade(CMUpgradePlugin.java:115)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:348)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:295)
at oracle.ias.update.UpgradeDriver.doUpgrades(UpgradeDriver.java:474)
at oracle.ias.update.gui.UAUpgradeThread.run(UAUpgradeThread.java:41)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Error in Seed Data Task Util. Exit error code 255
at oracle.as.biapps.upgrade.util.SeedDataUpgradeUtil.processSeedTasks(SeedDataUpgradeUtil.java:117)
at oracle.as.biapps.upgrade.util.SeedDataUpgradeUtil.executeTasks(SeedDataUpgradeUtil.java:158)
at oracle.as.biapps.upgrade.biacm.CMUpgradePlugin.upgradeBIACM(CMUpgradePlugin.java:208)
... 5 more
Caused by: java.lang.RuntimeException: Error in Seed Data Task Util. Exit error code 255
at oracle.as.biapps.upgrade.util.SeedDataUpgradeUtil.processSeedTasks(SeedDataUpgradeUtil.java:112)

 

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
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.