As i was continuously getting the following error, do we have option like auto reconnect in Additional JDBC Parameters.
[FATAL]: local_project.j_sample_0_1.j_Sample - tAsyncOut_tVerticaOutput_1 An existing connection was forcibly closed by the remote host
org.netezza.error.NzSQLException: An existing connection was forcibly closed by the remote host
You probably have to change tcp_keepalive_time parameter to avoid a connection close while your process is waiting for a response from the db server.
The following command set the keppalive parameter to 30 minutes
echo 1800 > /proc/sys/net/ipv4/tcp_keepalive_time
You may refer to this post from Vertica forum.
As per my understanding to your comment we need to change it in the server where the Netezza was installed.If i am correct. Please correct me if i am wrong.
You are right.
Also, as the result is not garanted, save the current value for tcp_keepalive_time to be able to restore it in case the problem is not solved with that.
In case of multi-nodes, do the same thing for each node.
Is there any update for your tcp_keepalive_time implement?
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Test drive Talend's enterprise products.