VARCHAR2(2000) data type in control file caused "Value Length Beyond The Column Length" error even the data is less in size (Doc ID 2295705.1)

Last updated on AUGUST 10, 2017

Applies to:

Siebel CRM - Version 8.1.1.14.9 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.14.9 [IP2014] version, EIM

Customer trying to load data from csv file to EIM table using sql loader and getting the following error "value length beyond the column length"

Customer column s_evt_act_x.X_CON_ITEM and eim_act_dtl.EXT_X_CON_ITEM are both VARCHAR2(2000).
And also, our value in csv file only about 200 length.
In fact, csv value's length < DB column's length. and error show us "value length beyond the column length".


ERROR
-----------------------
"value length beyond the column length"



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load data using sql loader from CSV to EIM table.
2. error shown as "value length beyond the column length"



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