Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

cancel
Showing results for 
Search instead for 
Did you mean: 
obriened83
Creator
Creator

Qlikview Reload Error (Net.Sockets.SocketException)

Hi

     I was wondering if some-one could help me explain this Qlikview Reload error that seems to happen nearly every day but at random times on our Qlikview Server (Please see below). I was wondering has anyone have a resolution for this issue. Thanks very mcuh.

Kind Regards

Eamonn

(Qlikview Failure Message)

Error      Exception=System.Net.Sockets.SocketException:
A connection attempt failed because the connected party did not properly
respond after a period of time, or established connection failed because
connected host has failed to respond

    at QlikTech.NetClient.QvClient.GetMessageDataFromSocket(Byte[] buffer, Double timeout)

   at QlikTech.NetClient.QvClient.GetMessageSizeFromSocket(Double timeout)

   at QlikTech.NetClient.QvClient.Execute(Byte[] request)

   at QlikTech.NetClient.QvClient.Execute(String request)

   at Wrappers.QVSWrapper.Ask(String question)

   at Wrappers.QVSWrapper.GetPhysicalPath(String documentName)

   at QDSMain.DistributeTask.InternalExecute(ILogBucket i_LogBucket, TaskResultcurrentTaskResult)

   at QDSMain.AbstractTask.InternalExecute2(ILogBucket i_LogBucket, TaskResult currentTaskResult)

1 Solution

Accepted Solutions
obriened83
Creator
Creator
Author

Hi

We believe that we may have found the issue with regard to this
problem.

The problem lies in our QlikView Application. I believe
that when a QlikView application passes a certain volume of data, the
application does not behave as it should.

In this instance, our application’s data structure is made up of
multiple tables. (please see below)

Qlikview Data Structure.jpg

When a user selects dimensions that represent different
granularities of data, for example selecting  BIR Flag in the Bet
Table
, Event in
the Selection Table, Affiliate Name in the Customer
Table
and a Date Time dimension, the issue described
below occurs. The solution
to this is to try and amalgamate the majority of these data
tables (Customer, Selection and Bet) in to 1 fact table.

If you have any queries I would be more than happy to help.
Thanks very much.

Kind Regards

Eamonn

View solution in original post

1 Reply
obriened83
Creator
Creator
Author

Hi

We believe that we may have found the issue with regard to this
problem.

The problem lies in our QlikView Application. I believe
that when a QlikView application passes a certain volume of data, the
application does not behave as it should.

In this instance, our application’s data structure is made up of
multiple tables. (please see below)

Qlikview Data Structure.jpg

When a user selects dimensions that represent different
granularities of data, for example selecting  BIR Flag in the Bet
Table
, Event in
the Selection Table, Affiliate Name in the Customer
Table
and a Date Time dimension, the issue described
below occurs. The solution
to this is to try and amalgamate the majority of these data
tables (Customer, Selection and Bet) in to 1 fact table.

If you have any queries I would be more than happy to help.
Thanks very much.

Kind Regards

Eamonn