Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

edwinwitvoet
New Contributor III

Not possible to decrypt encrypted string in database

When checking the "operations monitor" (Qlik Sense Server environment), the following error is listed.


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


Any idea's how to update 'the old database value' and resolve this error?

Tags (1)
5 Replies
johnh
Contributor

Re: Not possible to decrypt encrypted string in database

Hi Edwin,

Not sure if you got a solution to this.

I have encountered the same issue. It looks like it was caused when I upgraded my OS from Server 2008R2 to 2012 R2. I tried to recreate my Certificates without luck.

I logged a call with Support and after trying a number of things I have decided that as this is only a Test Repository I am going to recreate it. There does not appear to be a way to fix that Secrets Key. The Support Techie did say that he had put in a request to enable us to fix the Secret Key via QMC but considering that that Secret key helps to encrypt data it could be pretty difficult to change the secrets key.

The only real solution seems to be to restore to a last known good backup of the Repository or recreate the repository.

Cheers

korsikov
Valued Contributor II

Re: Not possible to decrypt encrypted string in database

i'm faced with this problem when update my Qlik Sense from 2.1 to 2.2.3 version. at now i'm not solved problem

Highlighted
agigliotti
Honored Contributor II

Re: Not possible to decrypt encrypted string in database

I'm facing the same problem upgrading a multinode site from 3.0.1 to 3.1.3 version.

the problem involve only rim node.

attached the rim node log with the error.

How can I fix it ?

IT'S URGENT !!!

Many thanks in advance.

BR

Andrea

korsikov
Valued Contributor II

Re: Not possible to decrypt encrypted string in database

If I remember correctly in the attached document contains information on how to decrypt the connection.

agigliotti
Honored Contributor II

Re: Not possible to decrypt encrypted string in database

I tried to apply the resolution suggested in the following article https://qliksupport.force.com/QS_CaseWizardKnowledgeArticle?Id=ka5D00000004Nu7IAE

but the error still persist !!!

where can I find in QMC the ID listed in the log file generating the error ?