Just installed 14.1.3.0 - credentials missing from Private Vault after move
I've just updated to 14.1.3.0 and then moved some credentials around in my private vault. Since I have, the credential still shows in private vault but the usernames and passwords are missing. We are using a shared MSSQL database.
I've tried exporting the Private vault and importing into a local data source and I was surprised that some credentials reappeared. Have you any ideas how I can get the credentials or what could have caused this?
I did check that the database was up to date before doing any changes.
Thanks
Martyn
Hello,
With the SQL Server data source selected, could you try to perform a CTRL + F5 to refresh the local cache and see if that help.
Best regards,
Jeff Dagenais
Hi Jeff
I have tried recreating the cache. No difference unfortunately.
Regards
Martyn
Is there anything that could cause this? I can see credentials missing from connections that I don't think have been moved as well but it's not affecting all credentials although I've had to recover some from other sources.
Hello,
I've replied to you, but it seems that my post was never submitted.
My reply was to try connecting on the data source without any caching to see if all the credentials and sessions are present. To do so, go in File -> Data Sources -> Edit -> Advanced tab and switch the Caching mode from Intelligent to Disabled.
If the issue is still present, you would need to restore a backup from yesterday and connect on the database to perform an export of your Private Vault and import it in the production database.
Best regards,
Jeff Dagenais
Hi Jeff
I thought this may be the case. Is the Private Vault stored in particular tables or is this something we can do from within RDM?
Thanks
Martyn
Hello,
The Private Vault is encrypted in the database, this is why you need to perform the export/import of the data via RDM.
Restoring the database on another name and establishing the connection to it via File -> Data Sources with the same username should allow you to get access to your data inside the Private Vault.
Best regards,
Jeff Dagenais