Discoverer Login Errors With: ORA-00096: Invalid Value True For Parameter Query_Rewrite_Enabled (Doc ID 369417.1)

Last updated on FEBRUARY 18, 2016

Applies to:

Oracle Discoverer - Version 10.1.2.1 to 10.1.2.3 [Release 10.1.2]
Information in this document applies to any platform.
***Checked for relevance on 04-Oct-2012***


Symptoms

Logging into Discoverer Viewer or Plus or even clicking on 'analyze' link in the Discoverer Portlet results in error:

Component Discoverer
Message Type Error
Module ID DCS
Host Name 2006053509564611495
Message Level 1

Message Text:

DCCORBAExceptionDCSModelInterface::SendReceiveData(kConnectionInterface)
failed.DCCORBAException {
mErrorCode = kNoMessage
mReason = Database Error - ORA-00096: invalid value TRUE for
parameter query_rewrite_enabled, must be from among stale_tolerated,
trusted, enforced
0xffbfe02c
mAdditionalInfo = 0x970ca8
mEncodedInfo = DCITable
Length=0

Supplemental Text:

<MSG_GROUP>EXC </MSG_GROUP> <PROCESS_ID>14495</PROCESS_ID>
<FILE_NAME>dcsmdli.cpp</FILE_NAME> <LINE_NUMBER>258</LINE_NUMBER>
<THREAD_ID>1</THREAD_ID>

error_log contains:

[Fri May 5 12:59:31 2006] [warn] [client 10.25.96.161] [ecid:
1146851971:10.25.96.161:11185:0:1,0] MOD_OC4J_0184: Failed to find an oc4j process for
destination: OC4J_BI_Forms
[Fri May 5 12:59:31 2006] [error] [client 10.25.96.161] [ecid:
1146851971:10.25.96.161:11185:0:1,0] MOD_OC4J_0145: There is no oc4j process (for destination:
OC4J_BI_Forms) available to service request.
[Fri May 5 12:59:31 2006] [error] [client 10.25.96.161] [ecid:
1146851971:10.25.96.161:11185:0:1,0] MOD_OC4J_0119: Failed to get an oc4j process for destination:
OC4J_BI_Forms
[Fri May 5 12:59:31 2006] [error] [client 10.25.96.161] [ecid:
1146851971:10.25.96.161:11185:0:1,0] MOD_OC4J_0013: Failed to call destination: OC4J_BI_Forms's
service() to service the request.
[Fri May 5 12:59:31 2006] [warn] long lost child came home! (pid 11076)

$OH/j2ee/OC4J_BI_Forms/application-deployments/discoverer/OC4J_BI_Forms_default_island_1/application.log contains:

discoverer: [ERROR] [Discoverer Viewer BG Worker 8]
oracle.discoverer.applications.framework.ApplicationController._logException
error.needs.password.failed
oracle.discoverer.applications.viewer.model.ConnectionException: error.needs.password.failed
at oracle.discoverer.applications.viewer.model.ConnectionStore.needsPassword(Unknown Source)
at oracle.discoverer.applications.viewer.model.SavedConnection.needsPassword(Unknown Source)
at oracle.discoverer.applications.viewer.model.SavedConnection.<init>(Unknown Source)
at oracle.discoverer.applications.viewer.model.ConnectionFactory.getConnection(Unknown Source)
at
oracle.discoverer.applications.viewer.controllers.PortalController.handleApiPortalOpen(Unknown
Source)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
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.WorkerThread.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: oracle.discoiv.beans.AuthenticationException: Database Error - ORA-00096: invalid value
TRUE for parameter query_rewrite_enabled, must be from among stale_tolerated, trusted, enforced
at oracle.discoiv.beans.proxy.server.DiscovererServer$ConnectionErrorChecker.check(DiscovererServer.jav
a:861)
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

Changes

INIT<sid>.ora parameters were modified on one of the databases.

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