Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
diegofcaivano
Contributor

Repository Snapshot Manager - Restore Error

Hi all.


After successfully being able to backup a Sense Server installation using the RSM (here), it fails when restoring the files -even on the same machine-. Same error occured in every sceneario we tried: "QSR database already exists".


It seems the restore command always forces the creation of a new repository database as it re-installs Sense, and therefore the previous database cannot be loaded.


jul 07 12:34:14 2016: Database Service status check ok, now starting the RepositoryDatabaseService...

jul 07 12:34:14 2016: Initializing and starting database...

jul 07 12:34:14 2016: Creating database...

jul 07 12:34:14 2016: Checking database existence and status...

jul 07 12:34:14 2016: Creating login credentials file for database...

jul 07 12:34:14 2016: Password file created

jul 07 12:34:14 2016: Obtaining command process start info, relpath=PostgreSQL\9.3\bin

jul 07 12:34:14 2016: Obtaining default database installation path from relative path=PostgreSQL\9.3\bin

jul 07 12:34:14 2016: Database exists...

jul 07 12:34:14 2016: Creating database, cmd=createdb.exe -U postgres -p 4432 QRS

jul 07 12:34:14 2016: Obtaining command process start info, relpath=PostgreSQL\9.3\bin

jul 07 12:34:14 2016: Obtaining default database installation path from relative path=PostgreSQL\9.3\bin

jul 07 12:34:14 2016: Checking database status after creation...

jul 07 12:34:14 2016: Error: Database initialization failed with error: createdb: fall¾ la creaci¾n de la base de datos:

ERROR:  la base de datos ┬½QSR┬╗ ya existe

Any comment or experience on this subject is very welcome.

Thanks,

Diego.-

6 Replies
denisramlf
New Contributor II

Re: Repository Snapshot Manager - Restore Error

Could you manage to solve it ?

We exactly have the same issue with QlikSense 2.2.3 on Windows Server 2012 R2

Thanks,

Denis

diegofcaivano
Contributor

Re: Repository Snapshot Manager - Restore Error

Hi Denis. No, we didn't get it to work even with Sense 3.0.

Regards,

Diego.-

denisramlf
New Contributor II

Re: Repository Snapshot Manager - Restore Error

In it helps : we could very easily apply the manual restore procedure, I think the restore part is simply broken in RSM.

Regards,

Denis

Not applicable

Re: Repository Snapshot Manager - Restore Error

I have the same problem trying to restore qliksense v3.1.1

Database creation failed with msg=Initialize PostgreSQL database 'QSR' failed.

See Message for more info., code=-2146233079

Database initialization or startup failed with msg=Initialize PostgreSQL database 'QSR' failed.

See Message for more info., code=-2146233079


Hope to find a solution soon.

denisramlf
New Contributor II

Re: Repository Snapshot Manager - Restore Error

RSM is OK to backup but has never been able to restore correctly on our installation because it tries to create this QSR database twice and obviously the second time it fails...

The solution is to apply the manual procedure which is well documented here : Restoring a site manually ‒ Qlik Sense

Best regards,

Denis

Not applicable

Re: Repository Snapshot Manager - Restore Error

Hi Denis, I already tried at least 3 times.

  • dropdb -h localhost -p 4432 -U postgres QSR
  • createdb -h localhost -p 4432 -U postgres -T template0 QSR
  • pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\QSR_CS_backup.tar" (this is the name of my bakup)


when this task was completed I opened QlikSense and there isn´t new info (cant see new users, tasks, etc).

Then I reboot the server and QlikSense service is running but the QMC and HUB doesn´t work anymore.