Error: "ORA-01489: result of string concatenation is too long..."

(Doc ID 2278289.1)

Last updated on SEPTEMBER 10, 2017

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 15A to 15B [Release 15]
Information in this document applies to any platform.

Symptoms

When combining or concatenating long text fields (such as (1st Part) through (4th Part) columns), the following error is received in the analysis or report:

 

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

Error Details
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: 17001] Oracle Error code: 1489, message: ORA-01489: result of string concatenation is too long at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)

 

Examples of (1st Part) through (4th Part) fields:

Examples of formulas that could cause this error:

"Requisition Identification"."Description (Internal) (1st Part) (ML)" || "Requisition Identification"."Description (Internal) (2nd Part) (ML)" || "Requisition Identification"."Description (Internal) (3rd Part) (ML)" || "Requisition Identification"."Description (Internal) (4th Part) (ML)"
CONCAT("Requisition Identification"."Description (External) (1st Part) (ML)", "Requisition Identification"."Qualifications (External) (1st Part) (ML)")

  

NOTE:  This error can occur using similar columns in any subject area, including Recruiting, Recruiting (Legacy), and Performance Management.

 

Cause

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 hundreds of Community platforms