Login to Discoverer Viewer or Plus may sometimes take several minutes (Doc ID 2024696.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.1.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

+ Login to Discoverer Viewer or Plus may sometimes take several minutes regardless of which browser is used.
This delay has particularly been seen when connecting to APPS or EBS end user layers.

Please note that the solution is not applicable to standalone Discoverer environment.

The following message is displayed during the login:
Request Progress
Processing your request
The page you have requested is taking some time to process. Please wait...

The Discoverer application itself is fast after logging in.

Then, after exiting or cancelling the application (without closing the browser), it is noticed that subsequent logins take just seconds.
If the browser is closed and a new browser session is opened, then the login to Discoverer is slow again and takes several minutes again.

 

+ Sometimes the login delay will even cause a timeout exception and gives following error in the front-end:

The application encounters an invalid state..
- Connection timed out - Nested exception: org.omg.CORBA.COMM_FAILURE: Connection timed out vmcid: 0x0 minor code: 0 completed: No
- Connection timed out
Oracle BI Discoverer Viewer cannot find the data necessary to display the results of ths event.
Correct any errors, and try again

The WLS_DISCO-diagnostic.log shows an exception like the following:
[<date><time>] [WLS_DISCO] [ERROR] [] [ORACLE.DISCOVERER.VIEWER] [tid: Discoverer Viewer BG Worker 0] [userId: <anonymous>] [ecid: 0000Ku74MVR6ESG6yzbe6G1Lctbg000001,0] [APP: discoverer#11.1.1.2.0] error.invalid.state[[
oracle.discoverer.applications.framework.ApplicationException: error.invalid.state
       at oracle.discoverer.applications.framework.RequestProcessor.execute(Unknown Source)
       at oracle.discoverer.applications.framework.WorkerThread.run(Unknown Source)
       at java.lang.Thread.run(Thread.java:767)
Caused by: oracle.discoiv.direct.DiscovererDirectException: Connection timed out - Nested exception: org.omg.CORBA.COMM_FAILURE: Connection timed out  vmcid: 0x0  minor code: 0  completed: No

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