topic Fatal error when loading from a excel(xlsx) file to redshift table. in Talend Studio

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

Vinlogs — Thu, 28 Sep 2017 20:17:43 GMT

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)

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

Anonymous — Fri, 29 Sep 2017 04:30:19 GMT

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

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

Vinlogs — Fri, 29 Sep 2017 14:33:39 GMT

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