topic Repository Snapshot Manager - Restore Error in Management & Governance

Repository Snapshot Manager - Restore Error

diegofcaivano — Thu, 07 Jul 2016 16:26:43 GMT

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.-

Re: Repository Snapshot Manager - Restore Error

Anonymous — Thu, 28 Jul 2016 14:16:19 GMT

Could you manage to solve it ?

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

Thanks,

Denis

Re: Repository Snapshot Manager - Restore Error

diegofcaivano — Thu, 28 Jul 2016 15:28:21 GMT

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

Regards,

Diego.-

Re: Repository Snapshot Manager - Restore Error

Anonymous — Tue, 02 Aug 2016 14:40:21 GMT

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

Regards,

Denis

Re: Repository Snapshot Manager - Restore Error

Thu, 28 Sep 2017 20:57:20 GMT

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.

Re: Repository Snapshot Manager - Restore Error

Anonymous — Fri, 29 Sep 2017 07:26:27 GMT

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

Re: Repository Snapshot Manager - Restore Error

Fri, 29 Sep 2017 17:03:44 GMT

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.