0 Replies Latest reply: Oct 19, 2012 3:39 AM by Jagan Vijayakumar RSS

    Script takes more time to execute in server

    Jagan Vijayakumar

      Hello,

       

      Desktop: Qlikview Enterprise Edition 10 SR1

      Server: Qlikview 11

       

      I developed an application using Qlikview 10 SR1 which less than 3 mins to reload.

       

      When I deployed in Qlikview server 11 it takes more than 6 mins to reload.

       

      Could some one please let me know why it happens like this?

       

      I also generated the log file, the log file shows thaat after fetching data from first qvd it waits for a long time and goes for second qvd.

       

      First QVD START Time: 19/10/2012 08:11:25

      First QVD END Time:  19/10/2012 08:11:25

      SECOND QVD START TIME: 19/10/2012 08:16:52

      SECOND QVD END TIME: 19/10/2012 08:16:52

      THIRD QVD START TIME: 19/10/2012 08:17:24

      THIRD QVD END TIME: 19/10/2012 08:17:30

       

      All the 3 QVD's are autoconcatenated by qlikview.

       

      I use the following functions given belwo inside all the 3 QVD's

       

      date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY') as monthdate,

      date(floor(MonthEnd(date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY')))) as date,

      FLOOR(num(MonthEnd(date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY')))) as date1,

       

      Please let me know the issue.

       

      Also when the task is run in server, the performance of server goes to 100% usage.

       

      Please let me know what should I have to do.

       

      Thanks,

      Jagan. V