Value out of range. Value:"297599" Radix:10

[veryimportantdude]

Hello
I am getting this error Value out of range. Value:"297599" Radix:10 trying to transfer data from input positional file to postgres database
I am tranfering 10 rows but with 5 of them I am getting that error
other rows have only 0 in that field and are transfered ok
Any suggestions?
thank you

[Anonymous]

Sounds like a datatype error. What datatypes are the input and output field?

[Tasfiahm]

Hi,

I know I am answering it 7 years letter. It is a data type issue in the input or the output schema. 

For Example: Person_ID is a Integer data type but by mistake you are transforming it to SHORT data type,

so it will process all the data where the value is "32772" something more than that it will though the error.

So anyone is having the issue at the middle of the job please check the datatype for trouble shooting.

Thanks,

Tasfi