Contact With Backend Server Lost, OracleBI Discoverer Viewer Was Unable To Find The Necessary Data For Displaying The Results Of This Event. (Doc ID 412905.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Discoverer - Version 10.1.2.0.2 to 10.1.2.3 [Release 10.1.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Dec-2015***

Symptoms

An error message is displayed when opening a Discoverer workbook (Viewer or Plus) from the E-Business Suite homepage:


"An error has occurred while handling the event.See application log for more details.
OracleBI Discoverer Viewer was unable to find the necessary data for
displaying the results of this event. Please correct any errors and try again."

OR

"The application encountered an invalid state. Contact with backend server lost OracleBI Discoverer Viewer was unable to find the necessary data for displaying the results of this event. Please correct any errors and try again."

 

< $OH>/j2ee/OC4J_BI_Forms/application-deployments/discoverer/OC4J_BI_Forms_default_island_1/application.log has the following errors:

07/01/26 13:36:36 discoverer: [ERROR] [Thread-527] oracle.discoverer.applications.framework.ApplicationController._logException error.connection.failed
oracle.discoverer.applications.viewer.controllers.ControllerException: error.connection.failed
at oracle.discoverer.applications.viewer.controllers.APIController.handleApiConnectOpenAndHTMEExport(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.discoverer.applications.framework.RequestProcessor.execute(Unknown Source)
at oracle.discoverer.applications.framework.AsyncRequestProcessor.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: oracle.discoverer.applications.viewer.model.ConnectionException: error.setup.connection
at oracle.discoverer.applications.viewer.model.RelationalConnection.connect(Unknown Source)
at oracle.discoverer.applications.viewer.model.DirectConnection.connect(Unknown Source)
... 8 more
Caused by: oracle.discoiv.beans.RoleException: You have not specified a valid responsibility for your username (on the command line or in the connect string).
at oracle.discoiv.beans.proxy.server.DiscovererServer$ConnectionErrorChecker.check(DiscovererServer.java:864)
at oracle.discoiv.beans.proxy.server.DiscovererServer.assessErrors(DiscovererServer.java:740)
at oracle.discoiv.beans.proxy.server.DiscovererServer.findConnectionErrors(DiscovererServer.java:793)
at oracle.discoiv.beans.proxy.server.DiscovererServer.findErrors(DiscovererServer.java:696)
at oracle.discoiv.beans.proxy.server.DiscovererServer.loadDocument(DiscovererServer.java:617)
at oracle.discoiv.beans.proxy.server.DiscovererServer.getDocument(DiscovererServer.java:194)
at oracle.discoiv.beans.proxy.XMLProxy.getElement(XMLProxy.java:178)
at oracle.discoiv.beans.proxy.XMLProxy.connect(XMLProxy.java:327)
at oracle.discoiv.beans.proxy.ConnectionStoreProxy.connect(ConnectionStoreProxy.java:495)
at oracle.discoiv.beans.ConnectionStore.connect(ConnectionStore.java:352)
... 10 more

Changes

Using Discoverer with E-Business Suite running on a RAC database.

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