Facing Error In Backing up a Qlik Sense site

Warfan_Khan — Tue, 31 May 2022 11:06:56 GMT

Below are details of windows,QlikSenseUtil.exe ,pg_dump.exe ,Microsoft PowerShell and qlik sense Versions.

Windows Version: Windows Server 2012 R2 Standard.
Qlik sense Version: Qlik Sense June 2020.
PowerShell version is 4.
QlikSenseUtil.exe version is:2.7.0
pg_dump.exe :Version Details are Not Showing in pg_dump.exe properties.

I am working on UAE/ Middle east time zone.

Please check now I attached screenshots now.

I have tried certifcate password with no special character.

I am trying to do backup with two exe 1st one is QlikSenseUtil.exe and 2nd is pg_dump.exe.

Below is command which i run For QlikSenseUtil.exe.

Command Start:
C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe -backup -databaseHostname="localhost" -databasePassword="IQRA12345" -path="C:\QlikSense backup" -certificatePassword="cert@123"

Command End.

Below is error msg Which is through after run QlikSenseUtil.exe.
Error message start:

Exception in thread main, msg=The specified executable is not a valid application for this OS platform., code=-2147467259

Error message end.
I have attached error message screenshot with the name of 1.png.

Below is command which i run For pg_dump.exe.

Command Start:
C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin>pg_dump.exe -h localhost -p 4432 -U postgres -v -b -F t -f "C:\QlikSense backup\QSR_backup.tar" QSR
Command End.

Below is error msg Which is through after run pg_dump.exe.
Error message start:

This app can't run on your PC to find a version for your PC, check with the software publisher.

Error message end.
I have attached error message screenshot with the name of pd_dump Error.png.

pg_dump.exe is Showing 0kb.

I attached one more file with the name of pg_dump_Properties.png.

Re: Facing Error In Backing up a Qlik Sense site

Eduardo_Monteiro — Wed, 01 Jun 2022 02:49:53 GMT

Hello @Warfan_Khan

What I'm about to post is a workaround for your problem. You can also backup the QSR table by using pgAdmin.

It is very simple and faster then manually running the the pg_dump. All you need to do is to install the latest version of pgAdmin, connect your database, right click the QSR table and select backup.

Here is a link where you can download pgAdmin Download (pgadmin.org)

In case it doesn't fit for you. I would start trying to upgrade PowerShell to 5.1.

Regards,

Eduardo Monteiro

topic Facing Error In Backing up a Qlik Sense site in Management & Governance

Facing Error In Backing up a Qlik Sense site

Re: Facing Error In Backing up a Qlik Sense site