My Oracle Support Banner

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

Last updated on DECEMBER 14, 2023

Applies to:

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


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:

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 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.




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

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