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

Error In Backing up a Qlik Sense site

akbarhussein — Thu, 26 May 2022 13:26:28 GMT

I am trying to do the Backing up a Qlik Sense site, Below is the command which I run in command Prompt :

Command Start:

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

Command End:

Its Showing me the Below Issue.

Issue message start:

QlikSenseUtil, mode-backup Exception in thread main, msg-28P01: "postgres", code=-2147467259 password

Issue message End:

Re: Error In Backing up a Qlik Sense site

rubenmarin — Sun, 29 May 2022 07:02:06 GMT

Hi, that error means that the passowrd you are using in the command is not the super user password, you need to pass the current superuser password.

If you have lost the password you can try this: https://help.qlik.com/en-US/sense-admin/February2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Troubleshooting-cannot-find-the-repository-database-superuser-password.htm

Or this (a backup or snapshot will be nice before starting this procedure): https://community.qlik.com/t5/New-to-Qlik-Sense/Change-add-password-to-repository-database/td-p/812790

Re: Error In Backing up a Qlik Sense site

Boris_I — Sun, 29 May 2022 14:13:58 GMT

Hi @akbarhussein ,

You can also do the backup without using that tool, just follow the steps from that article.

https://community.qlik.com/t5/Knowledge/How-to-backup-or-restore-the-PostgreSQL-database-in-Qlik-Sense/ta-p/1712875

Regards

Boris

Re: Error In Backing up a Qlik Sense site

akbarhussein — Mon, 30 May 2022 08:43:28 GMT

hi rubenmarin,
Thanks for previous help, now I took super user password but now its giving me new error message, Below is a error message.

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:

Below are details of My windows and qlik sense Versions.

Windows Version: Windows Server 2012 R2 Standard
Qlik sense Version: Qlik Sense June 2020

The pg_dump.exe is not showing the Version details.

Kindly check the attached screen shots if needed.

Thanks.

Re: Error In Backing up a Qlik Sense site

akbarhussein — Mon, 30 May 2022 08:56:26 GMT

hi @Boris_I thanks for advice,

I was followed same link which you give me above,

now previous issue is solved but I am facing new error, Below is a error message.

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:

Below are details of My windows and qlik sense Versions.

Windows Version: Windows Server 2012 R2 Standard
Qlik sense Version: Qlik Sense June 2020

The pg_dump.exe is not showing its Version details.

Kindly check the attached screen shots if needed.

thanks

Re: Error In Backing up a Qlik Sense site

Boris_I — Mon, 30 May 2022 09:04:41 GMT

Hi @akbarhussein

What version of PowerShell are you using?

please run this command in PowerShell

$psversiontable

Re: Error In Backing up a Qlik Sense site

akbarhussein — Mon, 30 May 2022 14:40:42 GMT

hi @Boris_I ,

My powerShell version is 4.

I was try in command prompt as well as in Microsoft powerShell.

But getting same error in both.

Re: Error In Backing up a Qlik Sense site

Boris_I — Mon, 30 May 2022 15:13:00 GMT

Hi @akbarhussein,

Looking at the screenshot i have the feeling that you are not following the instruction.

You run this command to be in the right directory

cd "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin"

then you only need to copy and paste this one

\pg_dump.exe -h localhost -p 4432 -U postgres -v -b -F t -f "c:\backup\QSR_backup.tar" QSR

And that it