article Data Connections Pane in Qlik Sense Hub not loading in Official Support Articles

Data Connections Pane in Qlik Sense Hub not loading

Anonymous — Tue, 08 Nov 2022 13:26:58 GMT

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 creating a new App 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:

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

In Add Data Wizard following can be observed:

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 creating a new App.

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.

Re: Data Connections Pane in Qlik Sense Hub not loading

vegard_bakke — Mon, 24 Aug 2020 14:42:14 GMT

Any updates on this?

I have a April 2020 version of Qlik Sense, still with the same problem.

The websosocket returns the connection information.
They just don't show up in the browser.

Re: Data Connections Pane in Qlik Sense Hub not loading

Sonja_Bauernfeind — Tue, 25 Aug 2020 11:26:02 GMT

Hello @vegard_bakke !

Do the workaround listed in this article help you resolve the issue? If not, it may be worth posting about this on our Deployment forum or investigating with support.

Re: Data Connections Pane in Qlik Sense Hub not loading

vegard_bakke — Tue, 25 Aug 2020 15:20:53 GMT

Since the information is received by the browser, I don't see why I should have to remove anything from the server. It looks like a client side problem. So no I have not tried those workarounds.

However, I might have found the cause. I used the URL with the virtual proxy that was not for 'Developer' nodes. But again, I thing it is a weird client side problem. The only way Qlik is telling me that I cannot edit the load script using this node, is by not displaying the Data connections that already have been received by the browser.

Re: Data Connections Pane in Qlik Sense Hub not loading

Filippo_Nicolussi_P — Tue, 29 Sep 2020 14:56:01 GMT

Hello @vegard_bakke

I see you mention April 2020 , be sure to be at least on SR3 or above.

Best regards

Filippo N.

Re: Data Connections Pane in Qlik Sense Hub not loading

Qlikstu — Mon, 25 Jan 2021 12:48:33 GMT

If the server has limited internet access (by design) - does anybody know the URL's to add to the whitelist?

Thanks

Stu

Re: Data Connections Pane in Qlik Sense Hub not loading

Jay_Brown — Tue, 26 Jan 2021 15:51:20 GMT

Hello @Qlikstu , I'm not sure this can be fixed by using an allow list. There is some additional information around a .Net bug here that may help:
https://community.qlik.com/t5/Support-Knowledge-Base/An-error-occurred-Failed-to-load-connection-error-message-in/ta-p/1714051?_ga=2.143327925.1061738828.1595249736-76432523.1586806923&_gac=1.95103598.1595021645.CjwKCAjwmMX4BRAAEiwA-zM4JsVBolUZjxut-t9F5hYxIc7KmG5xgvMLaZwCEJNIWc_sX9MW0hQwCBoCbRkQAvD_BwE

There is a global setting, as well as a per-connector configuration. I would test that out and see if it resolves your issue.

Re: Data Connections Pane in Qlik Sense Hub not loading

jaishree_Qlik — Wed, 10 Nov 2021 13:49:58 GMT

While trying to modify machine.config getting MMC Snap In error and also Repository services are not getting up and running .

On reverting the changes it working absolutely back to previous state. Is there any way to modify the file ?

Re: Data Connections Pane in Qlik Sense Hub not loading

Filippo_Nicolussi_P — Fri, 12 Nov 2021 15:15:53 GMT

Hi @jaishree_Qlik

You should check to apply only option 1 or only option 2 from the article .

In case you apply Option 2 in the global machine.config , if you face issues on other programs not starting or failing you need to check that the same option is not present in the related .exe.config .

Re: Data Connections Pane in Qlik Sense Hub not loading

jaishree_Qlik — Mon, 15 Nov 2021 11:16:52 GMT

I have opted only option 1 : 3a on TEST Environment and Option1: 3 c in Client Environment using notepad made the changes . But moment I am making the changes its throwing MMC Snap in Error in windows.

Re: Data Connections Pane in Qlik Sense Hub not loading

Filippo_Nicolussi_P — Tue, 16 Nov 2021 23:51:45 GMT

HI @jaishree_Qlik

In case of Option1: 3C be sure there are only entries expected for example reference could be found here <runtime> Element | Microsoft Docs .

Re: Data Connections Pane in Qlik Sense Hub not loading

jaishree_Qlik — Wed, 17 Nov 2021 08:52:29 GMT

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.

Re: Data Connections Pane in Qlik Sense Hub not loading

PhilipMertin — Mon, 07 Nov 2022 08:11:18 GMT

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-Error-while-accessing/ta-p/1993256

Re: Data Connections Pane in Qlik Sense Hub not loading

Sonja_Bauernfeind — Tue, 08 Nov 2022 13:52:36 GMT

Hello @PhilipMertin

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

All the best,
Sonja

Re: Data Connections Pane in Qlik Sense Hub not loading

hanna_choi — Fri, 08 Sep 2023 08:08:57 GMT

Hello

We are working with Qlik Sense Aug 2022 Patch1.

Today, we meet the problem that "not display data connector list"

1. We are working in closed network environments.

2. The problem took place that "Data Connections Pane in Qlik Sense Hub not loading"

3. We had reflected "workaround 1".

4. The data connector has encountered an issue

We're looking at a similar below image.

What can I do to solve this problem?

Best Regard

hanna.choi

Re: Data Connections Pane in Qlik Sense Hub not loading

jaishree_Qlik — Fri, 08 Sep 2023 08:12:39 GMT

Did you referred link mentioned on post for validating security patches from Microsoft ?

Microsoft has identified the root cause to be KB5018419 and resolved the issue in KB5020436 (Windows Server 2022) KB5020438 (Windows 10 Enterprise 2019), KB5018457 (Windows Server 2012), KB5020447 (Windows Windows 8.1 and Server 2012 R2), and KB5020439 (Windows 10, Windows Server 2016)

Qlik Sense Enterprise on Windows: Internal Error w... - Qlik Community - 1993256

Re: Data Connections Pane in Qlik Sense Hub not loading

brunoeroliveira — Fri, 08 Mar 2024 12:14:30 GMT

If your data connections folder is there, this solution won't work.

In my case, after reseting the service user password, all my connections crashed.

I tried almost everything, read every article but didn't found a solution for my case.

Only when I created another user, give adm rights on windows and changed the services to run with this new adm user it worked for me.

So I'm here to spread the word.