DSXchange

Hi all,
I have manycolumns around 200 columns imorted from the database and while running the job i get the following error
inserted value too large for a columns,row rejected

How can i know which column value is too large..??

I believe you will have to spot check. i bet your database is Oracle. Right... ? This has been discussed here before and i believe that spot check is the only way to tell.

All the column values that you tried to insert are given in the logged error message. You can inspect that to determine which of them is too large.

Not with Oracle Ray. Thats why its a pain to find what column is the culprit. It becomes more and more annoying if there are hundreds of columns.