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: 
kumarkp412
Creator II
Creator II

Qlik Sense Hub and QMC is not opening

Hi Friends,

My qliksense site was done and it is production server,

when i try to open the hub and qmc it was not opening and saying 404 error .

After that when i checked the log files , i got the following error.

error:

Not possible to decrypt encrypted string in database; this is probably due to the secrets key on server certificate has been changed and the old database value hasn't; sending back empty result and leaving the value unchanged in database

Can  any one help me on this. Please it urgent bro.

Thanks in advance

Thanks

Kumar KVP

6 Replies
simon_minifie
Partner - Creator III
Partner - Creator III

Hi Kumar,


Try deleting the Sense created certificates from the MMC.

Then restart the services which will force Sense to create new ones.


Thanks,

Simon

vamshi_1241
Partner - Creator
Partner - Creator

where can I delete Sense created certificates. Could you please help us in details? We are new to QS server installation.

kumarkp412
Creator II
Creator II
Author

Hi Simon,

Thanks for your reply,

Can you please share me the name of the certificates which i need to delete in MMC.

Thanks in advance.

Thanks

Kumar KVP

simon_minifie
Partner - Creator III
Partner - Creator III

Hi Kumar,

Server certificates are located in the following locations:

https://help.qlik.com/en-US/sense/September2017/Subsystems/PlanningQlikSenseDeployments/Content/Depl...

To recreate the certificates, the QRS needs to run in bootstrap mode. Instructions can be found here:

https://help.qlik.com/en-US/sense/September2017/Subsystems/PlanningQlikSenseDeployments/Content/Depl...

Another option is to do a complete uninstall, check that the certificates have been deleted from the locations above, and then re-install.

Thanks,

Simon

kumarkp412
Creator II
Creator II
Author

Hi Simon,

Thanks for your update.

I will check it and let you know.

Thanks

Kumar KVP

duzunic88
Contributor II
Contributor II

@kumarkp412  Did you ever resolve this? Same thing happened to me out of nowhere.  I was able to fix by restarting all nodes. However would like to figure out cause.