My Oracle Support Banner

OBIEE 12c: OBIS Component Process (nqsserver) Crashes When Using a Shared Query (Doc ID 2673235.1)

Last updated on MAY 28, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and later
Oracle Solaris on SPARC (64-bit)

Symptoms

You have created an analysis and on the Advanced tab, in the Query Performance section you have checked the "Share query with multiple users" options.

When you try to display the results of the analysis the following error is displayed:

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:OI2DL65P
State: 08004. Code: 10092. [NQODBC] [SQLSTATE] [nQSError: 10092] The Oracle BI Server is not currently running. (08004)
State: 08004. Code: 10092. [NQODBC] [SQLSTATE] [nQSError: 10092] The Oracle BI Server is not currently running. Cannot connect to server machine (08004)

In <DOMAIN_HOME>/nodemanager/nodemanager.log you see:

<timestamp> <INFO> <domain_name> <obis1> <The server 'obis1' with process id <pid> is no longer alive; waiting for the process to die.>
<timestamp> <INFO> <domain_name> <obis1> <Server failed so attempting to restart (restart count = n)>
<timestamp> <INFO> <domain_name> <obis1> <The server 'obis1' is running now.>

And in <DOMAIN_HOME>/servers/obis1/logs/obis1.out :

================================================================
Beginning of crash dump...
Signal: 11
================================================================
START:Activities Task for Thread: <thread>
Activity #1 ECID: <ecid>
================================================================
Activity type: Execute Query
Repository Name: ssi
Catalog: <subject area>
Tenant:
Tenant ID: <service instance name>
Service Name:
User: <username>
Session ID: <session_id>
Request ID: <request_id>
ProcedureID: <procedure_id>
Logical SQL:{call SAGetSharedRequestKey('<...Logical SQL...>')}

This only happens in Oracle Solaris, not on Linux or Windows.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.