4 Replies Latest reply: Jun 5, 2013 8:24 AM by Eamonn O'Brien RSS

    Qlikview Server Hangs And Then Is Forced To Restart

    Eamonn O'Brien

      Hi

       

      We are having an issue where the Qlikview Server hangs and then is forced to restart.

      During the 10-15 minutes of hanging, the Server CPUs goes crazy.

      Also we get an error message if an application is reloading stating the following:

       

      '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'

       

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

       

      Our application’s data structure is made up of
      multiple tables. (please see below)

      Qlikview Data Structure.jpg

       

      I can replicated the above issue when I select 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 application is roughly around 800 million rows. I would greatly appreciate it

      if someone could tell me why this happens and what I can do to remedy it.

       

      Thanks very much.

       

      Kind Regards

      Eamonn