Talend / Redshift error : Tried to send an out-of-range integer as a 2-byte value: 120000

Caused by: java.io.IOException: Tried to send an out-of-range integer as a 2-byte value: 110000

if you are using tRedShiftOutput and loading data by batch of 10 000 , you might have this problem

[statistics] connecting to socket on port 3882
[statistics] connected
Exception in component tRedshiftOutput_1
org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)
at slinganalytics.dma_0_1.DMA.tFileInputDelimited_1Process(DMA.java:1493)
at slinganalytics.dma_0_1.DMA.runJobInTOS(DMA.java:2053)
at slinganalytics.dma_0_1.DMA.main(DMA.java:1919)
Caused by: java.io.IOException: Tried to send an out-of-range integer as a 2-byte value: 120000
at org.postgresql.core.PGStream.SendInteger2(PGStream.java:201)

Solution

 

Leave a Reply