Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
where can I delete Sense created certificates. Could you please help us in details? We are new to QS server installation.
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
Hi Kumar,
Server certificates are located in the following locations:
To recreate the certificates, the QRS needs to run in bootstrap mode. Instructions can be found here:
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
Hi Simon,
Thanks for your update.
I will check it and let you know.
Thanks
Kumar KVP
@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.