PostgreSQL update using QPI1.4 failed saying "Backup failed". Now cannot access QMC or HUB.

[stephanph]

I have been updating a couple of servers, and ran into a problem with one of the servers. I have followed the same process for all the previous servers and never received this issue before. 

Steps:
1. Stop all Qlik Services except Qlik Sense Repository Database service.

2, Run the QPI as administrator.

3. I got this error: Backup failed and when I look in the log I see the following. 

Strange thing is that when I went to services, a whole bunch of services had restarted even though I had stopped all of them.

I have looked at an install log file from a server that has run successfully and it does not look like there was much to do. The step that failed was to rename the 9.6 folder to 9.6_depricated. Then the next step was to restore the backup of postgre for 14.8.

I have tried to do the last step, however I cannot connect to the new version of PostGre. I am stuck now as you cannot repair or rollback by the looks of it.

Anybody else run into this issue and how did you fix it?

Thanks

[Sebastian_Linser]

Hello,

you can for a start change the imagepath variable on the QlikSenseRepositoryDatabase Service back to the standard. https://support.qlik.com/articles/000037042

this way you will get the 9.6 DB back, now for the rest you have two possibilies, if QPI already created the fulldbdump file we can use this one to import into the 14 instance, otherwise we can simply backup and restore the databases as described on the qlik help

https://help.qlik.com/en-US/sense-admin/August2023/Subsystems/DeployAdministerQSE/Content/Sense_Depl...

https://help.qlik.com/en-US/sense-admin/August2023/Subsystems/DeployAdministerQSE/Content/Sense_Depl...

You can only do the part for the databases, skip the certificate backup since that does not change.

Make sure only one DB service is running if they are both on port 4432, if you want to have them both running just change the postgresql.conf parameter port = 4432 to port = 5432 and restart the postgresql 14 database service. After the migration is finished you can change it back to 4432 and then continue with steps 16 and 17 on the upgrade qlik sense database article https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repo...

If you get problems with any of those steps, please open a case with support.

best regards

Sebastian

[stephanph]

Thank you. We got around this using a different method, however if I ever hit the same problem again, I will certainly try your recommended steps.