ORA-1427: single-row subquery returns more than one row Error While Updating BPM Schemas to 11.1.1.4 (Doc ID 1385176.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version 11.1.1.3.0 to 11.1.1.5.0 [Release 11gR1]
Information in this document applies to any platform.
***Checked for relevance on 03-March-2014***

Symptoms


While upgrading SOA 11gR1 to a 11.1.1.4 patch set version, when applying RCU, specifically the file:
upgrade_soainfra_111130_111140_oracle.tsql

the following error may happen:

A SQL Error occurred!: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

oracle.sysman.assistants.common.dbutil.SQLFatalErrorException:
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.onException(JDBCEngine.java:728)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:692)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:636)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleDMLStatement.execute(ANSISQLStatementType.java:780)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1269)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1173)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.main(JDBCEngine.java:2081)
at oracle.ias.mrua.plugin.soa.SOAINFRAPlugin.runJDBCEngine(SOAINFRAPlugin.java:484)
at oracle.ias.mrua.plugin.soa.SOAINFRAPlugin.upgrade_soainfra(SOAINFRAPlugin.java:429)
at oracle.ias.mrua.plugin.soa.SOAINFRAPlugin.doUpgrade(SOAINFRAPlugin.java:268)
at oracle.ias.mrua.MRUA.executePlugins(MRUA.java:2711)
at oracle.ias.mrua.MRUA.internal_driver(MRUA.java:1757)
at oracle.ias.mrua.MRUA.driver(MRUA.java:1205)
at oracle.ias.upgrade.PatchDriver.patchMrUpgradeCLI(PatchDriver.java:143)
at oracle.ias.upgrade.PatchDriver.main(PatchDriver.java:86)
Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more
than one row

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)

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