My Oracle Support Banner

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 later
Information 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

2024-06-11 16:46:22,125 [[ACTIVE] ExecuteThread: '61' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR util.GoldImageUtil logp.251 - Error occurred while executing the query:ORA-01427: single-row subquery returns more than one row

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.