My Oracle Support Banner

EM 13c: OID Metric Collection in Enterprise Manager 13c Dloud Control Fails for OIDReplSupplierInfo And OIDreplicationServerRunningInstances (Doc ID 2528384.1)

Last updated on JUNE 21, 2019

Applies to:

Enterprise Manager for Fusion Middleware - Version 13.2.2.0.0 to 13.2.3.0.0 [Release 13.1]
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 13.2 Cloud Control
OID version            : 11.1.1.1.9
FMW Plugin version : 13.2.3

OID targets (oracle_ldap) are monitored in EM 13.2.

Errors are reported in the OMS and Agent logs for the following 2 metrics:
- OIDReplSupplierInfo
- OIDreplicationServerRunningInstances

From <OMS instance base>/gc_inst/em/EMGC_OMNS1/sysman/log/emoms_pbs.trc:


2018-11-21 08:04:45,610 [GCLoader[severity] - https://<Agent HOST NAME>:3872/emd/main/] ERROR gcloader.AlertsApi logp.251 - AlertsApi:load: Failed to insert sever
ity: java.sql.SQLException: ORA-20001: publish_metric_error Failed: (target guid =<target guid>)(metric guid = 6C85AE0B1EA6A8B9D9CDA936CBDE3F5B)(Col
l name = OIDReplSupplierInfo)(Event name = OIDReplSupplierInfo)(error_msg = oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: )ORA-20391: [EVEM_EVT_MS
G_NULL: :Event message is null or empty.]
ORA-06512: at "SYSMAN.EMD_MNTR", line 13924
ORA-06512: at "SYSMAN.METRIC_ERRORS_CUR_AND_DUPES", line 463
ORA-04088: error during execution of trigger 'SYSMAN.METRIC_ERRORS_CUR_AND_DUPES'
ORA-06512: at line 12
java.sql.SQLException: ORA-20001: publish_metric_error Failed: (target guid = <target guid>)(metric guid = 6C85AE0B1EA6A8B9D9CDA936CBDE3F5B)(Coll nam
e = OIDReplSupplierInfo)(Event name = OIDReplSupplierInfo)(error_msg = oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: )ORA-20391: [EVEM_EVT_MSG_NUL
L: :Event message is null or empty.]
ORA-06512: at "SYSMAN.EMD_MNTR", line 13924
ORA-06512: at "SYSMAN.METRIC_ERRORS_CUR_AND_DUPES", line 463
ORA-04088: error during execution of trigger 'SYSMAN.METRIC_ERRORS_CUR_AND_DUPES'
ORA-06512: at line 12
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
 

 
From <agent instance base>/agent_inst/sysman/log/gcagent_sdk.trc:
2018-11-20 03:06:55,245 [1818813:41E00A8D:GC.Executor.106 (oracle_ldap:/oid21_IDMDomain/oid_inst1/oid1:OIDReplSupplierInfo) (oracle_ldap:<target id>:OIDReplSupplierInfo:OIDReplSupplierInfo)] WARN - FetchletException thrown in IDMSQLFetchletWrapper :-
java.lang.NullPointerException
at oracle.sysman.emSDK.agent.sql.SqlConnection.processArray(SqlConnection.java:1315)
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteRefCursor(SqlConnection.java:1395)
at oracle.sysman.gcagent.addon.fetchlet.sqlfetchlet.SqlFetchlet.ExecuteStatement(SqlFetchlet.java:771)

Access agent metric browser and login with agent installed user.
Click on the target 'oid1' and click on the following 2 metrics.
Gives error as below:
oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException:
at
oracle.sysman.emas.fetchlets.idm.IDMSQLFetchletWrapper.logAndThrowAppropriateE
xception(IDMSQLFetchletWrapper.java:513)
at
oracle.sysman.emas.fetchlets.idm.IDMSQLFetchletWrapper.getOIDTablesData(IDMSQL
FetchletWrapper.java:476)
at
oracle.sysman.emas.fetchlets.idm.IDMSQLFetchletWrapper.getMetric(IDMSQLFetchle
tWrapper.java:190)
at
oracle.sysman.gcagent.target.interaction.execution.FetchletFactory.getMetric(F
etchletFactory.java:426)
 

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.