Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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,
Labels (3)
2 Replies
Anonymous
Not applicable
Author

Have you confirmed that you are not using int datatype anywhere in the database or anywhere in the talend job?
Anonymous
Not applicable
Author

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