My Oracle Support Banner

Exalytics: OBIEE 11g Reports Based on TimesTen Data Source Fail with Assertion Error 'sbOpGetColInfo()' (Doc ID 1903440.1)

Last updated on APRIL 02, 2024

Applies to:

Oracle TimesTen In-Memory Database - Version to [Release 11.2]
Business Intelligence Suite Enterprise Edition - Version and later
Business Intelligence Server Enterprise Edition - Version and later
Oracle Exalytics Software - Version and later
Information in this document applies to any platform.


OBIEE reports that are migrated from OBIEE environment using Oracle database as source to OBIEE on Exalytics using TimesTen In-Memory Database fail with Assertion Error.
The physical query generated runs successfully on Oracle database, but throws the following error on Timesten database on Exalytics:

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: S1000 code: 4053 message: [TimesTen][TimesTen ODBC Driver][TimesTen]TT4053: Assertion Failure:<res != 0> Additional info:<> -- file "optimize.c", lineno 2485, procedure "sbOpGetColInfo()". [nQSError: 16014] SQL statement preparation failed. (HY000)

Screenshot of the error:

The sub-query itself runs on Timesten database without errors but the entire query fails when run from SQL Developer also.


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.