Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jan 27, 2022 10:11:49 AM
Jan 25, 2022 4:37:52 PM
Qlik Sense - Data encryption functionality to encrypt sensitive data in QVF and QVD files doesn't seem to work. QVF is not getting encrypted
Qlik Sense Enterprise on Windows
The problem seems to be that Repository is responding back with wrong settings. Qvf/Qvd encryption is not enabled + the thumbprint is blank. Therefore Engine won't start encrypting the Qvf files.
From rest.rec the response is null. It is because the ID of the the remaining record in ServiceClusterSettingsEncryptions table does match the main ID of ServiceClusterSettings
======================GENERAL --------------------------------------------------------------------
Server Name : Repository API REST Server
Request Method : GET
Request URL : https://QServer1.bhi.local:4242/qrs/servicecluster/encryption?xrfkey=ichBinEinBerlinR
Status Code : 200 OK
Request Id : 4eb60d1c-675e-4b70-acf4-dd3cf0b22b26
Request Arrival Time : 2021-11-17 15:53:33.102168Z
Request Handle Time : 2021-11-17 15:53:33.103168Z
Response Serve Time : 2021-11-17 15:53:33.112184Z
Total Time : 00:00:00.0100160REQUEST HEADERS ------------------------------------------------------------
X-Qlik-User : UserDirectory=INTERNAL; UserId=sa_engine
X-Qlik-XrfKey : ichBinEinBerlinR
Connection : Keep-Alive
Content-Type : application/json
Accept : application/json
Accept-Charset : utf-8
Host : QServer1.bhi.local:4242
User-Agent : QlikViewRESPONSE BODY --------------------------------------------------------------
Length : 300
Content : {"id":"2e9f1177-be62-4945-9a19-c9b61b469d57","createdDate":"2016-12-22T15:48:03.909Z","modifiedDate":"2020-11-18T22:00:02.256Z","modifiedByUserName":"INTERNAL\\bootstrap","enableEncryptQvf":false,"enableEncryptQvd":false,"encryptionKeyThumbprint":"","schemaPath":"ServiceCluster.Settings.Encryption"}RESPONSE HEADERS -----------------------------------------------------------
Date : Wed, 17 Nov 2021 15:53:33 GMT
Cache-Control : private, must-revalidate, max-age=0
Expires : Wed, 17 Nov 2021 15:53:33 GMT
Content-Type : application/json; charset=utf-8
Transfer-Encoding : chunkedREST -----------------------------------------------------------------------
Id : cd867ecb-bece-4aee-a166-dece3cdd7aa0
URI Template : /qrs/servicecluster/encryption
Method Full Name : Repository.Core.Resource.IServiceClusterResource.GetEncryption
Request Body Is File : False
Response Body Is File : False
Is Public : False
=================================
SELECT DISTINCT("ServiceCluster_ID") FROM "ServerNodeConfigurations" as "ServiceCluster_ID";
SELECT * FROM public."ServiceClusters";
SELECT * FROM public."ServiceClusterSettings";
SELECT * FROM public."ServiceClusterSettingsDbCredentials";
SELECT * FROM public."ServiceClusterSettingsEncryptions";
SELECT * FROM public."ServiceClusterSettingsSharedPersistenceProperties";
DELETE FROM "ServiceClusters"
WHERE "ID" NOT IN (SELECT DISTINCT("ServiceCluster_ID") FROM "ServerNodeConfigurations" as "ServiceCluster_ID");