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

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

_AnonymousUser — Tue, 26 Apr 2016 15:26:55 GMT

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

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

Anonymous — Fri, 29 Apr 2016 08:46:28 GMT

Hi,
Could you please show us your component setting screenshots which will be helpful for us to address your issue quickly?
Best regards
Sabrina

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

_AnonymousUser — Tue, 10 May 2016 19:09:04 GMT

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?