topic Re: Keep disconnecting when using plugin in QlikView

Keep disconnecting when using plugin

Mon, 19 Nov 2012 16:14:57 GMT

Hi,

Is this a bug or some parameter to be set on server?

When i'm connecting via plugin, i keep disconnecting in very short interval also i set time out at 60 mins.

I'm on V11 SR1

what could it be?

Re: Keep disconnecting when using plugin

rwunderlich — Mon, 19 Nov 2012 19:45:33 GMT

Look in the event log on the server to find the disconnect reason. Common reasons are:

- Same userid in use on another machine.

- Document reloaded.

-Rob

Re: Keep disconnecting when using plugin

Tue, 20 Nov 2012 10:04:42 GMT

Hi Rob,

thanks for the tips, normally it happens to end users.

and most of the time we are using session lic and i open all of them.

Document reloaded, unlikely for my case.

One other thing i notice when it happens is that QVS.exe is using almost full CPU.

and so i restart the services and refresh the browser.

Do you think of any other causes?

Thanks.

Re: Keep disconnecting when using plugin

Tue, 20 Nov 2012 15:27:11 GMT

Here is from the server event log.

" The QlikView Server service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 10 milliseconds: Restart the service. "

Re: Keep disconnecting when using plugin

rwunderlich — Tue, 20 Nov 2012 17:03:28 GMT

My guess is the that disconnect is from the server timing out when your server goes non-responsive. It could be that your server is underpowered or you have a runaway task.

-Rob

Re: Keep disconnecting when using plugin

Wed, 21 Nov 2012 08:09:42 GMT

Hi Rob,

I'm on x64, 24-core, 64GB RAM.

Is there a way to avoid it?

If i have to improve the hardware, which one do i start? RAM? CPU? Both?

The thing is, when the disconnection happen, i have no task running on the server, it was just few users connecting.

Could it be the user's PC? wifi or LAN or the plugin ?

Re: Keep disconnecting when using plugin

rwunderlich — Wed, 21 Nov 2012 17:06:53 GMT

Hard to say from a distance.

My first step would be to profile what the load is when the failure happens. I'd recommend setting your performance logging to 5 minutes so you can track how many documents are loaded and the RAM usage.

How many documents are loaded and how many user sessions are active when the failure occurs? Check the event log for document loads to see if the failure occurs after a specific document is loaded. You can also turn on audit logging to see if a specific activity preceeds the failure.

-Rob

Re: Keep disconnecting when using plugin

rwunderlich — Wed, 21 Nov 2012 17:14:52 GMT

I note this thread which may be of interest

http://community.qlik.com/thread/52326?tstart=0

-Rob

Re: Keep disconnecting when using plugin

Thu, 22 Nov 2012 09:50:37 GMT

Thanks Rob for the tips, i will have a look into.

Re: Keep disconnecting when using plugin

stevedark — Wed, 28 Nov 2012 13:39:21 GMT

Did you find a resolution for this Nick - I am getting the same message in my event log:

The QlikView Server service terminated unexpectedly. It has done this 2 time(s). The following corrective action will be taken in 10 milliseconds: Restart the service.

This is after an upgrade from QV10 to QV 11 SR2 Update 1.

Steve

Re: Keep disconnecting when using plugin

stevedark — Wed, 28 Nov 2012 15:16:39 GMT

I've managed to get this working by using QV11 SR2 instead of the update. I shall raise this with QlikTech support.

Steve

Re: Keep disconnecting when using plugin

Fri, 30 Nov 2012 10:51:12 GMT

Hi Steve,

I got the confirmation the patch is ready.

it's said to fix defect case 00142309.

But i have no info about this case.

If you have the info, could you share here?

This released is built on SR2, build: 11440.

Could you also try it out?

I will update the status here after i deploy it in production.

Thanks.

Re: Keep disconnecting when using plugin

stevedark — Fri, 30 Nov 2012 11:41:18 GMT

Hi Nick,

I have no more information at this time - but I have raised the issue with QlikTech, so will happily share what they come back with. I noted that Update 2 is now available - but I am not going to be able to apply that release at that client site to test it.

Would be interested in hearing how you get on with it though.

-Steve

Re: Keep disconnecting when using plugin

stevedark — Fri, 30 Nov 2012 13:57:10 GMT

Nick - I've had a call from QlikTech. They confirm that the Update 2 should fix the issues I was having also and that they strongly reccomended upgrading.

Incidentally, the number you quoted doesn't look like an issue number though - rather your personal support case number (mine was a few higher than yours).

Hope not too many people fell foul of this one, Update 1 was only available for a couple of weeks, so hopefully not.

Steve

Re: Keep disconnecting when using plugin

Fri, 30 Nov 2012 15:14:22 GMT

Steve, thanks for the confirmation.

I think you are right, should be a ticket, as i am just QT customer. i don't get support directly from them.

Anyway, I am going to test the release.

but i found this -http://community.qlik.com/message/286861#286861

real demotivating.

I wont be able to provide update maybe until Jan, as we are doing WW deployment, and dec, due to xmas, some holidays here and there.

I keep you posted.