My Oracle Support Banner

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 APRIL 01, 2019

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.