topic Re: Data Connections in Qlik Sense Hub not loading in Management & Governance

Data Connections in Qlik Sense Hub not loading

vighnesh_gawad — Sun, 29 Oct 2023 14:26:18 GMT

Hi Guys,

My setup is Windows server where Qlik sense (May 2023) is, has internet access and we need to connect to Company's VPN to access Qlik sense server.

PFA, I am getting this error while I opened Data load editor each time. It takes 5-10 minutes to load data connections and after that some connections doesn't appear eg. OneDrive, GDrive etc.

I tried solutions from these articles.

https://community.qlik.com/t5/Official-Support-Articles/Data-Connections-Pane-in-Qlik-Sense-Hub-not-loading/ta-p/1717235

https://community.qlik.com/t5/Official-Support-Articles/An-error-occurred-Failed-to-load-connection-error-message-in/ta-p/1714051

but still error doesn't resolved. Data connections keep loading very slowly.

Is there any other workaround this ? Thanks

Re: Data Connections in Qlik Sense Hub not loading

HeshamKhja1 — Mon, 30 Oct 2023 06:21:11 GMT

Hi @vighnesh_gawad ,

This might be because one or more connections are taking too long to be functional that they are causing the data connections to take too long.

If you connect to Qlik Sense from the localhost (from server directly), do you get the same issue?

If yes, then it is not related to the VPN and you better check the connections created and see which one is causing the issue.

Re: Data Connections in Qlik Sense Hub not loading

vighnesh_gawad — Mon, 30 Oct 2023 06:44:43 GMT

Hi @HeshamKhja1 ,

thanks for response.

I just checked with localhost , And yes I still get same issue.

>> If yes, then it is not related to the VPN and you better check the connections created and see which one is causing the issue.

How do I check this?

edit:

also certain connectors are not visible while loading is finish. eg. Onedrive, GDrive etc.

Re: Data Connections in Qlik Sense Hub not loading

HeshamKhja1 — Mon, 30 Oct 2023 07:16:15 GMT

If any of the data connection show errors then these are the first to look at.

also as you mentioned

also certain connectors are not visible while loading is finish. eg. Onedrive, GDrive etc.

then maybe these are the connections that are causing the issue.

If you are root admin, then make sure you have access to these connections, then see if they are functional. Try to recreate them and see what errors you get.

Additionally, check the logs of the connectors. You can find the paths here: https://community.qlik.com/t5/Qlik-Fix/Qlik-Fix-How-to-Find-Qlik-Connector-Logs/ta-p/1762915

See what errors they are giving.

Re: Data Connections in Qlik Sense Hub not loading

vighnesh_gawad — Tue, 31 Oct 2023 04:09:08 GMT

Hi,

I checked connectors log.

I am seeing below error log in both WebConnectorPackage and WebConnectorStorageProviderPackage.

Not sure how to move forward from this:

30 Oct 2023 16:44:44,365 [1] - INFO - PipeName=command_2d9f7100067aec4cbe251763474f2896204b412c Source=QWC ReloadId=NA TenantId=NA UserIdType=NA UserId=NA EngineSessionId=NA AppId=NA RequestGuid=NA ConnectorId=NA Sender=IntegratedConnectorSettings Message=Created IntegratedConnectorSettings from embedded resource.
30 Oct 2023 16:44:44,442 [1] - ERROR - PipeName=command_2d9f7100067aec4cbe251763474f2896204b412c Source=QWC ReloadId=NA TenantId=NA UserIdType=NA UserId=NA EngineSessionId=NA AppId=NA RequestGuid=NA ConnectorId=NA Sender=Program Message=Unhandled exception.
APIConnectorInterfaces.Exceptions.QwcException: Could not get key with id prefix 'qseow_tmp' ---> System.Security.Cryptography.CryptographicException: Key not valid for use in specified state.

at System.Security.Cryptography.ProtectedData.Unprotect(Byte[] encryptedData, Byte[] optionalEntropy, DataProtectionScope scope)
at Qlik.Connectors.WebPackage.Startup.KeyProvider.ReadKey(String keyFilePath, Byte[] entropy)
at Qlik.Connectors.WebPackage.Startup.KeyProvider.GetKeyInternal(Boolean autoCreate)
--- End of inner exception stack trace ---
at Qlik.Connectors.WebPackage.Startup.KeyProvider.GetKeyInternal(Boolean autoCreate)
at QvWebConnectorPackage.Startup.ProductServices_QSEoW.Init(KeyState keyState, Boolean isWebStorageProvider)
at QvWebConnectorPackage.Program.Main(String[] args)

Re: Data Connections in Qlik Sense Hub not loading

vighnesh_gawad — Wed, 01 Nov 2023 05:43:00 GMT

So I found solution. Because connections are not working. I need to recreate encryption key for those connectors.

Re: Data Connections in Qlik Sense Hub not loading

brunoeroliveira — Fri, 08 Mar 2024 12:15:35 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.