topic Re: Not possible to decrypt encrypted string in database in Management & Governance

Not possible to decrypt encrypted string in database

edwinwitvoet — Thu, 15 Jan 2015 09:50:58 GMT

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?

Re: Not possible to decrypt encrypted string in database

johnh — Fri, 23 Jan 2015 13:59:24 GMT

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

Re: Not possible to decrypt encrypted string in database

korsikov — Thu, 03 Mar 2016 09:46:10 GMT

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

Re: Not possible to decrypt encrypted string in database

agigliotti — Tue, 06 Dec 2016 10:05:44 GMT

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.

Andrea

Re: Not possible to decrypt encrypted string in database

korsikov — Tue, 06 Dec 2016 10:22:21 GMT

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

Re: Not possible to decrypt encrypted string in database

agigliotti — Tue, 06 Dec 2016 12:10:36 GMT

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 ?

Re: Not possible to decrypt encrypted string in database

Rakesh_HB — Thu, 19 Aug 2021 19:57:26 GMT

Check this,

https://community.qlik.com/t5/Knowledge/Repository-System-Log-Shows-Error-quot-Not-possible-to-decrypt/ta-p/1713075