topic Re: Qlik Sense June 2017 install and restore in Management & Governance

Qlik Sense June 2017 install and restore

elizabethbamber — Mon, 17 Jul 2017 14:38:14 GMT

I am following instructions for "Upgrading to Qlik Sense June 2017 from Qlik Sense versions earlier than 3.1 SR2" and am having trouble on step 14.

14.Run the following command to install Qlik Sense and restore your Qlik Sense Repository Database.

Qlik_Sense_setup.exe databasedumpfile=<path_to_dump_file>

The installation starts but I am unclear which options to follow:

- connecting to an existing database fails

- creating a new database does just that

Can anyone assist, should I be seeing some other options referencing the restore?

Thanks

Re: Qlik Sense June 2017 install and restore

elizabethbamber — Tue, 18 Jul 2017 08:50:37 GMT

After tweaking the command prompt to start installation to be:

Qlik_Sense_setup.exe databasedumpfile="C:\Users\xxxx\xxxx\xx xxx\QSR_backup.tar"

A couple of steps after selection of "Install local database" there is a step "Repository Database Superuser Password" acknowledging detection of a Repository database.

However the install ultimately fails.

I note that the size of the backup differs dependent upon method used to generate backup.

Method1

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

Method2

set PGUSER=postgres

set PGPASSWORD=[superuserpassword]

pg_dumpall.exe -p 4432 > [path to dump file]

I have tried restoring both backups without success.

The log file shows:

Action 09:22:24 33 C:/Users/Administrator/xxx/xxxxx/xx xxxx/QSR_backup.tar: No such file or directory

CustomAction CA_RestoreDatabaseFromDumpFile returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)

Anyone else encountered similar errors/know how to resolve?

Thanks

Re: Qlik Sense June 2017 install and restore

barry_stevens — Wed, 19 Jul 2017 23:51:52 GMT

without stating the obvious does 'C:/Users/Administrator/xxx/xxxxx/xx xxxx/QSR_backup.tar' exist? can the service account see this or the user doing the install?

Your option one points to 'c:\QSR_backup.tar' and not sure where option two points to...

I have done what you are trying and it worked no problems, but I had uninstalled qlik first (so used the second instructions in step 5)...

Re: Qlik Sense June 2017 install and restore

elizabethbamber — Fri, 28 Jul 2017 14:55:26 GMT

Thanks Barry

The file does exist. I had moved the file hence change of location in reference.

I am continually getting error "The database password entered does not match the database user password specified in the dump file". When creating the backup the superuser password has to be entered so cannot understand why this is being returned. Attached is a file with steps on which I have some questions. If anything clearly awry in here will be grateful if can be advised changes necessary.

Thanks

Re: Qlik Sense June 2017 install and restore

barry_stevens — Sun, 30 Jul 2017 21:57:48 GMT

Not sure how much more I can help... If i recall I actually logged into the DB and changed the PW interactively (as thinking about it may have also had that error). Then did the dump file.

Sorry not too much help

Barry

Re: Qlik Sense June 2017 install and restore

elizabethbamber — Mon, 07 Aug 2017 12:44:34 GMT

Thank you Barry - you have helped! I went back and did the password change using PGAdmin tool and the upgrade/restore of database went through OK.

If anyone else has same issue I used these instructions to connect PGAdmin to postgres database.

•Run pgAdmin3.exe from C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin
•Click the power plug button on the top manual bar and enter information
•Name - QSR
•Server - localhost
•Port - 4432 (not the default of 5432)
•User Name - postgres
•Password - the password that you provided on installation.

Then changed the password following second method of changing password under step 3 of upgrade instructions for "Upgrading to Qlik Sense June 2017 from Qlik Sense versions earlier than 3.1 SR2" via
https://help.qlik.com/en-US/sense/June2017/Subsystems/PlanningQlikSenseDeployments/Content/Deployment/Upgrading.htm

Re: Qlik Sense June 2017 install and restore

barry_stevens — Mon, 07 Aug 2017 21:46:19 GMT

Glad I was some help and you have made progress

Re: Qlik Sense June 2017 install and restore

leonelqv — Fri, 05 Jan 2018 15:30:14 GMT

Hi Elizabeth,

I have the same problem, were u able to solve this issue ?