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

[markhavi]

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?

[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?

[markhavi]

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.

[sunny_talwar]

Not really sure I have an answer for you. May be somebody else may be able to help you with this.

Best,

Sunny

[markhavi]

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.

[#6]

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

[markhavi · Accepted solution]

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.