Qlik Replicate Postgres as a target disconnect: TARGET_APPLY server closed the connection unexpectedly

[shashi_holla]

The Qlik Replicate logs may report the following error on Target Apply:

[TARGET_APPLY    ]E:  RetCode: SQL_ERROR  SqlState: 08S01 NativeError: 35 Message: server closed the connection unexpectedly

Resolution

Add the Internal Parameter additionalConnectionProperties (a) to the Postgres Target endpoint and provide the following two ODBC parameters (b😞

KeepaliveTime=60; KeepaliveInterval=1;

See Qlik Replicate: How to set Internal Parameters and what are they for? for detailed instructions on how to add an Internal Parameter.

Cause 

If Qlik is replicating across networks that transit cloud infrastructure or have any type of firewall device, the database connection options must enable a TCP keepalive setting or certain scenarios will cause idle connections to age-out. In one of the scenarios, data pipeline loads create large updates that must be inserted on the target. These inserts take time, long enough for Qlik's sessions to age-out idle across the intermediate network devices. This required setting the mentioned flags for the Postgres ODBC driver. 

Environment

Qlik Replicate 

[GELS]

Hi 

Do we have similar kind of setting for DB2 IBM iSeries AS400  as source ?

We are frequently  getting following error. We want to set tcpKeepAlive=true 

[SOURCE_CAPTURE  ]E:  RetCode: SQL_ERROR  SqlState: 08S01 NativeError: 10054 Message: [IBM][System i Access ODBC Driver]Communication link failure. comm rc=10054 - CWBCO1047 - The IBM i server application  disconnected the connection [1022502]  (ar_odbc_stmt.c:4064)