My Oracle Support Banner

OBIEE : Physical Query Throwing Error TT2611: Error converting date to character string because Of Invalid "Cast" Operation (Doc ID 2162625.1)

Last updated on APRIL 01, 2019

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 


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.