Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.-
Could you manage to solve it ?
We exactly have the same issue with QlikSense 2.2.3 on Windows Server 2012 R2
Thanks,
Denis
Hi Denis. No, we didn't get it to work even with Sense 3.0.
Regards,
Diego.-
In it helps : we could very easily apply the manual restore procedure, I think the restore part is simply broken in RSM.
Regards,
Denis
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.
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
Hi Denis, I already tried at least 3 times.
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.