OEM 13c: Metric Data Load Errors "ORA-12899: value too large for column "SYSMAN"."MGMT_ECM_OS_REGISTERED_SW_E"."DATA_SOURCE" (actual: 34, maximum: 32)" Reported in the Logs
(Doc ID 3006268.1)
Last updated on FEBRUARY 23, 2024
Applies to:
Enterprise Manager Base Platform - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 13.5.0.0.0 version, Target Host
Metric Data Load Errors like "ORA-12899: value too large for column "SYSMAN"."MGMT_ECM_OS_REGISTERED_SW_E"."DATA_SOURCE" (actual: 34, maximum: 32)" Reported in the Logs
emoms_pbs.log shows errors like below
2022-03-02 12:36:52,164 [GCLoader[uploadondemand] - <DOMAIN_NAME>:1835/emd/main/] WARN load.MetricLoadErrors logp.251 - MetricLoadRowset.processMetricTableRows: [INSERT INTO MGMT_ECM_OS_REGISTERED_SW ("ID", "NAME", "VENDOR_NAME", "VERSION", "INSTALLATION_DATE", "INSTALLED_LOCATION", "DESCRIPTION", "VENDOR_SW_SPECIFIC_INFO", "VIRTUAL_MACHINE", "SOFTWARE_ARCHITECTURE", "PRODUCT_PARENT_ID", "PRODUCT_PARENT_NAME", "MEDIA_TYPE", "DATA_SOURCE", "ECM_SNAPSHOT_ID") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, hextoraw(?))] : [ORA-12899][ORA-12899: value too large for column "SYSMAN"."MGMT_ECM_OS_REGISTERED_SW_E"."DATA_SOURCE" (actual: 34, maximum: 32)
]: [oracle_si_host_remote : <DOMAIN_NAME> : [MetricGroupName : ECM_OS_REGISTERED_SW : MetricGroupId = 4796]][oracle_si_host_remote : <DOMAIN_NAME> : [MetricGroupName : ECM_OS_REGISTERED_SW : MetricGroupId = 4796]]
java.sql.SQLException: ORA-12899: value too large for column "SYSMAN"."MGMT_ECM_OS_REGISTERED_SW_E"."DATA_SOURCE" (actual: 34, maximum: 32)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:266)
2022-03-02 12:36:52,164 [GCLoader[uploadondemand] - <DOMAIN_NAME>:1835/emd/main/] WARN load.MetricLoadErrors logp.251 - MetricLoadRowset.processMetricTableRows: [INSERT INTO MGMT_ECM_OS_REGISTERED_SW ("ID", "NAME", "VENDOR_NAME", "VERSION", "INSTALLATION_DATE", "INSTALLED_LOCATION", "DESCRIPTION", "VENDOR_SW_SPECIFIC_INFO", "VIRTUAL_MACHINE", "SOFTWARE_ARCHITECTURE", "PRODUCT_PARENT_ID", "PRODUCT_PARENT_NAME", "MEDIA_TYPE", "DATA_SOURCE", "ECM_SNAPSHOT_ID") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, hextoraw(?))] : [ORA-12899][ORA-12899: value too large for column "SYSMAN"."MGMT_ECM_OS_REGISTERED_SW_E"."DATA_SOURCE" (actual: 34, maximum: 32)
]: [oracle_si_host_remote : <DOMAIN_NAME> : [MetricGroupName : ECM_OS_REGISTERED_SW : MetricGroupId = 4796]][oracle_si_host_remote : <DOMAIN_NAME> : [MetricGroupName : ECM_OS_REGISTERED_SW : MetricGroupId = 4796]]
java.sql.SQLException: ORA-12899: value too large for column "SYSMAN"."MGMT_ECM_OS_REGISTERED_SW_E"."DATA_SOURCE" (actual: 34, maximum: 32)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:266)
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |