SYS-E-HTTPFAIL, 'psql' is not recognized as an internal or external command, operable program or batch file..

[sandeepsingh005]

Hi Team,

I am using Aurora PostgreSQL as a target database and have installed all the prerequisite on the Qlik Replicate insatnce.

I have - PgAdmin, psqlodbc 15, Postgresql server , have added the psql bin directory to the path (environment variable) still I am getting the below error -

SYS-E-HTTPFAIL, 'psql' is not recognized as an internal or external command, operable program or batch file..SYS,GENERAL_EXCEPTION,'psql' is not recognized as an internal or external command, operable program or batch file.,Command failed to load data with exit error code 1, Command output: 'psql' is not recognized as an internal or external command, operable program or batch file.

Any idea, why this is happening? I have seen people getting this issue and I have seen all the resolution before and verified that I have the correct configuration.

Also, in the security section, if I choose SSL mode = prefer I get the above error but when I choose disable I get the below error -

Cannot connect to ODBC provider [1022506] (odbc_endpoint_imp.c:4487)

Any immediate help is highly appreciated.

[john_wang]

Hello @sandeepsingh005 ,

Welcome to Qlik Community forum and thanks for reaching out here!

This is because the executable program "psql"  cannot be found. Please add the program path to the PATH environment variable and then restart the Qlik Replicate services. You can add it in different script files, eg the user login script (by default the user name is "attunity") or add it to "/opt/attunity/replicate/bin/site_arep_login.sh".

BTW, you need to install 64-bit "psql", 32-bit is not supported. Please Download postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86_64.rpm as mentioned in User Guide, this is the certified version in Qlik Replicate 2023.5.

Hope this helps.

Regards,

John.

[sandeepsingh005]

HI John,

I am using a Qlik AMI in AWS - it is a windows 2019 datacenter server. psql is set as a system environment variable, I restarted the Attunity services, too but still getting the same error.

[sandeepsingh005]

I installed 64 bit Postgresql 15 server and psql was installed along with that.

[john_wang]

Hello @sandeepsingh005 ,

My previous comments are based on Qlik Replicate running on Linux.

If you are running Qlik Replicate on Windows then the path environment variable looks like:

Let's troubleshoot the issue by steps:

1- Open a DOS prompt and type "psql", is it executable?

2- If step 1 answer is yes, then please find out the proper driver name

    (1) Open ODBC Data Source (64-bit)

    (2) Go to File DSN tab

    (3) Press Add

    (4) Choose PostgreSQL Unicode(x64)

    (5) Then we get the driver name, in my sample it's "DRIVER={PostgreSQL Unicode(x64)}", in Qlik Replicate, the proper driver name in endpoint should be "PostgreSQL Unicode(x64)"

    (6) You may add an internal parameter driver and verify if the name is correct or not. If it's incorrect, then input the name as same as it appears in the ODBC Manager.

Feel free to let me know if you need any additional assistance.

Good luck,

John.

[sandeepsingh005]

Hi John,

Thanks for the reply.

1. psql command works in cmd -

2. In the ODBC driver the postgresql driver name is same as yours and it is also showing the same in the 'internal parameters in Qlik replicate when creating the end point.

Still getting the same error.

[skokanay]

Hi John,

Recently we upgraded the QR version in RHEL8 OS to 2023.5 & also the  postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86_64.rpm. The help doc says only the postgres odbc libraries are required and the psql binaries need not be installed in the OS. we verified this without psql and found its working. Please clarify.

[john_wang]

---

@sandeepsingh005 wrote:

Hi John,

Thanks for the reply.

1. psql command works in cmd -

2. In the ODBC driver the postgresql driver name is same as yours and it is also showing the same in the 'internal parameters in Qlik replicate when creating the end point.

Still getting the same error.

---

Thanks for your feedback @sandeepsingh005 . Did you ever restart Qlik Replicate services? 

"psql" executable program is used in Batch Apply Mode while PostgreSQL is the target endpoint. If you switch the apply mode from Batch Apply Mode to Transactional Mode then "psql" will not being called. The Batch Apply Mode performance is better than Transactional Mode.

If you still face the issue, it's better you can share the "repsrv.log" after the issue reproduced. If there are sensitive information in log files you can open a support ticket.

Best Regards,

John.

[john_wang]

---

@skokanay wrote:

Hi John,

Recently we upgraded the QR version in RHEL8 OS to 2023.5 & also the  postgresql13-odbc-13.02.0000-1PGDG.rhel8.x86_64.rpm. The help doc says only the postgres odbc libraries are required and the psql binaries need not be installed in the OS. we verified this without psql and found its working. Please clarify.

---

Thanks for sharing, @skokanay Obviously you are correct because "psqlodbc" on Linux contains "psql" executable program already. However it does not exist on Windows that's why we need installation of additional program to provide the "psql" functionality which is used in Batch Apply Mode.

Best,

John.

[sandeepsingh005 · Accepted solution]

Hi @john_wang 

I am still facing the issue. I have attached the repsrv log here.