My Oracle Support Banner

EM 13.5C: Metric 'privX_cdb' And 'privX' Collection For Container Database And Pluggable Database Fails With An Error 'Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS, for privX_cdb' (Doc ID 3069432.1)

Last updated on JANUARY 29, 2025

Applies to:

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

Symptoms

After enabling the metric collection 'oracle_security_cdb' for container databases, sub metric 'privX_cdb' for oracle_database and 'privX' for oracle_pdb collection failing with below error.

<AGENT_HOME>/bin/emctl control agent runCollection <TARGET_NAME>:oracle_database oracle_security_cdb
Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection error:
oracle_security_cdb:privX_cdb:Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS,


<AGENT_HOME>/bin/emctl getmetric agent <TARGET_NAME>,oracle_database,privX_cdb
Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
EMD getmetric error: Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS,

Error stack from agent log showing : <AGENT_INST>/sysman/log/gcagent.log

oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS,
2024-12-13 14:41:33,822 [40661:F78F4A9C:GC.Executor.37369 (oracle_database:TARGET_NAME:oracle_security_cdb) (oracle_database:TARGET_NAME:oracle_security_cdb:privX_cdb)] WARN - In ResponseHandler.reportError, see Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS, for privX_cdb

oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS,
2024-12-13 14:41:34,091 [40666:177CD454:GC.Executor.37374 (oracle_pdb:TARGET_NAME:oracle_security) (oracle_pdb:TARGET_NAME:oracle_security:privX)] WARN - In ResponseHandler.reportError, see Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS, for privX_cdb

oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS,
2024-12-13 14:41:34,091 [40666:177CD454] WARN - In ResponseHandler.reportError, see Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS, for privX

oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS,
2024-12-13 14:41:34,091 [40667:8A98DD75:GC.Executor.37375 (oracle_pdb:TARGET_NAME:oracle_security) (oracle_pdb:TARGET_NAME:oracle_security:privX)] WARN - In ResponseHandler.reportError, see Result has repeating key value : xview,X_$KSPPI->C##QUALYS_ROLE->SYS,SYS, for privX

 

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.