Repository System Log Shows Error "Not possible to decrypt encrypted string in database"
Article Number: 000005630 | Last Modified: 2018/06/12
Qlik Sense can be accessed and used as expected. Qlik Sense Repository System logs shows 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
The cause for this problem is that passwords and other connection values are stored encrypted in the database. The encryption is based upon the previous certificate and new encrypted values need to be generated to resolve this error.
There are two ways of recovering the accidentally deleted certificates.
- Revert to the backup of your root certificate. Qlik Sense does not take automatic backup of the root certificate, so this option requires that the system admin has backups.
- Go to the Qlik Management Console (QMC) > Data Connections & User Directory Connectors >
(a) Open each Data Connection / User Directory Connector
(b) Enter a null password for each data connection, i.e. ; (semi-colon) which will be interpreted as an escape character
(c) If the connection does have a password, then do step (b) followed by re-entering the password
This causes the system to write new encrypted strings to the database using the current certificate.