OBIEE 22.214.171.124.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 126.96.36.199.0 and later
Business Intelligence Suite Enterprise Edition - Version 188.8.131.52.0 and later
After upgrading OBIEE 184.108.40.206.140715 to 220.127.116.11.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 18.104.22.168.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 22.214.171.124.x 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