topic Re: Qlik Replicate PostgreSQL Connection Issue in Qlik Replicate

Qlik Replicate PostgreSQL Connection Issue

jborthen — Tue, 02 Jan 2024 19:12:17 GMT

Hi, I have a PostgreSQL 12 database running in an AWS EC2 Rocky 8 Instance and I have Qlik Replicate running in Windows Server. I am trying to connect the PostgreSQL database with Qlik Replicate but I keep getting the same error.

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 driver Cannot load <libpq.dll, >: The operation completed successfully. Cannot load <libpq.dll>: The specified module could not be found.

I have installed the PSQL ODBC driver on both the Rocky Instance and in Windows Server. I've checked the system paths, I've checked the inbound and outbound port rules for both machines, I've double checked IP addresses, user names, and passwords, and nothing works.

Re: Qlik Replicate PostgreSQL Connection Issue

Alan_Wang — Tue, 02 Jan 2024 20:24:53 GMT

Hello,

Can you check if you have added the psql.exe path (Example: "C:\Program Files\PostgreSQL\13xx\bin") to the system PATH on your Windows server?

Re: Qlik Replicate PostgreSQL Connection Issue

jborthen — Tue, 02 Jan 2024 20:27:32 GMT

[Graphical user interface, text Description automatically generated]

Re: Qlik Replicate PostgreSQL Connection Issue

Alan_Wang — Tue, 02 Jan 2024 20:32:38 GMT

I'm not able to see the new image you may have attached. With Replicate 2023.11 Postgres ODBC driver 13 should be used. If the driver was installed recently, please restart the Replicate service for the driver changes to take effect.

Re: Qlik Replicate PostgreSQL Connection Issue

jborthen — Tue, 02 Jan 2024 20:38:32 GMT

Hi, Alan. Thanks for the response. I am using psql 12 and psqlodbc 12 per the Qlik documentation. The image I sent in my previous email was a screenshot of the ODBC in the system path. I've restarted Replicate multiple times and have also rebooted the Linux server multiple times. Still not working.
v/r,
Jay

Re: Qlik Replicate PostgreSQL Connection Issue

Alan_Wang — Tue, 02 Jan 2024 20:57:29 GMT

Your initial image shows November 2023 as the Replicate version. The Prerequisite for this version is 13. The driver should be installed on the same server where Replicate is installed. If you have a Linux server for Replicate's installation, please follow these prerequisites in this user guide documentation to make sure you are sourcing the right file paths.

https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Main/PostgreSQL/prereq_postgresql_source.htm

Re: Qlik Replicate PostgreSQL Connection Issue

jborthen — Tue, 02 Jan 2024 22:51:25 GMT

Thanks, Alan.