Metric Extension Error: Unsupport Oracle Data Type (Doc ID 2213210.1)

Last updated on DECEMBER 13, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 13.1.1.0.0 and later
Information in this document applies to any platform.

Symptoms

The following error is received while testing an SQL Metric Extension: "Failed to get test Metric Extension metric result.: Unsupport Oracle Data Type [NVARCHAR2] for selected column [SQL_TEXT]"

The gcagent.log file is showing:

ERROR
-----------------------
2016-11-22 19:48:08,539 [344:GC.Executor.5 (oracle_database:target_name:ME$metric_name) (oracle_database:target_name:ME$metric_name:ME$metric_name)] ERROR - oracle_database:target_name:ME$metric_name:ME$metric_name
java.lang.IllegalArgumentException: Unsupport Oracle Data Type [NVARCHAR2] for selected column [SQL_TEXT]

Changes

The error was raised after upgrade to 13c.

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