Numeric overflow in conversion of value 2,533,788,120 to type INTEGER.

Four Stars

Numeric overflow in conversion of value 2,533,788,120 to type INTEGER.

 I have a Talend Job and data are being pulled by TJdbcInput and then using a tmap  this data is being captured as "Long" data type .
Then it is has to load via tJdbcOutput, but the job is failing because of below error:
Numeric overflow in conversion of value 2,533,788,120 to type INTEGER.: ABORT
In table i am using "BIGINT" data type in column  to store such data.
Please let me know how to fix this.
Thanks,
One Star

Re: Numeric overflow in conversion of value 2,533,788,120 to type INTEGER.

Have you confirmed that you are not using int datatype anywhere in the database or anywhere in the talend job?
Four Stars

Re: Numeric overflow in conversion of value 2,533,788,120 to type INTEGER.

Yes I am not using integer anywhere in the Database. I have double checked it