Replicate 7.0 PostgreSQL Source prerequisites

john_wang — Tue, 16 Mar 2021 11:46:15 GMT

PostgreSQL source prerequisites in Replicate 7.0 User Guide:

Client side

Qlik Replicate Server for Windows:
PostgreSQL ODBC Driver psqlodbc_12_02_0000-x64 only must be installed on the Qlik Replicate
machine.

Environment

Replicate Nov 2020 (7.0)
PostgreSQL 12.2 client

Resolution

Fresh Install 10.3 first, then perform upgrade installation of 12.2

Execute "psqlodbc_x64" in 10.3 package first, then execute it again in 12.2 package.

https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_10_03_0000-x64.zip https://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_12_02_0000-x64.zip

Let's assume the installation default folder is: C:\Program Files\psqlODBC\1003\bin while you install 10.3

Add below folder to the system variable PATH:

C:\Program Files\psqlODBC\1003\bin

Cause

Libintl-8.dll is a DLL with old versions (09.03 - 10.3) but it is not included with the 12.02 driver.

Replicate reports error if install psql ODBC version 12.02 only:

SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'PostgreSQL Source', type 'PostgreSQL Source'.. SYS,GENERAL_EXCEPTION,Stream component initialization function has failed for component 'PostgreSQL Source', type 'PostgreSQL Source'.,Error Initializing endpoint. Failed to load Postgres NLS driver Cannot load <libintl-8.dll, >: The operation completed successfully. Cannot load <libintl-8.dll>: The specified module could not be found.

Internal Investigation ID(s)

support cases 02154903, 02153701

article Replicate 7.0 PostgreSQL Source prerequisites in Official Support Articles

Replicate 7.0 PostgreSQL Source prerequisites

Environment

Resolution

Cause

Internal Investigation ID(s)