Fatal error when loading from a excel(xlsx) file to redshift table.

[Vinlogs]

Hi

I am loading an xlsx file into a redshift table, but I am seeing a fatal error and unable to load the data. Please help.

below is the run time error as seen in run console:

Exception in component tFileInputExcel_1
java.lang.NumberFormatException: Value out of range. Value:"42594" Radix:10
    at java.lang.Short.parseShort(Short.java:120)
    at java.lang.Short.parseShort(Short.java:144)
    at routines.system.ParserUtils.parseTo_short(ParserUtils.java:148)

[Anonymous]

Hi,

Java will not accept values to overflow. What does your input data look like? How did you set your data type in schema setting?

Best regards

Sabrina

[Vinlogs]

Hi Sabrina/ Talend Community,

I have attached a screenshot of how my input data looks like; Please look at the attachment, and I have set the data type according to the column data found in screenshot.

Input_Data_talend_community.JPG