topic Different Result when Script runs manually and as a Task in QlikView

Different Result when Script runs manually and as a Task

floriand — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

We have a document with a script, which is automated using a task from the Management Console Reload Engine.

When I run the script manually from the document I get different results than running the script from the task.

Is there any function/feature/... which could cause this? I have not created the document by myself, therefore I am maybe missing someting.

Thanks in advance

Flo

Re: Different Result when Script runs manually and as a Task

kaushiknsolanki — Mon, 07 Sep 2020 15:21:26 GMT

Not Sure what could be the reason, but you can do one thing.

Enable Script log and then compare the script log of Manual reload and QMC reload and check which part of the script is causing issue.

Re: Different Result when Script runs manually and as a Task

floriand — Tue, 08 Sep 2020 15:40:39 GMT

Hi Kaushik,

Thank you for your answer!

The only difference within those logs are as followed.

Manual log:

2020-09-08 17:18:30 QlikView Desktop Version 12.10.20700+2018-02-09 15:37:07.HEAD.Component.Version
...
2020-09-08 17:18:30 SequentialThreadCount 106
...
2020-09-08 17:18:30 Process Executing QlikView Desktop
2020-09-08 17:18:30 Process ID 640

Scheduler log:

2020-09-08 17:20:30 QVB Version 12.10.20700+2018-02-09 15:37:06.HEAD.Component.Version
...
2020-09-08 17:20:30 SequentialThreadCount 28
...
2020-09-08 17:20:30 Process Executing QVB
2020-09-08 17:20:30 Process ID 7656

This does not look very suspicious to me.

Can a section access cause this? I'm comparing the files always using the same user.

Regards

Re: Different Result when Script runs manually and as a Task

Brett_Bleess — Tue, 22 Sep 2020 20:52:36 GMT

See the following Article on how to enable the Script/Document log:

https://support.qlik.com/articles/000002668

Only thing that really makes sense would be Section Access being in the application and the service account not having the correct setup such that is sees the same data as your ID when you reload via Desktop Client. The Script log should show you exactly how many rows are being fetched for each table loaded etc., so you should be able to immediately see where the deltas are occurring and then dig into why that may be.

Regards,
Brett