OBIEE Dashboards On Exalytics Fail With Error:" [nQSError: 16002] Cannot obtain number of columns for the query result... " If Running TimesTen Aggregate Refresh Simultaneously (Doc ID 1622891.1)

Last updated on SEPTEMBER 25, 2015

Applies to:

Exalytics In-Memory Machine X2-4 - Version All Versions and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 to 11.1.1.7.1 [Release 11g]
Oracle TimesTen In-Memory Database - Version 11.2.2.5.0 and later
Information in this document applies to any platform.

Symptoms

An Exalytics server environment includes TimesTen 11.2.2.5+ and Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.1.  If the OBIEE Administrator is running TimesTen Aggregate refresh via the NQCMD command, and system users try to access certain OBIEE dashboards and reports at the same time, the following errors are encountered:

Error
  View Display Error
 
Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: S0002 code: 2206 message: [TimesTen][TimesTen 11.2.2.5.0 ODBC Driver][TimesTen]TT2206: Table TTEXALYTICS.SA_DETAIL00035407 not found -- file "comp.c", lineno 2852, procedure "sbCompCacheTbl()". [nQSError: 16002] Cannot obtain number of columns for the query result. (HY000)
SQL Issued: SET VARIABLE Org_Type='PRIMARY';SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7, s_8, s_9, s_10, s_11, s_12, s_13, s_14, s_15, s_16, s_17, s_18, s_19, s_20, s_21, s_22, s_23, s_24, s_25

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