My Oracle Support Banner

13.4: Upgrading OMS Fails During Repository Configuration With Error: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2678110.1)

Last updated on JUNE 05, 2020

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Upgrading OMS to 13.4 fails during the repository configuration with the error:

OMS_HOME/cfgtoollogs/cfgfw/CfmLogger<timestamp>.log

Fri Apr 24 12:52:25.590 EDT 2020 rcu:Extracted Statement from File Name: '<OMS_HOME>/sysman/admin/emdrep/sql/core/latest/admin/pre_data_modify.sql'Line Number: 88
Fri Apr 24 12:52:25.590 EDT 2020 rcu:Statement Type: 'BEGIN/END Anonymous Block'
Fri Apr 24 12:52:25.591 EDT 2020 rcu:Extracted SQL Statement: [DEFINE EM_SQL_ROOT = <OMS_HOME>/sysman/admin/emdrep/sql]
Fri Apr 24 12:52:25.591 EDT 2020 rcu:Extracted SQL Statement: [DEFINE EM_SQL_ROOT = <OMS_HOME>/sysman/admin/emdrep/sql]
Fri Apr 24 12:52:25.591 EDT 2020 rcu:Extracted Statement from File Name: '<OMS_HOME>/sysman/admin/emdrep/sql/upgrade_header.sql'Line Number: 1844
Fri Apr 24 12:52:25.591 EDT 2020 rcu:Statement Type: 'DEFINE Statement'
Fri Apr 24 12:52:25.591 EDT 2020 rcu:Extracted SQL Statement: [BEGIN
EM_JOBTYPE.register_command('remoteOp','oracle.sysman.emdrep.jobs.commands.RemoteOp','0','1','1',NULL,'oracle.sysman.core','3');
EM_JOBTYPE.register_command('sqlOp','oracle.sysman.emdrep.jobs.commands.SqlOp','0','1','1',NULL,'oracle.sysman.core','3');
EM_JOBTYPE.register_command('execAndSuspend','oracle.sysman.emdrep.jobs.commands.ExecAndSuspend','0','0','0',NULL,'oracle.sysman.core','3');
EM_JOBTYPE.register_command('getFile','oracle.sysman.emdrep.jobs.commands.GetFile','1','1','1',NULL,'oracle.sysman.core','3');
EM_JOBTYPE.register_command('putFile','oracle.sysman.emdrep.jobs.commands.PutFile','1','1','1',NULL,'oracle.sysman.core','3');
EM_JOBTYPE.register_command('fileTransfer','oracle.sysman.emdrep.jobs.commands.FileTransfer','0','1','1',NULL,'oracle.sysman.core','3');
EM_JOBTYPE.register_command('email','oracle.sysman.emdrep.jobs.commands.Email','1','0','0',NULL,'oracle.sysman.core','3');
EM_JOBTYPE.register_command('repSQL','oracle.sysman.emdrep.jobs.commands.RepSQL','1','0','0',NULL,'oracle.sysman.core','3');
EM_JOBTYPE.register_command('DiscoverAndPromoteOH','oracle.sysman.eml.ecm.track.DiscoverAndPromoteOH','1','0','0',NULL,'oracle.sysman.core','3');

COMMIT;
END;
]
Fri Apr 24 12:52:25.591 EDT 2020 rcu:Extracted Statement from File Name: '<OMS_HOME>/sysman/admin/emdrep/sql/core_metadata/13.4.0.0.0/commands/commands_data_upgrade.sql'Line Number: 16
Fri Apr 24 12:52:25.591 EDT 2020 rcu:Statement Type: 'BEGIN/END Anonymous Block'
JDBC SQLException - ErrorCode: 1422SQLState:21000 Message: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYSMAN.MGMT_USER", line 12476
ORA-06512: at "SYSMAN.MGMT_USER", line 458
ORA-06512: at "SYSMAN.MGMT_USER", line 1299
ORA-06512: at "SYSMAN.MGMT_USER", line 11774
ORA-06512: at "SYSMAN.MGMT_USER", line 11728
ORA-06512: at "SYSMAN.MGMT_USER", line 11831
ORA-06512: at "SYSMAN.MGMT_USER", line 11904
ORA-06512: at "SYSMAN.MGMT_USER", line 12281
ORA-06512: at "SYSMAN.MGMT_USER", line 12281
ORA-06512: at "SYSMAN.SETEMUSERCONTEXT", line 52
ORA-06512: at "SYSMAN.MGMT_USER", line 12521
ORA-06512: at "SYSMAN.EM_JOB_ACCESS_CHECK", line 4
ORA-06512: at "SYSMAN.EM_JOBTYPE", line 2804
ORA-06512: at line 2

 

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.