Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Qlik Sense - Data encryption functionality to encrypt sensitive data in QVF and QVD files doesn't seem to work. QVF is not getting encrypted

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
PadmaPriya
Support
Support

Qlik Sense - Data encryption functionality to encrypt sensitive data in QVF and QVD files doesn't seem to work. QVF is not getting encrypted

Last Update:

Jan 27, 2022 10:11:49 AM

Updated By:

Sonja_Bauernfeind

Created date:

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

 

Environment:

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

=================================

 

 

Resolution:

 

  1. Identify ID of the ServiceCluster in use - one record should be returned:

    SELECT DISTINCT("ServiceCluster_ID") FROM "ServerNodeConfigurations" as "ServiceCluster_ID";​


  2. Check ServiceClusters data - OK if one record is returned from each query, with an ID from step 1. If more records, proceed to next step.

    SELECT * FROM public."ServiceClusters";
    SELECT * FROM public."ServiceClusterSettings";
    SELECT * FROM public."ServiceClusterSettingsDbCredentials";
    SELECT * FROM public."ServiceClusterSettingsEncryptions";
    SELECT * FROM public."ServiceClusterSettingsSharedPersistenceProperties";


  3. Run following - removes redundant entries from all tables above:

    DELETE FROM "ServiceClusters" 
    WHERE "ID" NOT IN (SELECT DISTINCT("ServiceCluster_ID") FROM "ServerNodeConfigurations" as "ServiceCluster_ID");​


  4. Verify tables from step 2 - each should contain one record with an ID from step 1.
  5. In QMC verify "Service cluster" section - if needed update using available UI or QlikSenseUtil.exe if "Cluster Settings" section is missing paths.
Labels (1)
Version history
Last update:
‎2022-01-27 10:11 AM
Updated by: