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

Last updated on DECEMBER 14, 2023

Applies to:

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

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