FMW Control is Slow, Targets are Down and Access to DMS Returns 500 Internal Server Error (Doc ID 2043042.1)

Last updated on JANUARY 15, 2017

Applies to:

Oracle Fusion Middleware - Version 11.1.1.7.0 to 11.1.1.7.0 [Release Oracle11g]
Enterprise Manager for Fusion Middleware - Version 11.1.1.7.0 to 11.1.1.7.0
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.9.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

You may be seeing FMWC EM console targets down or slow response times when accessing /em and navigating through FMW Control. You may attempt to access DMS to troubleshoot that issue, or you may be following the following guide to access DMS directly:

Fusion Middleware Performance and Tuning Guide
http://docs.oracle.com/cd/E28280_01/core.1111/e10108/dms.htm#ASPER293

and

5.4.1 Viewing Metrics Using the Spy Servlet
http://docs.oracle.com/cd/E28280_01/core.1111/e10108/dms.htm#ASPER301 

Either way you find this issue, the results are the same, when accessing DMS via http://yourserver.com:7001/dms you get the following error:

URL returns 500 Internal Server error

It has been confirmed that WLS, JDK, and FMW products are all installed in a certified manner between versions and all system requirements met. It is known for an unexpected JDK version or lack of system resources to cause similar issues.  In this case, a review of the "bi_server1.log" (with an OBIEE installation) provided the following error stack leading to an issue with the DMS component:

<Error> <HTTP> <hostname> <bi_server1> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <a20b44d6996c76ae:-aca9d0d:14ed02c0faa:-8000-00000000000fa77d> <1438894721671> <BEA-101020> <[ServletContext@1080164538[app:DMS Application module:dms.war path:/dms spec-version:2.5 version:11.1.1.1.0]] Servlet failed with Exception
java.lang.UnsupportedOperationException
       at java.util.AbstractMap$SimpleImmutableEntry.setValue(AbstractMap.java:726)
       at oracle.dms.table.SchemaSupport.clone(SchemaSupport.java:392)
       at oracle.dms.table.SchemaSupport.clone(SchemaSupport.java:426)
       at oracle.dms.table.TableSupport.copyFromNoRows(TableSupport.java:822)
       at oracle.dms.table.TableSupport._copyFrom(TableSupport.java:785)
       at oracle.dms.table.TableSupport.clone(TableSupport.java:731)

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