OWB 11.2.0.3 oracle.wh.util.locationhelper.LocationTool Fails With ORA-01422 in Interactive Mode (Doc ID 1363060.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Execution of the OWB 11.2.0.3 Java Tool oracle.wh.util.locationhelper.LocationTool in interactive mode fails with:

ORA-01422: exact fetch returns more than requested number of rows

The full stack would look like this:

[oracle@JPVMEL5 unix]$ $JAVA_HOME/bin/java -classpath $OWB_HOME/owb/lib/int/util.jar:$OWB_HOME/jdbc/lib/ojdbc5.jar oracle.wh.util.locationhelper.LocationTool -interactive -config localhost 1521 ORCL WSO owb
CompilerOracle: exclude oracle/wh/runtime/platform/service/Service run
Run the whole failover process in interactive way

>>>>>>>>>>1. Check Enterprise ETL option for OWB installation
Succeed!

>>>>>>>>>>2. Update OWB Control Center home
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "OWBSYS.WB_LOCATION_HELPER", line 65
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1034)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1088)
at oracle.wh.util.locationhelper.job.UpdateOWBCCHome.getOWBCCHome(UpdateOWBCCHome.java:78)
at oracle.wh.util.locationhelper.job.UpdateOWBCCHome.run(UpdateOWBCCHome.java:55)
at oracle.wh.util.locationhelper.task.TaskImpl.runCurrentJob(TaskImpl.java:177)
at oracle.wh.util.locationhelper.task.TaskImpl.run(TaskImpl.java:84)
at oracle.wh.util.locationhelper.LocationTool.main(LocationTool.java:64)
Fail!

Start rollback jobs......
Rollback complete!

Exception in thread "main" java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "OWBSYS.WB_LOCATION_HELPER", line 65
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1034)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1088)
at oracle.wh.util.locationhelper.job.UpdateOWBCCHome.getOWBCCHome(UpdateOWBCCHome.java:78)
at oracle.wh.util.locationhelper.job.UpdateOWBCCHome.run(UpdateOWBCCHome.java:55)
at oracle.wh.util.locationhelper.task.TaskImpl.runCurrentJob(TaskImpl.java:177)
at oracle.wh.util.locationhelper.task.TaskImpl.run(TaskImpl.java:84)
at oracle.wh.util.locationhelper.LocationTool.main(LocationTool.java:64)
[oracle@JPVMEL5 unix]$>>>>>>>>>>>>>>>>>>>>

 

Changes

Database and Repository have been upgraded from 11.2.0.x to 11.2.0.3.

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