Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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
Labels (3)
2 Replies
Anonymous
Not applicable

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

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?