OBIEE 11g: NQserver Crashes and Restarts After Upgrading to OBIEE 11.1.1.9.0 from 11.1.1.7.140415 (Doc ID 2060045.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.140415 to 11.1.1.9.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

Upgraded to OBIEE 11.1.1.9.0 from 11.1.1.7.140415.

When attempting to actively use OBIEE and run a query, the nqserver crashes and restarts.

The error seen in the Opmn.log is:

ERROR
-----------------------
[opmn] [WARNING:1] [660] [pm-process] Process Crashed:
coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1
(1477082094:825) - Restarting

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. While actively using OBIEE and running a query, the server crashes.
2. It eventually restarts on its own and OBIEE can be used again.
3. Reviewing the logs, you'll see that the NQQuery.log truncates, indicating a memory violation was prior to the query execution. 

Changes

 Upgraded to 11.1.1.9.0 from 11.1.1.7.140415

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