Qlik Sense : Create new connection to Google Analytic prompt error message - Error retrieving the URL to authenticate...

[elaineng]

Create New Connections > Google Analytic > Authenticate >

Error Message Prompt:

Account details
Status: Awaiting authentication...
Error retrieving the URL to authenticate: ENCRYPTION_KEY_MISSING - you must manually set an encryption key before creating new connections

I am running Qlik Sense client managed version

Version: Qlik Sense Aug 2022

Qlik Sense server 14.78.5

Steps which I had performed in Qlik server:

1) Generate Encryption Key:

Run Powershell with below script

/-----------------script -------------------------------/
# Generates a 32 character base 64 encoded string based on a random 24 byte encryption key
function Get-Base64EncodedEncryptionKey {
$bytes = new-object 'System.Byte[]' (24)
(new-object System.Security.Cryptography.RNGCryptoServiceProvider).GetBytes($bytes)
[System.Convert]::ToBase64String($bytes)
}

$key = Get-Base64EncodedEncryptionKey
Write-Output "Get-Base64EncodedEncryptionKey: ""${key}"", Length: $($key.Length)"

2) Set Encryption key into Qlik Server

Open command prompt:

1) cd C:\Program Files\Common Files\Qlik\Custom Data\QvWebStorageProviderConnectorPackage"

QvWebStorageProviderConnectorPackage.exe /key {key}

{key} generated from step 1

However, I still encounter the error after perform step 1 & 2.

[Nao_Baba]

Hi @elaineng ,

Is the encryption key you generated successfully set in C:\Users\{sense service user}\AppData\Roaming\Qlik\QwcKeys\?

If not, some parts are missing. See https://help.qlik.com/en-US/connectors/Content/Connectors_Home/Setting-encryption-key.htm?_ga=2.7543...

[NadiaB · Accepted solution]

Hi @elaineng 

The following article has step by step instructions to generate the key. 

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-Error-retri...

Kind Regards.