OBIEE 11.1.1.9.x : 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 11.1.1.9.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and later
All Platforms

Symptoms

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

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: 22008 code: 2611 message: [TimesTen][TimesTen 11.2.2.7.8 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 11.1.1.7.x version 

Cause

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