SOA 11.1.1.9 Patch Set Assistant Fails with "column being added already exists in table" Error
(Doc ID 2231617.1)
Last updated on NOVEMBER 16, 2023
Applies to:
Oracle SOA Suite - Version 11.1.1.9.0 and laterInformation in this document applies to any platform.
Symptoms
While running Patch Set Assistant (PSA) for 11.1.1.9 SOA suite following error is observed in the logs.
[2017-01-19T11:50:14.614-05:00] [RCU] [ERROR] [upgrade.RCU.jdbcEngine] Error encountered executing SQL statement FileName: '/u01/app/oracle/middleware/fmw11115/Oracle_SOA/rcu/integration/soainfra//sql/upgrade_soainfra_111171_111190_oracle.tsql' LineNumber: '1020' Script log file: null
[2017-01-19T11:50:14.614-05:00] [SOA] [ERROR] [upgrade.SOA.SOA1] UPGAST-00221: unexpected error uprading schema
[2017-01-19T11:50:14.614-05:00] [SOA] [ERROR] [upgrade.SOA.SOA1]
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-01430: column being added already exists in table
Line 1020 ALTER TABLE MEDIATOR_RESEQUENCER_MESSAGE ADD MI_PARTITION_DATE TIMESTAMP;
Line 1021 ALTER TABLE MEDIATOR_GROUP_STATUS ADD CREATION_DATE TIMESTAMP
This causes the PSA to fail for the SOAINFRA Schema
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 |