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

shashi_holla — Tue, 07 Mar 2023 10:29:18 GMT

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

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

GELS — Thu, 09 Jan 2025 08:46:27 GMT

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)

article Qlik Replicate Postgres as a target disconnect: TARGET_APPLY server closed the connection unexpectedly in Official Support Articles

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

Resolution

Cause

Environment

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