Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diegofcaivano
Partner - Creator
Partner - Creator

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
Anonymous
Not applicable

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
Partner - Creator
Partner - Creator
Author

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

Regards,

Diego.-

Anonymous
Not applicable

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

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.

Anonymous
Not applicable

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

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.