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.
After fresh installation or upgrade the User navigates to the Data Load Editor or Add and sees 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.
The main cause of this issue is related to the Data Load Editor and Add Data Wizard trying to Connect with the Connectors. When the connection can not be established it will time out and retry for about 20-30 times before it will fail completely - this when the connections are finally load or not loaded. It was identified that the Connectors having most trouble with establishing a connection to the Data Load Editor and Add Data Wizard are the Data Market and ODBC Connector Package. However it is not know why yet why the Connection can not be established in Restricted Environments.
In order the resolve this issue following workaround should be applied:
You can temporarily remove or move to a different folder (outside of Program Files) the OvOdbcConnectorPacakage and OvDataMarketConnector from the installation folder:
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.
After that you will not be able to use the Data Market Connector or the ODBC Pacakage. For ODBC connections you can use Native DSN.
If the problem still persists and the Data Connections can not be loaded you might have to:
1. Modify the machine config files for the Custom Data Connectors as specified in the following article:Data Connections not visible in the Data Load Editor in Qlik Sense 3.2 all SRs or later releases or Error 11041/11043
2. Upgrade to Qlik Sense September 2017 as in some specific cases the problem was caused by the Data Preparation Service not operating correctly in Restricted Environments.
3. Allow temporary internet access to the Environment - if possible.