OBIEE Dashboards On Exalytics Fail With Error:" [nQSError: 16002] Cannot obtain number of columns for the query result... " If Running TimesTen Aggregate Refresh Simultaneously
Last updated on JANUARY 01, 2018
Applies to:Exalytics In-Memory Machine X2-4 - Version All Versions and later
Business Intelligence Server Enterprise Edition - Version 188.8.131.52.1 to 184.108.40.206.1 [Release 11g]
Oracle TimesTen In-Memory Database - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
An Exalytics server environment includes TimesTen 18.104.22.168+ and Oracle Business Intelligence Enterprise Edition (OBIEE) 22.214.171.124.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:
View Display Error
Odbc driver returned an error (SQLExecDirectW).
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 126.96.36.199.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
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