Fleet:OEM 13c Fleet Maintenance Hub Failed To Load Target Patch Compliance Tab
(Doc ID 3031075.1)
Last updated on JUNE 25, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Target patch compliance table on Fleet Maintenance Hub page keeps loading and doesn't show any results.
<EM_INSTANCE>/gc_inst/em/EMGC_OMS(n)/sysman/log/emoms.trc
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:271) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:92) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:808) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1044) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1243) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3719) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1427) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3766) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1168) ~[ojdbc8dms.jar:19.3.0.0.0]
at oracle.sysman.emSDK.core.util.jdbc.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:408) ~[emCoreSDK.jar:?]
at oracle.sysman.db.restfulapi.goldimage.util.GoldImageUtil.executeQuery_namedParameters(GoldImageUtil.java:271) [em-db-restfulapi-pojo.jar:?]
at oracle.sysman.db.restfulapi.goldimage.service.GoldImageService.getItems_targetsPatchComplianceReport(GoldImageService.java:2218) [em-db-restfulapi-pojo.jar:?]
at oracle.sysman.db.restfulapi.goldimage.service.GoldImageService.getTargetsPatchComplianceReport(GoldImageService.java:2160) [em-db-restfulapi-pojo.jar:?]
at oracle.sysman.db.restfulapi.goldimage.GoldImageAPI.targetsPatchComplianceReport(GoldImageAPI.java:455) [em-db-restfulapi-pojo.jar:?]
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 |