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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads