EM 12c: Accessing JVM Metrics in Enterprise Manager 12c Cloud Control Fails with Error: JBO-29000: Unexpected Exception Caught: Java.sql.SQLException, Msg=ORA-20206: Target Does Not Exist (Doc ID 2013055.1)

Last updated on JUNE 29, 2017

Applies to:

Enterprise Manager for Fusion Middleware - Version 11.1.1.6.0 and later
Enterprise Manager Base Platform - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

Some of the metrics for WebLogic Server (WLS) targets in Enterprise Manager (EM) 12.1.0.3 Cloud Control show different errors like:

Error 1
Accessing target “/test_domain/test_domain/test_AUX” (for example), Monitoring -> All Metrics: for example: JVM Metrics -> Heap Usage, it displays the error:

"JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-20206: Target does not exist: :
ORA-06512: at "SYSMAN.MGMT_TARGET", line 1228
ORA-06512: at "SYSMAN.EM_MONITORING", line 62
ORA-06512: at line 1
JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-20206: Target does not exist: :
ORA-06512: at "SYSMAN.MGMT_TARGET", line 1228
ORA-06512: at "SYSMAN.EM_MONITORING", line 62
ORA-06512: at line 1"


In other metrics, it gives the following errors.

After the error above if you click other metrics , it gives 2 more differents errors.

Error 2:

"ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #98"


Error 3:

"Error retrieving information from database. Exception: ORA-01878: specified field not found in datetime or interval
java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval
oracle.sysman.emSDK.app.exception.EMSystemException"

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms