E-Business Suite Applications Management Pack 13.1 Patch Post Install Steps Fail With Error 'EM-04041: Error occurred during Metadata registration. Error is: java.sql.SQLException: ORA-01489: result of string concatenation is too long' (Doc ID 2462790.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Symptoms

E-Business Suite Applications Management Pack 13.1.1.1.0, Patch Application Issues

After upgrading OEM from 12.1.0.5 to 13.1 when applying a patch and performing the post install steps the following error is received:

'EM-04041: Error occurred during Metadata registration. Error is: java.sql.SQLException: ORA-01489: result of string concatenation is too long ORA-06512: at line 1960'

The complete details are as follows:

> emctl register oms metadata -service jobTypes -pluginId oracle.apps.ebs -file $OMS_HOME/plugins/oracle.apps.ebs.oms.plugin_13.1.1.1.0/metadata/jobTypes/ebscln_create_scripts.xml -sysman_pwd
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved.
EM-04041: Error occurred during Metadata registration. Error is: java.sql.SQLException: ORA-01489: result of string concatenation is too long
ORA-06512: at line 1960
. Check emctl.log for more details.
 


The issue can be reproduced at will with the following steps:
1. Change the <SYSMAN_PWD> in the below command and execute.
$OMS_HOME/bin/emctl register oms metadata -service jobTypes -pluginId oracle.apps.ebs -sysman_pwd <SYSMAN_PWD> -file $OMS_HOME/plugins/oracle.apps.ebs.oms.plugin_13.1.1.1.0/metadata/jobTypes/ebscln_create_scripts.xml

The issue has the following business impact:
Due to this issue, users cannot perform the post patch steps

Changes

Cause

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