OBIEE : Physical Query Throwing Error TT2611: Error converting date to character string because Of Invalid "Cast" Operation

(Doc ID 2162625.1)

Last updated on AUGUST 30, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Business Intelligence Suite Enterprise Edition - Version and later
All Platforms


After upgrading OBIEE to and your query is running against Times Ten Database and see the following error:


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: 22008 code: 2611 message: [TimesTen][TimesTen ODBC Driver][TimesTen]TT2611: Error converting date to character string -- file "eeInst.c", lineno 21431, procedure "sbEeExecFull". [nQSError: 16011] ODBC error occurred while executing SQLExtendedFetch to retrieve the results of a SQL statement. (HY000)

There is difference in the Physical query generated when compared with the previous version version 


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