My Oracle Support Banner

"OPR4ONWY:U9IM8TAC:OI2DL65P" Error Is Displayed When Selecting "All Column Values" In FTI Dashboard (Doc ID 1639943.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.3.3 and later
Information in this document applies to any platform.


When opening up the FTI dashboard in 6.3.3, results are returned. But when we change the year from 2014 to "All Column Values" we get 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: 59001 Binary Logical operation is not permitted on VARBINARY, DOUBLE PRECISION operand(s). (HY000).

The issue can be reproduced at will with the following steps:
Login to the FTI dashboard.
Change the year from 2014 to "All Column Values" and hit apply.


To view full details, 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 a vibrant support community of peers and Oracle experts.