OCI has fetched truncated data

[amitendra_amit]

Hi,

One of our job is throwing waring with message
"OCI has fetched truncated data".

Any idea why this error is coming.

Cheers

[DS_SUPPORT]

Do a Search, You can find So many posts for answering this. One possible solution Your Job metada wont be matching with ur oracle table structure.

Try to identify the column which throws this error and increase the size of that column in the job.

[DSguru2B]

Thats a nasty OCI API error as it retrieves a field that requires to be defined differently in DS. The annoying part is, its trial and error. ie, you have to try changing the sql type and the length. Good luck.

[ray.wurlod]

If you have Enterprise Edition with parallel jobs licensed you can use the orchdbutil utility to import table definitions accurately.

[chulett]

Any idea why this error is coming.

No not really, not with so little information SunShine.

However, we can make some guesses. What kind of fields are in your source table(s)? Anything fun like a CLOB? If not a CLOB are there any NUMBER fields defined? Not NUMBER(xx) but just NUMBER... those are the two primary suspects when you see this error.

[praburaj]

Thanks all. I solved my problem :D

[chulett]

Funny, but you're not the person with the problem. Still, what was your solution? We try to be all about sharing solutions, ya know.