Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW

Data Connections Pane in Qlik Sense Hub not loading

cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data Connections Pane in Qlik Sense Hub not loading

Note that in October 2022, a set of Microsoft patches interfered with SSL handshakes. See Qlik Sense Enterprise on Windows: Internal Error while accessing Data Load Editor, Data Manager, and... for details.

The Qlik Sense Data Manager and Data Connection does not load when opening the Data Load Editor or Add Data Wizard. The Qlik Sense hub does not load a data connection or takes too long to load it.

This issue happens predominantly in Deployments within Environments with restricted Internet access. The workaround is to remove the Custom Data Connectors from the installation folder.

Other symptoms might include:

  • ErrorCode.11041 occurs when opening up an App
  • ErrorCode.11043 occurs when creating a Database connection in the data load editor.

 

After fresh installation or upgrade the User navigates to the Data Load Editor or Add and sees the following:

 

User-added image
 

And the Data Connection List is empty and the loading wheel is spinning indefinitely:

 

User-added image
 

In Add Data Wizard following can be observed:

 

User-added image
 



In most cases depending on the environment the Data Connections will eventually load after 10 to 30 minutes of waiting. However this not an ideal solution as the connections have to be loaded every time when the Data Load Editor or Add Data Wizard are accessed.

 

Cause

Qlik connectors are cryptographically signed for authenticity verification. The .NET framework verification procedure used for this signing includes checking OCSP and Certificate Revocation List information, which are fetched from a online resource if the system doesn't have a cached local copy. These requests will timeout due to lack of access to online resource in environments with restricted, slow or no internet connection. Due to authenticity check failure the connector will not run, and the app reload fails.

 

Resolution

Verify if your system is affected by Microsoft patches interfering with SSL handshakes. See Qlik Sense Enterprise on Windows: Internal Error while accessing Data Load Editor, Data Manager, and....

If you are not affected by the SSL handshake issue, proceed with one of the below workarounds.

 

Workaround 1

Follow the instructions ad documented in An error occurred / Failed to load connection error message in Qlik Sense - Server Has No Internet 

 

Workaround 2

Enable internet access. 

Alternatively, using a third-party tool such as Fiddler or inbuilt browser debug tools, identify the addresses used and add them to allow lists on firewalls/proxies otherwise blocking internet traffic. 

 

Workaround 3

Temporarily move the following files outside of Program Files:

  • OvOdbcConnectorPacakage and OvDataMarketConnector 

Files can be found in: C:\Program Files\Common Files\Qlik\Custom Data

In a multi node environment please do it for all the nodes. You can as well try removing only the OvOdbcConnectorPacakage as the OvDataMarketConnector does not always fail. 

Note that when moving the files, you will not be able to use the Data Market Connector or the ODBC Pacakage. 

Labels (2)
Comments
jaishree_Qlik
Partner - Contributor III
Partner - Contributor III

Thanks Flippo,

 

This is informative as I was not passing the correct values in run time tag. Issue is resolved. Infact on top it issue was that TLS 1.0 and 1.1 was activated then administrator deactivated it.

Issue is resolved now.

 

PhilipMertin
Partner - Contributor III
Partner - Contributor III

I was able to solve this problem in conjunction with this article:

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

 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @PhilipMertin 

Thank you for letting us know! I've added the article as a possible solution in this one.

All the best,
Sonja 

Version history
Last update:
3 weeks ago
Updated by:
Contributors