Skip to main content

Announcements
Week 3: High-Volume Iceberg Ingestion and Smarter Data Prep - WATCH NOW

Missing Repository Database Service after Qlik Sense Server Upgrade Fails with An Error Occurred

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrew_Delaney
Support

Missing Repository Database Service after Qlik Sense Server Upgrade Fails with An Error Occurred

Last Update:

Oct 18, 2021 3:16:15 AM

Updated By:

Sonja_Bauernfeind

Created date:

Oct 24, 2016 9:48:05 AM

Upgrading Qlik Sense Enterprise on Windows fails with a generic error message:

An error has occurred
For detailed information see the log file

The Qlik Sense Repository Database service is no longer installed after the failed installation.

This means that the database password validation did not complete and a partial rollback has occurred. This has removed the database software, but it has not removed the database itself.

The database password is normally password is checked before the upgrade process begins, but under some circumstances, such as the database service being stopped, this check does not occur. Once the new version of the database software is installed it will attempt to open the database as part of the install verification process and will fail. This then prompts a rollback of the database software and removing the new version.

 

Resolution:


Reinstall Qlik Sense. (Uninstall, Reinstall)

During the uninstall process, do not remove the certificates or database. 

Once Qlik Sense is uninstalled, you can proceed to install the desired upgraded version of Qlik Sense, the installer will detect the existing database and request the password, if it is from an earlier version the installer will make the necessary changes as part of the installation process.

 

Environment:

Qlik Sense Enterprise on Windows  

Labels (1)
Comments
Tool_Tip
Creator III

We found that Qlik Sense Repository Database service is disappeared after upgrading postgres from 12 to 14...is it normal or we have missed something to get it back?

steasy
Contributor III

@Andrew_Delaney@Sonja_Bauernfeind 

Same question as @Tool_Tip, Qlik Sense is working normal, but there is no Repository Database service to follow the recommended Stop Order.

Sonja_Bauernfeind
Digital Support

Hello @steasy 

Have you unbundled PostgreSQL? In that case, please refer to this note:

Sonja_Bauernfeind_0-1743495887786.png

The service you are looking for will be called postgresql-x64-YOURVERSION

This article deals with a particular and old issue.

All the best,
Sonja

steasy
Contributor III

@Sonja_Bauernfeind Helped, thanks!

Tool_Tip
Creator III

Yes, we have unbundled postgres from 12 to 14 and also we are able to see new service postgresql-x64. so i think its normal if you have unbundled postgres then Qlik Sense Repository Database service is disappeared