My Oracle Support Banner

Oracle Taleo Enterprise Edition: Reporting Error: 'Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s)' (Doc ID 2324936.1)

Last updated on DECEMBER 07, 2023

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 17.0 and later
Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 to 12.2.1.4.0 [Release 12g]
Oracle Taleo Platform Cloud Service - Reporting and Analytics - Version 23C and later
Information in this document applies to any platform.

Symptoms

Problem Description:

When running an analysis, the following error is received:

Error

View Display Error
Odbc driver returned an error (SQLExecDirectW).

Error Details
Error Codes: OPR4ONWY:U9IM8TAX:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 59140. [nQSError: 59140] The evaluation of the index 46 expression on row count -1 failed. (HY000)

State: HY000. Code: 59001. [nQSError: 59001] Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s). (HY000)

 

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.