Talend : tRedShiftRow error : Unable to interpret the update count in

One Star

Talend : tRedShiftRow error : Unable to interpret the update count in

Hi,
I am running an RedShift Insert query in Talend using tRedShiftRow component. 
Java Exception;tRedshiftRow_22;org.postgresql.util.PSQLException:Unable to interpret the update count in command completion tag: INSERT 0 2168439549.;1
I googled and found some documentation for this error : 
Outsourcer uses Java and in doing so, the INSERT statement uses the Statement Class and the executeUpdate method.  The executeUpdate is used for INSERT, UPDATE, or DELETE and returns the number of rows impacted by the statement as an int.  In Java, an “int” is defined with a maximum of 2,147,483,647.  This means if your SQL statement affects more than 2.1 Billion rows, then Java will throw an error. 
Has anyone error got this error? How to fix this is Talend? 
Thanks!
J
Moderator

Re: Talend : tRedShiftRow error : Unable to interpret the update count in

Hi,
Could you please show us your component setting screenshots which will be helpful for us to address your issue quickly?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Talend : tRedShiftRow error : Unable to interpret the update count in

tredshiftrow22 -> row24(Main) - >tredshiftrow23
tredshiftrow22 has an insert and update statement which may sometimes affect more than 2.1 Billion rows.
When that happens, the talend returns and error and fails with error " Unable to interpret the update count in command completion tag: INSERT 0 2233627970.;1 "
Is there a way to suppress this error in Talend?