URGENTT - fetched column value was truncated

[vbalacts]

Hi,
I have created a simple job which contains 2 OCI plugins and one Transformer. The job is very simple:

Populate the record from table A to Table B thro Transformer. I am using DataStage V4.2. I have tried to run the job but I have got the following error:

HistDelIwSoLine.DWDB_IW_SO_LINE: ORA-01406: fetched column value was truncated.

HistDelIwSoLine - Job name
DWDB_IW_SO_LINE - Source OCI Plugin

Even I have tried view the Data from source table thro OCI plugin, I have got the same error.

Can anyone help me on this???

The Explanation for that Error is:

ORA-01406 fetched column value was truncated

Cause: In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.

Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing.

Thanks
Bala