2517020 - Live Profile / Import Extended User Information Error: ORA-01461

SAP Knowledge Base Article - Public

2517020 - Live Profile / Import Extended User Information Error: ORA-01461

Symptom

  • User getting an error when uploading via Admin Center > Import Extended User Information.
  • User getting an error when scheduled Live Profile Import fails.
  • Error message is: ORA-01461: can bind a LONG value only for insert into a LONG column.

Environment

  • SuccessFactors Employee Profile
  • SuccessFactors People Profile

Cause

The file has a text string that exceeds the database's max allowable size of 4000 bytes. For the English language, 4000 characters are allowed including formatting characters like space, tab, line break etc. For languages that support DBCS (double-byte character set), a character is equivalent to 2 bytes so less than 4000 characters are allowed. The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.

Resolution

See if the file has a cell that contains a text string that might exceed 4000 bytes. To check, you can use the Excel function LEN to count the number of characters and / or LENB to count the actual bytes.

See Also

See the Microsoft KBA for more information about LEN / LENB: https://support.office.com/en-us/article/LEN-LENB-functions-29236f94-cedc-429d-affd-b5e33d2c67cb

Keywords

KBA , LOD-SF-EP-JOB , Scheduled jobs , Problem

Product

SAP SuccessFactors HCM Core 1511 ; SAP SuccessFactors HCM Core 1602 ; SAP SuccessFactors HCM Core 1605 ; SAP SuccessFactors HCM Core 1608 ; SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors HCM Core 1702 ; SAP SuccessFactors HCM Core 1705 ; SAP SuccessFactors HCM Core 1708 ; SAP SuccessFactors HCM Core 1711 ; SuccessFactors HCM Core 1207 ; SuccessFactors HCM Core 1210 ; SuccessFactors HCM Core 1302 ; SuccessFactors HCM Core 1305 ; SuccessFactors HCM Core 1308 ; SuccessFactors HCM Core 1311 ; SuccessFactors HCM Core 1402 ; SuccessFactors HCM Core 1405 ; SuccessFactors HCM Core 1408 ; SuccessFactors HCM Core 1411 ; SuccessFactors HCM Core 1502 ; SuccessFactors HCM Core 1505 ; SuccessFactors HCM Core 1508