12.2 E-Business Suite Diagnostic Tests Fail With 'The executable for the test is corrupted ' And 'Invalid test(s) selected' Due To Error 'java.sql.SQLException: ORA-01427: single-row subquery returns more than one row'
(Doc ID 2427099.1)
Last updated on JANUARY 19, 2020
Applies to:
Oracle Applications Manager - Version 12.2 and laterOracle E-Business Suite Diagnostics - Version 12.2.5 and later
Information in this document applies to any platform.
Symptoms
E-Business Suite 12.2 Applications Diagnostics, Diagnostic Interface related issues
The following errors are observed when running diagnostic tests for E-Business Suite applications:
Error messages:
name.
<Test Name> - The executable for the test is corrupted
The concurrent program "Diagnostics Patching CP" also fails with the below error messages in log file:
[main][22:51:45:846, 5/4/17] java.sql.SQLException: ORA-01427: single-row
subquery returns more than one row
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatemen
t.java:947)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1
283)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1
441)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedState
ment.java:3769)
....
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 |