My Oracle Support Banner

AWR Warehouse's Main Web Page Is Not Able To Show A List Of Database Targets. (Doc ID 2724519.1)

Last updated on NOVEMBER 14, 2020

Applies to:

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


AWR Warehouse's main web page is not able to show a list of DB targets. It says
"No Source Database are Added or View Access to none of the Source Database is enabled"

But at the same time that visible through emcli utility.

emoms.trc in DEBUG mode shows:

2020-07-12 00:21:16,545 [[ACTIVE] ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR da.EmResolutionDao logp.251 - Could not start refreshing patch resolution requests, Mos Session is not available.
2020-07-12 01:30:47,431 [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR applicationModule.DbAwrSourceDatabaseList logp.251 - EMDB-00703: Exception populating source databases
java.lang.NumberFormatException: For input string: "0.15"
at java.lang.Integer.parseInt(


Retention period was changed via emcli using  decimal number. For instance 

emcli awrwh_reconfigure -retention="0.75 YEARS" AWR Warehouse reconfigured successfully


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.