6 Replies Latest reply: Oct 30, 2015 3:05 PM by Mark Hohlov RSS

    General Script Error when running app from tasks on Qlik Sense Server

    Mark Hohlov

      I've an app with the following data load script:

       

      ITEMSTOCKMEMORY:

      LOAD

         ID,

         QUANTITY,

         TYPEID,

         CODE,

         DELIVERYID

      From [lib://QVDs\item-stock-2015.qvd] (qvd);

       

      ITEMSTOCK:

      LOAD 'AA-' & ID AS ITEMID,

         SUM(QUANTITY) AS QUANTITYSUM,

        'AA-' & DELIVERYID AS DELIVERYID

      Resident ITEMSTOCKMEMORY

      Where TYPEID < 5

      AND CODE <> 3

      Group by ID,DELIVERYID;

       

      Drop Table ITEMSTOCKMEMORY;

       

      If I launch the data load by pressing "Load Data" button within the application, it executes without problems and all data is being successfully loaded. However, if the data reload of the same App is executed from a scheduled task in QMC, I get the following error:

       

      2015-07-11 17:34:24        General Script Error

      2015-07-11 17:34:24        Execution Failed

      2015-07-11 17:34:24        Execution finished.

       

      Why it happens and what are possible solutions to fix the error?

        • Re: General Script Error when running app from tasks on Qlik Sense Server
          Sunny Talwar

          What is the exact error you see? That part seems to be missing from what you have pasted. For QlikView, the error description is usually before the statement you posted here, not sure how it is for Qlik Sense. Can post the complete log file?

            • Re: General Script Error when running app from tasks on Qlik Sense Server
              Mark Hohlov

              2015-07-11 17:33:59 0070     ITEMSTOCKMEMORY:

              2015-07-11 17:33:59 0071     LOAD

              2015-07-11 17:33:59 0072        ID,

              2015-07-11 17:33:59 0073        QUANTITY,

              2015-07-11 17:33:59 0074        TYPEID,

              2015-07-11 17:33:59 0075        CODE,

              2015-07-11 17:33:59 0076        DELIVERYID

              2015-07-11 17:33:59 0077     From [lib://QVDs\item-stock-2015.qvd] (qvd)

              2015-07-11 17:34:04         5 fields found: ID, QUANTITY, TYPEID, CODE, DELIVERYID,

              2015-07-11 17:34:04        53,159,576 lines fetched

              2015-07-11 17:33:59 0078     ITEMSTOCK:

              2015-07-11 17:33:59 0079     LOAD 'AA-' & ID AS ITEMID,

              2015-07-11 17:33:59 0080        SUM(QUANTITY) AS QUANTITYSUM,

              2015-07-11 17:33:59 0081       'AA-' & DELIVERYID AS DELIVERYID

              2015-07-11 17:33:59 0082     Resident ITEMSTOCKMEMORY

              2015-07-11 17:33:59 0083     Where TYPEID < 5

              2015-07-11 17:33:59 0084     AND CODE <> 3

              2015-07-11 17:33:59 0085     Group by ID,DELIVERYID;

              2015-07-11 17:34:24        General Script Error

              2015-07-11 17:34:24        Execution Failed

              2015-07-11 17:34:24        Execution finished.

               

              As you can see, it fails on Group By statement. However unclear why it executes without errors when I press "Load Data" manually.

            • Re: General Script Error when running app from tasks on Qlik Sense Server
              Mark Hohlov

              I tried to remove the Group By statement. Nevertheless, the script now fails in a totally in a random fashion. It may execute 2 times fine, but fails on the 3rd execution with General Script Error. Moreover, it still fails only when run from QMC scheduler. I'm using Qlik Sense server 2.0. RAM and CPU load is fine during the load.

              • Re: General Script Error when running app from tasks on Qlik Sense Server
                Guillaume Kaisin

                Same error here... Random failure.  If I reload manually in the Qlik Sense Hub interface (not QMC), I get an error sometimes that says "Connexion to the Qlik Sense engine failed for unspecified reasons" (I translated it in english because it is in french on my computer, so the translation is perhaps a bit different).

                 

                It is really annoying, I lost a lot of time to reload the data of an application...

                • Re: General Script Error when running app from tasks on Qlik Sense Server
                  Mark Hohlov

                  Somehow after I've disabled Qlik Sense integrated scheduled jobs (License Monitor, Operations Monitor), my apps get reloaded without problems anymore. It seems that Qlik Sense scheduled jobs were executed in parallel to the apps reloads at night, eventually crashing my apps execution with General Script Error.

                  It was the solution for me.