Qlik Talend Data Integration: java.lang.NumberFormatException:Expected an int but was <number higher than 2147483647>

[Brian_Chan]

A Talend Data Integration job is throwing an Exception with "java.lang.NumberFormatException: Expected an int but was <number higher than 2147483647>"

Resolution

Please use another datatype such as long, float, double in your job.

Cause

The Java limitation for Integer is 2,147, 483, 647 (java.lang.Integer.MAX_VALUE, max allowed value)

Related Content

https://docs.oracle.com/javadb/10.5.1.1/ref/rrefsqlj10696.html

data-shaping-language-reference-guide

Environment

• Talend Studio 
• Talend Data Integration