1 Reply Latest reply: May 12, 2013 9:32 AM by Eamonn O'Brien RSS

    Qlikview Reload Error (Net.Sockets.SocketException)

    Eamonn O'Brien



           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



      (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)

        • Re: Qlikview Reload Error (Net.Sockets.SocketException)
          Eamonn O'Brien



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



          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
          , Event in
          the Selection Table, Affiliate Name in the Customer
          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