topic Re: Suggestion:Task Error In QMC in QlikView

Suggestion:Task Error In QMC

Anonymous — Tue, 15 May 2018 00:51:05 GMT

Hi, Everyone

I've got an issue when QMC reload our qvw, sometimes it failed, but if I running again in QMC, It success reload our qvw.

I need your suggestion,

Thanks for your help

Re: Suggestion:Task Error In QMC

vishsaggi — Tue, 15 May 2018 01:18:02 GMT

Seems you have section access in your document, do you? Can you pick document log from your log folder. You can enable document log by opening your document in QV and press Ctrl+Al+D - General Tab - Check Generate Log File option and save it. Then run your document on QMC. When it fails it generated a log file. The path will be given in the status history where you can find your doc log file.

Re: Suggestion:Task Error In QMC

Anonymous — Tue, 15 May 2018 02:58:04 GMT

I've attached logs for this issue in my post.

Btw, My document not using section access.

This is my logs

Re: Suggestion:Task Error In QMC

vishsaggi — Tue, 15 May 2018 03:09:46 GMT

If you follow my instructions in my previous thread of enabling Generate Log file it would help us identify the error.

Re: Suggestion:Task Error In QMC

qliksus — Tue, 15 May 2018 03:37:11 GMT

Is the document reloading without any error while manual reload ? . As per the log 3 assumptions are clear

1) Engine is allocated

2) The failure is not during distribution of the file

3) Document opened successfully and reload have started

Just try manual reloading and see if you get any error

Re: Suggestion:Task Error In QMC

Anonymous — Tue, 15 May 2018 04:07:06 GMT

Hi Kumar,

I've running again that qvw in QMC in morning and it success reload.

But when scheduling at around 3 AM o'clock it sometime fail.

If I reload manualy that document , it success too.

Re: Suggestion:Task Error In QMC

kakani87 — Tue, 15 May 2018 05:10:09 GMT

Observed any thing like task triggered manually but not getting executed at that time and later some time started running

Re: Suggestion:Task Error In QMC

pradosh_thakur — Tue, 15 May 2018 06:53:49 GMT

Hi Yislam,

Can you please enable the log file by opening your document in QV and press Ctrl+Al+D - General Tab - Check Generate Log File. During your next reload it will genrate a log file in the folder. Can you post that here to know what exact error you are getting .

Re: Suggestion:Task Error In QMC

Peter_Cammaert — Tue, 15 May 2018 08:12:36 GMT

Whenever a document is reloaded under QMC control, it can generate two log files that document different details of the reload process:

The QDS scheduler plans a reload and assigns a reload engine to the job. The QDS doesn't do the reload by itself, but monitors the reload job and records the end-result. It can also abort the reload when there doesn't seem to come an end to the reload. All these details are logged in a TaskLog.txt file. That's the one you posted (twice) in this discussion. However, the TaskLog may report failure due to script errors at the end of script execution but will not tell you what they are because it doesn't know. That's because the reload is handled by...
The Reload engine (QVB.exe) that was assigned this job, and that will open the QVW document, execute the load script, save the document (if all went well) and exit. During script execution, the reload engine may generate a detailed DocumentLog.txt file that includes messages and script error details, but only if you enable log generation in your document, as Vishwarath and Pradosh already explained.

The TaskLog told you that errors occured during the reload but is useless for figuring out what went wrong during script execution. We need a DocumentLog. Enable log generation in your QVW document, wait until the reload fails again and post the resulting DocumentLog file.

Best,

Peter

Re: Suggestion:Task Error In QMC

Anonymous — Mon, 28 May 2018 00:02:23 GMT

Hi Peter,

I just attached Document logs file.

Btw I got this error early today. But if I reload again in qmc when another task in QMC is idle, it's successfully reloaded.

Re: Suggestion:Task Error In QMC

pradosh_thakur — Mon, 28 May 2018 06:12:31 GMT

Hi Yislam,

Should not you use relative path to save when using the store statement so that it will work in all the environment?

Anyways . check if you missed a semicolon ';' after the store statement

Store FACT_RISK_BARU INTO ;

Re: Suggestion:Task Error In QMC

Anonymous — Mon, 28 May 2018 07:48:08 GMT

Hi Pradosh,

Like I said in my previous post.

If I reload again in QMC when another task in QMC is idle, it's successfully reloaded.

So I think my script is work well.