topic Re: Data Connection Spinning - Not working in Connectivity & Data Prep

Data Connection Spinning - Not working

Thu, 06 Jul 2017 15:47:13 GMT

Qlik Sense Desktop when going to Data Connections it just spins. If I select Create New Connection a blank bar shows up no connection options. I am unable to bring data into the script.

HELP!!

Re: Data Connection Spinning - Not working

RenzoH — Tue, 11 Jul 2017 14:30:20 GMT

I'm having the same issue after upgrading to Qlik Sense June 2017, did you fixed it?

Re: Data Connection Spinning - Not working

ckchouk123 — Fri, 21 Jul 2017 19:23:56 GMT

1.        Stop all QS services on all nodes
2.        Edit C:\Windows\Microsoft.NET\Framework64\v4.0.30319\config\machine.config
3.        Change (or add) the <runtime/> tag to reflect:
<runtime>
   <generatePublisherEvidence enabled="false"/>
</runtime>
4.        Start all the services & test

Re: Data Connection Spinning - Not working

johnnymartinez — Thu, 10 Aug 2017 09:44:07 GMT

ckchouk123‌ - I had forwarded this onto our IT dept to see if it'd solve us having the same issue - however now it's not connecting at all to the qlik server.

Is it a good idea to restart the server again after this?

Re: Data Connection Spinning - Not working

tcarolus — Fri, 11 Aug 2017 13:14:22 GMT

Are you using IE as your browser? If so, try Chrome instead.

Re: Data Connection Spinning - Not working

HarishG — Thu, 17 Aug 2017 06:40:16 GMT

Anyone solved this issue, i'm stuck with the same issue since i have upgraded to June 2017 release. One thing i have observed is, once you restart the 'Qlik Sense Service Dispatcher' the data connection would show up in a minute. However, if you try to open another app, the issue is still the same & connections will @show up after 20 minutes, as it gets TimeOut as shown below.

Much appreciated if someone gives the solution. Thank you.

Re: Data Connection Spinning - Not working

ncternal — Thu, 19 Oct 2017 14:29:10 GMT

For organizations that support thousands of users, this is not a viable solution. With many BI tools that work perfectly fine in IE, it creates a bad perception if you have to tell your organization that this BI software doesn't work on one of the largest browser platforms.

Re: Data Connection Spinning - Not working

ncternal — Thu, 19 Oct 2017 14:34:54 GMT

This did fix the issue prior to June 2017. The issue has come back, after upgrading to June 2017.

Re: Data Connection Spinning - Not working

tcarolus — Fri, 20 Oct 2017 08:17:48 GMT

Hi Thomas,

I agree with you since Qlik supports IE.

But my comment was just to indicate that using Chrome may solve the problem for the moment in need.

Re: Data Connection Spinning - Not working

avkeep01 — Mon, 30 Oct 2017 08:56:38 GMT

I fixed this issue by using a different browser then IE. Which just fixes the symptoms not the real issue

Re: Data Connection Spinning - Not working

HarishG — Mon, 30 Oct 2017 09:04:52 GMT

This issue can be solved using below given method,

Go to "C:\Program Files\Common Files\Qlik\Custom Data". You will see folders like QvDataMarketConnector, QvOdbcConnectorPackage, QvRestConnector and QvSalesforceConnector. Inside each folder there would be a config file.

Eg: C:\Program Files\Common Files\Qlik\Custom Data\QvRestConnector\QvRestConnector.exe.config.

Edit config file and add below code just before closing </configuration> tag.

</runtime>

Save file and do the same with all the connectors. Make sure to stop services before making any changes.

Re: Data Connection Spinning - Not working

Anonymous — Fri, 20 Apr 2018 18:24:22 GMT

I have this same problem; it seems to be intermittent also. I've tried all of the options listed above to no avail.

Can I please get contacted by Qlik to review this?

It would be nice to know where the list of Data Connections loads from and what could possibly impact the proper loading of the connections list...

Re: Data Connection Spinning - Not working

amien — Wed, 13 Jun 2018 22:23:31 GMT

Anyone got a solution for this? Latest version still has this issue

Re: Data Connection Spinning - Not working

Anonymous — Thu, 14 Jun 2018 13:13:36 GMT

I don't think there's a fix yet.

I'm really getting sick of two things with Qlik: 1) bugs like this that go unanswered and 2) a general feeling of not having a way to report problems to them directly. Posting concerns on this forum does not guarantee that they have heard about these issues.

Re: Data Connection Spinning - Not working

Anonymous — Thu, 14 Jun 2018 13:15:17 GMT

Dude, the original poster's first three words were "Qlik Sense Desktop." This isn't a complaint about the web server.

Re: Data Connection Spinning - Not working

raoulis_dimitris — Mon, 30 Jul 2018 13:04:07 GMT

Hi all,

We had same problem of slow rendering sheet and slow showing of connections after upgrading to june 2018 server.

Specifically in google chrome :

Open the app with the Google Chrome
Open the Inspect Element menu (Ctrl + Shift + I)
Select the Network tab
Reload the page
In the menu bellow the Network tab it must be selected the All option
Right click at the list at the bottom of the menu and select the “Save as HAR with content” option

As you can see these errors are referinig connectors: QvOdbcConnectorPackage, the Essbase Connector, the
QvDataMarketConnector and the Qlik Rest Connector are the components who are responsible for the slow response from server.

After removing these folders, we had no issues with our app which is not using these connectors but now we have no problems with license monitor app which needs these connections to reload.

Please advise!

Re: Data Connection Spinning - Not working

vnelsoncrunch — Wed, 08 Aug 2018 23:12:38 GMT

I was seeing this intermittently on desktop and server and today the connection went completely down.

My situation was using an ODBC driver for MS .xlsx imports.

Tried the solutions above for <runtime> and it did not work and also resulted in not being able to start the services back up on Sense Server June 2018.

For Desktop what I found that worked was to go into ODBC drivers, select the driver and under options change to Read Only. Right after that, the connection was found immediately and the script ran.

I moved the app to my laptop and found the same issue. Not sure why it worked, began to work intermittently and then completely failed to run starting today. On a side note, I started having connection issues when I loaded June 2018 and the problem continued even after downgrading.

Re: Data Connection Spinning - Not working

lvalencia_psa — Mon, 20 Aug 2018 18:04:42 GMT

Hello,

I recently upgraded to Qlik Sense Desktop June 2018 and when creating a new app I am seeing the same spinning wheel "initializing add data". I am on Windows 7 Pro - 64bit. Is there an official fix to this yet?

Re: Data Connection Spinning - Not working

lvalencia_psa — Tue, 21 Aug 2018 21:25:44 GMT

** Update** After deleting the Source Data folder, and still not working, I opted for Uninstalling and reinstalling Qlik Sense June 2018 edition and it the data connection page is no longer hanging.

Just an FYI.

Re: Data Connection Spinning - Not working

amien — Fri, 14 Sep 2018 07:30:02 GMT

I did that too. But after a few days it did come back again.

This really is an issue a quite some version. Dont understand why this is still an issue.

Someone has a solid solution?