Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
obriened83
Contributor

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
Contributor

Re: Qlikview Reload Error (Net.Sockets.SocketException)

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

1 Reply
obriened83
Contributor

Re: Qlikview Reload Error (Net.Sockets.SocketException)

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

Community Browser