EM 13.5C: 'Database Scheduler Job' Metric Collection For CDBROOT Target Fail With Error "Result has repeating key value"
(Doc ID 2991728.1)
Last updated on DECEMBER 07, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 13.5.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
'Database Scheduler Job' Metric Collection For CDBROOT Target Fail With Error "Result has repeating key value" as below :
<AGENT_HOME>/bin/emctl control agent runCollection CDBROOT:oracle_pdb pdb_jobs_status_related
Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection error:
pdb_jobs_status_related:pdb_raw_job_stats:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
pdb_raw_job_stats:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
pdb_failed_jobs:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
pdb_raw_job_stats:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
pdb_running_jobs:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
pdb_raw_job_stats:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
pdb_job_state_flags:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
pdb_failed_jobs:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
pdb_dbms_scheduler_jobs:Result has repeating key value : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
<AGENT_HOME>/bin/emctl getmetric agent san.us.oracle.com_CDBROOT,oracle_pdb,pdb_raw_job_stats
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 : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
<AGENT_HOME>/bin/emctl getmetric agent CDBROOT,oracle_pdb,pdb_raw_job_stats
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 : SYS,XMLDB_NFS_CLEANUP_JOB,,STATE_FLAG
<AGENT_HOME>/bin/emctl getmetric agent CDBROOT,oracle_pdb,pdb_job_state_flags
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 : SYSXMLDB_NFS_CLEANUP_JOB
<AGENT_HOME>/bin/emctl getmetric agent CDBROOT,oracle_pdb,pdb_dbms_scheduler_jobs
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 : SYS,XMLDB_NFS_CLEANUP_JOB
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 |