Last updated on DECEMBER 04, 2014
Applies to:Oracle TimesTen In-Memory Database - Version 126.96.36.199.0 to 188.8.131.52.1 [Release 11.2]
Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.140114 and later
Business Intelligence Server Enterprise Edition - Version 220.127.116.11.140114 and later
Oracle Exalytics Software - Version 18.104.22.168.0 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 22.214.171.124.0 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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms