My Oracle Support Banner

EM 13.4 : Agent Create Patch Plan Fails With EMAnalyzePlanBox.initialize failed - java.sql.SQLException: ORA-01427: single-row subquery returns more than one row (Doc ID 2760662.1)

Last updated on MARCH 18, 2021

Applies to:

Enterprise Manager Base Platform - Version 13.4.1.0.0 to 13.4.1.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

Creating a Patch Plan in Enterprise Manager (EM) 13c Cloud Control for patching EM Agents fails with following error :

 

 

The following entry is found in <OMS instance Base>/em/EMGC_OMS1/sysman/log/emoms.trc:

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: Error : 1427, Position : 528, Sql = with targets as ( select tab.column_value as target_guid from (TABLE(CAST( :1 AS MGMT_SHORT_STRING_ARRAY))) tab ) select distinct t.target_guid, t.target_name, t.target_type, t.host_name, nvl((case when t.target_type != 'oracle_home' then (select tp.property_value from mgmt$target_properties tp where tp.target_guid = t.target_guid and tp.property_name = 'OracleHome' and tp.property_type = 'INSTANCE') else (select h.home_location from mgmt$oh_home_info h where h.target_guid = t.target_guid) end), '') oracle_home, nvl((select oh_target_name from mgmt$oh_installed_targets oh where oh.inst_target_name = t.target_name and oh.inst_target_type = t.target_type), '') oh_target_name from targets tg, mgmt_targets t where t.target_guid = hextoraw(tg.target_guid), OriginalSql = with targets as ( select tab.column_value as target_guid from (TABLE(CAST( ? AS MGMT_SHORT_STRING_ARRAY))) tab ) select distinct t.target_guid, t.target_name, t.target_type, t.host_name, nvl((case when t.target_type != 'oracle_home' then (select tp.property_value from mgmt$target_properties tp where tp.target_guid = t.target_guid and tp.property_name = 'OracleHome' and tp.property_type = 'INSTANCE') else (select h.home_location from mgmt$oh_home_info h where h.target_guid = t.target_guid) end), '') oracle_home, nvl((select oh_target_name from mgmt$oh_installed_targets oh where oh.inst_target_name = t.target_name and oh.inst_target_type = t.target_type), '') oh_target_name from targets tg, mgmt_targets t where t.target_guid = hextoraw(tg.target_guid), Error Msg = ORA-01427: single-row subquery returns more than one row
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 385 more
2021-03-12 14:52:09,454 [[ACTIVE] ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR model.EMAnalyzePlanBox logp.251 - EMAnalyzePlanBox.initialize failed
oracle.mos.patch.exception.PatchBusinessException: oracle.mos.patch.exception.PatchBusinessException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

 

 

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.