Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
elaineng
Contributor III
Contributor III

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

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.

Labels (1)
1 Solution

Accepted Solutions
NadiaB
Support
Support

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. 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm

View solution in original post

2 Replies
Nao_Baba
Support
Support

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
Support
Support

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. 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm