Oracle Taleo Enterprise Edition: Error: 'Error getting drill information'
(Doc ID 2202654.1)
Last updated on AUGUST 19, 2022
Applies to:
Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 21A and laterInformation in this document applies to any platform.
Symptoms
Problem Description:
When running a report/analysis that uses custom SQL for a filter through one of the following methods, the below error occurs:
- Under Add More Options > SQL Expression
- By checking the box to Convert this filter to SQL
- Inserting custom SQL through the Advanced tab
Error
View Display Error
Error getting drill information: {Query Logical SQL}
Error Details
Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
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: 27002. [nQSError: 27002] Near {invalid SQL}: Syntax Error. (HY000)
State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (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 |