My Oracle Support Banner

EM 13c: Update OMS property value fail with error "EMS-06017: An error occurred while getting the property name -9,999 for the OMS with ID = {1}, because the SQL execution failed for the property" (Doc ID 2680659.1)

Last updated on JUNE 15, 2020

Applies to:

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

Symptoms

Update OMS property value in below command given error :

<OMS_HOME>/bin/emctl set property -name "oracle.sysman.core.omsAgentComm.ping.connectionService.connectDescriptor" -value "<CONNECTION DESCRIPTOR>"
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved.
SYSMAN password:
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA-06512: at "SYSMAN.EM_OMS_PROPERTIES", line 1018
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)
at oracle.sysman.emSDK.omsproperties.ManagePropertyInstance.getProperty(ManagePropertyInstance.java:145)
at oracle.sysman.core.common.omsproperties.OMSPropertyUtil.executeJavaValidators(OMSPropertyUtil.java:278)
at oracle.sysman.emSDK.omsproperties.ManagePropertyInstance.setProperty(ManagePropertyInstance.java:388)
at oracle.sysman.emctl.config.oms.OMSConfigProperties.main(OMSConfigProperties.java:395)
Could not set property oracle.sysman.core.omsAgentComm.ping.connectionService.connectDescriptor for oms All Management Servers. Error = EMS-06050:
The following error occurred while validating property value <CONNECTION_DESCRIPTOR> for the property name oracle.sysman.core.omsAgentComm.ping.connectionService.connectDescriptor:
Internal error : EMS-06017: An error occurred while getting the property name -9,999 for the OMS with ID = {1}, because the SQL execution failed for the property.

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.