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 FEBRUARY 08, 2017

Applies to:

Oracle SOA Suite - Version 11.1.1.9.0 and later
Information 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms