Message: No Server – QV11 SR2

[rothtd]

We have been running our environment (unchanged) for about a year and started noticing that our users were getting the red ‘Message: No Server’ on access point. We do see error messages in the Web Server logs and are working through them. The QVMC shows no issues and lists both QVS’s as fully functional. Given that this issue started appearing for seemingly no reason I wanted to ask the community if they have experienced this before.

Do you know what (at a high level) causes this error? Is it a communication error between the Web Server and QVS? [they are on the same physical server in our environment]

Is it possible that we crossed some sort of threshold like number of applications or load on QVS? (our QVS is only using a quarter of its memory, and barely any CPU).

Is it possible that a Windows patch was applied to IIS or OS and is causing this issue?

The QVWS logging level is set to ‘high’ – could the added load account for this? The log files are split daily and are < 10MB in size.

Anyone deal with this before?

Environment:

3 physical servers Win Server 2008R2, 56GB, 64-bit

QV 11 SR2 (11414)

Server 1:  QVMS, QVDS, QV Directory Connector

Server 2: IIS, Directory Connector, QVS (clustered with Server 3)

Server 3: IIS, Directory Connector, QVS (clustered with Server 2)

Sample QVWS error lines:

4/22/2013 08:24:23.1782533  Error    QVClient.Execute failed

4/22/2013 08:24:23.1782533  Error    System.Threading.ThreadAbortException: Thread was being aborted.

   at QVSWrapper.QlikViewServer.ExecuteXml(Action`2 i_Logger, String i_Command)

   at QVSWrapper.QlikViewServer.GetAdminDocListForUser(Action`2 i_Logger, String i_UserName, eDocumentListType i_ListingType, eExtendedDocInfo extendedInfo, IEnumerable`1 i_Groups, Boolean GroupListIsNames)

   at QlikView.AccessPoint.FileScan.<>c__DisplayClass3.<ScanQlikViewServerClusters>b__0(IQlikViewServerWrapper qvs)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.FileScan.ScanQlikViewServerClusters(IEnumerable`1 servers, Action`2 logger, IUser user, Int32& liveQvsCount, Boolean respectBrowsable)

4/22/2013 08:29:52.2041806  Error    System.AggregateException: One or more errors occurred. ---> System.FormatException: Input string was not in a correct format.

   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)

   at QVSWrapper.QlikViewServer.GetServerStatus(Action`2 i_Logger, String& reason)

   at QlikView.AccessPoint.QlikviewServerSetting.<Ping>b__f(IQlikViewServerWrapper q)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.QlikviewServerSetting.Ping()

   at System.Threading.Tasks.Parallel.<>c__DisplayClassf`1.<ForWorker>b__c()

   at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)

   at System.Threading.Tasks.Task.<>c__DisplayClass7.<ExecuteSelfReplicating>b__6(Object )

   --- End of inner exception stack trace ---

   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)

   at System.Threading.Tasks.Task.Wait()

   at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally)

   at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)

   at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, Action`1 body)

   at QlikView.AccessPoint.QlikViewServerStatus.PingThread()

---> (Inner Exception #0) System.FormatException: Input string was not in a correct format.

   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)

   at QVSWrapper.QlikViewServer.GetServerStatus(Action`2 i_Logger, String& reason)

   at QlikView.AccessPoint.QlikviewServerSetting.<Ping>b__f(IQlikViewServerWrapper q)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.QlikviewServerSetting.Ping()

   at System.Threading.Tasks.Parallel.<>c__DisplayClassf`1.<ForWorker>b__c()

   at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)

   at System.Threading.Tasks.Task.<>c__DisplayClass7.<ExecuteSelfReplicating>b__6(Object )<---

Thanks in advance for any input!

[rothtd]

Update - Although we had been assured by a few individuals in our infrastructure team that virus scanning was not the issue, we found out today that real-time virus scanning was, in fact, enabled for our entire QlikView environment (including our .pgo files). Previous comments have indicated that this issue can be caused by virus scanning, so I am highly suspicious that this will be our issue. We have exempted specific file extensions from scanning, and are working on limiting the real-time scanning activities.

[rothtd]

Update – We have not had this error message since our memory heap change. If, in fact, the issue is resolved it would have been one of three things that fixed it:

1. Memory heap change
2. Upgrading old Plugin version to current version
3. Excluding QlikView directories and file extensions from anti-virus scans

As an interesting note after our memory heap change we noticed that our QVS servers were using much more memory. Prior to the change they seemed to be limited at using only about 30% of their memory, now they are using about 60%. The number isn’t 100% because our hardware is oversized for our environment, so we are only expecting to utilize about 60% of our memory.

- Trevor

[#4]

Here is an Update

We are now running our 3 nodes cluster without any warning or error for onne week now. We did the following further to QV support recommendations:

- Completely switched off antivirus

- Completely switched off windows firewall

- Installed  2008 R2 SP1

- Apply KB 2465772

We also plan to apply KB300956 as recommended by Qlikview support.

On medium term we have in mind to re-activate the antivirus without scan of the Qlikview folders, re-activate the windows firewall with proper ports opened and check if stability remains.

BR,

Olivier

[rothtd]

We still have not had the error message.

[rothtd]

Update:  We had the error late last week. We noticed that our QVS servers were consuming ~70% of their memory. A restart resolved the issue. This is the only known occurrence of this problem since our memory heap change. We have added these servers back to our weekly restart schedule.

[#7]

Hello,

Any updates about this issue ?? we are facing the same, we are using QV 11 SR2 for servers we are in cluster.

We still have the no server error message in the access point and in the event vienwer we have a warning related to ASP.NET 4.0.30319.0 Event ID 1309 code 3005   as below :

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 10/07/2013 12:55:04

Event time (UTC): 10/07/2013 10:55:04

Event ID: 80ae4b51c1ad468ebce79a285d068607

Event sequence: 7560

Event occurrence: 9

Event detail code: 0

Application information:

    Application domain: /LM/W3SVC/1/Root/QvAjaxZfc-1-130179157415015124

    Trust level: Full

    Application Virtual Path: /QvAjaxZfc

    Application Path: C:\Program Files\QlikView\Server\QlikViewClients\QlikViewAjax\

    Machine name: ourserver

Process information:

    Process ID: 11232

    Process name: w3wp.exe

    Account name: CORP\XXXXXXX

Exception information:

    Exception type: Exception

    Exception message: No data was returned from the QlikView Server. QVSMessageLength=1

   at QVSWrapper.QlikViewServer.GetDocumentThumbNail(Action`2 i_Logger, String Path)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.AccessPointHandler.ExecuteBinary(AccessPointContext context, String id)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Request information:

    Request URL: http://gbi.capgemini.com/QvAJAXZfc/AccessPoint.aspx?datamode=binary&name=QVSCluster@ourserver.comni.com/QvAJAXZfc/AccessPoint.aspx?datamode=binary&name=QVSCluster@ourserver.com|yyyyyyyyyyy.qvw&stamp=079c0ef4935b13e1a8e508d79d8cbba9&kind=AccessPoint

    Request path: /QvAJAXZfc/AccessPoint.aspx

    User host address: 10.68.126.138

    User: FRPARGBIP01\IUSR_T_WIN2003

    Is authenticated: True

    Authentication Type: dsame

    Thread account name: CORP\XXXXXXXX

Thread information:

    Thread ID: 79

    Thread account name: CORP\XXXXXXXX

    Is impersonating: False

    Stack trace:    at QVSWrapper.QlikViewServer.GetDocumentThumbNail(Action`2 i_Logger, String Path)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.AccessPointHandler.ExecuteBinary(AccessPointContext context, String id)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

[#8]

Hello,

Can you please help on this, we are facing the same issue, we are using QV 11 SR2 for servers we are in cluster.

We still have the no server error message in the access point and in the event vienwer we have a warning related to ASP.NET 4.0.30319.0 Event ID 1309 code 3005   as below :

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 10/07/2013 12:55:04

Event time (UTC): 10/07/2013 10:55:04

Event ID: 80ae4b51c1ad468ebce79a285d068607

Event sequence: 7560

Event occurrence: 9

Event detail code: 0

Application information:

    Application domain: /LM/W3SVC/1/Root/QvAjaxZfc-1-130179157415015124

    Trust level: Full

    Application Virtual Path: /QvAjaxZfc

    Application Path: C:\Program Files\QlikView\Server\QlikViewClients\QlikViewAjax\

    Machine name: ourserver

Process information:

    Process ID: 11232

    Process name: w3wp.exe

    Account name: CORP\XXXXXXX

Exception information:

    Exception type: Exception

    Exception message: No data was returned from the QlikView Server. QVSMessageLength=1

   at QVSWrapper.QlikViewServer.GetDocumentThumbNail(Action`2 i_Logger, String Path)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.AccessPointHandler.ExecuteBinary(AccessPointContext context, String id)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Request information:

    Request URL: http://gbi.capgemini.com/QvAJAXZfc/AccessPoint.aspx?datamode=binary&name=QVSCluster@ourserver.comni.com/QvAJAXZfc/AccessPoint.aspx?datamode=binary&name=QVSCluster@ourserver.com|yyyyyyyyyyy.qvw&stamp=079c0ef4935b13e1a8e508d79d8cbba9&kind=AccessPoint

    Request path: /QvAJAXZfc/AccessPoint.aspx

    User host address: XXXXXXXXX

    User: SERVERX\IUSRX

    Is authenticated: True

    Authentication Type: dsame

    Thread account name: XXXX\XXXXXXXX

Thread information:

    Thread ID: 79

    Thread account name: CORP\XXXXXXXX

    Is impersonating: False

    Stack trace:    at QVSWrapper.QlikViewServer.GetDocumentThumbNail(Action`2 i_Logger, String Path)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.AccessPointHandler.ExecuteBinary(AccessPointContext context, String id)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

[#9]

Hello,

Any updates about this issue ?? we are facing the same (no server ), we are using QV 11 SR2 for servers we are in cluster.

We still have the no server error message in the access point and in the event vienwer we have a warning related to ASP.NET 4.0.30319.0 Event ID 1309 code 3005   as below :

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 10/07/2013 12:55:04

Event time (UTC): 10/07/2013 10:55:04

Event ID: 80ae4b51c1ad468ebce79a285d068607

Event sequence: 7560

Event occurrence: 9

Event detail code: 0

Application information:

    Application domain: /LM/W3SVC/1/Root/QvAjaxZfc-1-130179157415015124

    Trust level: Full

    Application Virtual Path: /QvAjaxZfc

    Application Path: C:\Program Files\QlikView\Server\QlikViewClients\QlikViewAjax\

    Machine name: ourserver

Process information:

    Process ID: 11232

    Process name: w3wp.exe

    Account name: CORP\XXXXXXX

Exception information:

    Exception type: Exception

    Exception message: No data was returned from the QlikView Server. QVSMessageLength=1

   at QVSWrapper.QlikViewServer.GetDocumentThumbNail(Action`2 i_Logger, String Path)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.AccessPointHandler.ExecuteBinary(AccessPointContext context, String id)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Request information:

    Request URL: http://gbi.capgemini.com/QvAJAXZfc/AccessPoint.aspx?datamode=binary&name=QVSCluster@ourserver.comni.com/QvAJAXZfc/AccessPoint.aspx?datamode=binary&name=QVSCluster@ourserver.com|yyyyyyyyyyy.qvw&stamp=079c0ef4935b13e1a8e508d79d8cbba9&kind=AccessPoint

    Request path: /QvAJAXZfc/AccessPoint.aspx

    User host address: IPadress

    User: server\user

    Is authenticated: True

    Authentication Type: dsame

    Thread account name: CORP\XXXXXXXX

Thread information:

    Thread ID: 79

    Thread account name: CORP\XXXXXXXX

    Is impersonating: False

    Stack trace:    at QVSWrapper.QlikViewServer.GetDocumentThumbNail(Action`2 i_Logger, String Path)

   at QlikView.AccessPoint.QlikviewServerSetting.Try(Func`2 f, Func`1 fail)

   at QlikView.AccessPoint.AccessPointHandler.ExecuteBinary(AccessPointContext context, String id)

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.