EM 13c: Internal/Unexpected Error When Accessing Database' SQL Performance Analyzer (SPA) Home Page
(Doc ID 2893135.1)
Last updated on NOVEMBER 30, 2022
Applies to:
Enterprise Manager for Oracle Database - Version 13.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager Cloud Console, trying to access 'SQL Performance Analyzer (SPA)' home page of databases is resulting in 'Internal Error Occurred' or 'Unexpected Error Occured'.
- Login to Enterprise Manager Console.
- Open the database home page
- Navigate to 'Performance > SQL > SQL Performance Analyzer Home.
$ <EM_INSTANCE_BASE>/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log or emoms.trc
2022-07-21 08:08:19,952 [EMUI_08_08_19_/console/database/instance/SPIASummary] ERROR perf.spia logp.251 - EMSPA:SPIASummaryController onDoLoad error encountered determining RAT testing option,error:When navigating to a target home page, 'target' is required to be present in properties Map but not found.,exception
java.lang.IllegalArgumentException: When navigating to a target home page, 'target' is required to be present in properties Map but not found.
at oracle.sysman.core.navigation.TargetURLGenerator.getURL(TargetURLGenerator.java:174)
at oracle.sysman.emSDK.intg.IntegrationManager.getTargetHomepageURL(IntegrationManager.java:824)
at oracle.sysman.db.adm.LinkingUtil.getHomepageURL(LinkingUtil.java:314)
at oracle.sysman.db.adm.inst.SPIASummaryController.getUrlForNoRATSupport(SPIASummaryController.java:259)
at oracle.sysman.db.adm.inst.SPIASummaryController.onDoLoad(SPIASummaryController.java:218)
java.lang.IllegalArgumentException: When navigating to a target home page, 'target' is required to be present in properties Map but not found.
at oracle.sysman.core.navigation.TargetURLGenerator.getURL(TargetURLGenerator.java:174)
at oracle.sysman.emSDK.intg.IntegrationManager.getTargetHomepageURL(IntegrationManager.java:824)
at oracle.sysman.db.adm.LinkingUtil.getHomepageURL(LinkingUtil.java:314)
at oracle.sysman.db.adm.inst.SPIASummaryController.getUrlForNoRATSupport(SPIASummaryController.java:259)
at oracle.sysman.db.adm.inst.SPIASummaryController.onDoLoad(SPIASummaryController.java:218)
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 |