IDENT1: OCI has fetched truncated data

marco.mir · Post by **marco.mir** » Mon Oct 31, 2011 6:30 am

Hello,

I have an issue with a server job always working until now.

I have warning IDENT1: OCI has fetched truncated data.

I made a job with Oracle stage and Sequential File. Oracle table definition in reading is the same of Sequential file.

May someone help me?

Thanks in advance.

chulett · Post by **chulett** » Mon Oct 31, 2011 7:26 am

IDENT1 is the 'invisible' transformer between your passive stages. One of your fields has grown large enough to be truncated, it would seem. Any CLOB or unbound NUMBER fields in the source?

marco.mir · Post by **marco.mir** » Mon Oct 31, 2011 9:00 am

There are char, varchar, decimal and timestamp fields in source.

My doubt is: when my job loads this table, nothing happens. In reading it, just as select * from table, I have this problem.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 31, 2011 11:47 am

Do all the VARCHAR fields have Precision set? Do all the VARCHAR fields have Precision set large enough for the data?

marco.mir · Post by **marco.mir** » Fri Nov 04, 2011 7:32 am

I think that I solved. It was a problem of not good data.

Thanks.

chulett · Post by **chulett** » Fri Nov 04, 2011 8:51 am

What kind of not good data?