Qlikview 11 No connection issue

[Harsh1]

Hi,

We are using QlikView 11 version and we integrated it with SharePoint envionment. Somehow, week ago we are having "No connection" issues. Whenever, a user tries to access the QlikView Report via Webpart, we are getting 'no connection' error. 

So far we have tried following suggested solutions :

-Restarted all QlikView Services

- Restarted all web server services

- Decreased Document Load percentages to lowest 60% to max 70%

- Checked server name (17 chars long) and also tried to replace it wtih IP address

- Renamed QlikTech folder and restarted QVS service. It created new QlikTech folder, however error is still there.

- RAM usage is 30% at the moment

- Disabled firewall and antivirus program

- Made some changes to Perfomance settings as well

Nothing worked so far.  We have checked logs, however they are not pointing to the root cause of the issue.

Any help regarding regarding the issue will be appreciated.

Thanks in Advance.

[marcus_sommer]

I assume that there were no significantly changes on the Qlik-side before the issue occurred. If so the issue isn't caused from Qlik else from any changes on the OS, network incl. group policies + firewalls, proxies, load-balancers, certificates and so on and of course SharePoint itself. Any changed configurations or updates may prevent the connection. Therefore I suggest to investigate if there were any known changes. Also taking a look within the various log-files from Qlik and OS is often helpful.

Beside this QlikView 11 is not supported anymore ...

- Marcus 

[Harsh1]

Hi Marcus,

Thanks for your replay. We are aware that the Qlikview 11 is out of support. However, our system is still using it and it is quite critical to our clients. We have restarted whole farm including QlikView Servers. OS, Firewall, Network and load balancers are not the issue as we have checked and tested all of them. However, distribution services is not starting and it is throwing .COMException (0x80080005) errors. We tried all suggested web solutions for it. However, it is still the same. 

[marcus_sommer]

It's not quite clear for me which issues you have. Your last description sounds different to your origin posting. I hope you haven't changed much within all the settings - at least nothing what you couldn't revert because with changed configurations you may create new issues without having solved the causing ones. Important is to see at first what worked and not to touch these and then to exclude step by step all thinkable reasons by the not working ones. 

Like above hinted it's really seldom that something within Qlik breaks. But it could happens by a high workload on the system that Qlik processes couldn't finish their tasks because they run into any timeout or they might be terminated by any other process and setting-files may become invalid.

Usually are the various log-files a great help and if they couldn't provide enough hints to the real reason you should consider to restore the system or to apply a backup of the Qlik settings. In regard to the issue with the distribution service take the two following links (and the links within them) as starting point for further investigations:

QlikView Distribution Service error on start-up 10... - Qlik Community - 1712527

How to increase and how many reload engines (QVB) ... - Qlik Community - 1714967

- Marcus

[Daniele_Purrone]

Hi @Harsh1 ,
I would suggest checking this article first.
I would also go through the setup as documented in this PDF.

I hope this helps!

[Harsh1 · Accepted solution]

Thank you @Daniele_Purrone  and @marcus_sommer for your help. 

So, the fix was restoring the config file of "QlikView Web Server" in one of the SharePoint web front-end servers.

The weird part is that we checked the whole config file during troubleshooting. When the issue got fixed, we compared the config files and the only change was at host tag. It has "local" value instead of QVS name. This does not make sense as one of the reports were accessible even when the change was in place. However, the main report was not accessible.   

[NadiaB]

Hi @Harsh1 

The version of QV is on your environment is a little old, it is suggested to consider an upgrade:

QlikView Product Lifecycle 

https://community.qlik.com/t5/Product-Lifecycle/QlikView-Product-Lifecycle/ta-p/1826339

Kind Regards.