tELTNetezzaMap - Additional JDBC parameters

[Anonymous]

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.

[Anonymous · Accepted solution]

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