tELTNetezzaMap - Additional JDBC parameters

Anonymous — Fri, 15 Mar 2019 10:57:38 GMT

Hi,

I have a simple ELT job which reads data from netezza table using tELTNetezzaInput followed by tELTNetezzaMap that nulls few fields linked to tELTNetezzaOutput which does insert into a new table.

The Input table has around 3.5 Billions rows and all the rows are inserted to the target table. However the job ends with error message -

"tELTNetezzaOutput_1 The update count exceeded Integer.MAX_VALUE.
org.netezza.error.NzSQLException: The update count exceeded Integer.MAX_VALUE."

I tried adding "ignoreUpdateCount=True" in tELTNetezzaMap Additional JDBC parameters and checked the code. There were NO changes in the connection parameters.

Also tried modifing the connection in the Metadata but the Metadata connection string is not getting updated. Thought of pulling the connection from Metadata.

How to resolve this?

Thanks.

Re: tELTNetezzaMap - Additional JDBC parameters

Anonymous — Thu, 04 Apr 2019 05:19:15 GMT

Hello,

Could you please modify your connection string to include ignoreUpdateCount=on as a parameter and try again.

Such as,

jdbc:netezza://{host}:{port}/{database};ignoreUpdateCount=True

Let us know if it works for you.

Best regards

Sabrina

topic tELTNetezzaMap - Additional JDBC parameters in Talend Studio

tELTNetezzaMap - Additional JDBC parameters

Re: tELTNetezzaMap - Additional JDBC parameters