Solved: Re: TASKS IN QMC NOT RUNNING - Qlik Community

kakani87 · ‎2018-05-02

Dear Folks ...

Tasks in QMC they are not running. which we use to generate pdf.

when manually run them they are not in progress to generate PDF

There are multiple tasks got scheduled on the same document.

Configured some sample tasks on another document to check with the status of running and they are in progress.

Now the existing task started and taking long time to execute with the sample tasks.

When i tried killing/stop the tasks they are not getting stopped .

NOTE: Restarted the services as well

Any help is appreciable.

Miguel_Angel_Baeyens · ‎2018-05-03

In QlikView 12 for the sake of performance, resources in the distribution service server are used at its max, so expect high CPU usage (over RAM usage) if you are using this version of QlikView.

As far as I'm aware, this is expected and normal. What you can do is limit the threshold above which no more tasks will be run (if they are triggered they will be queued until the previous tasks have been completed).

If the tasks complete, perhaps they simply don't show up in the QMC?

As for the logs, in case needed, the ones generated along the QVW file (in the same folder) that you need to set up as mentioned above. The script logs, to see whether the script is taking longer on certain task like a join, a load or a store. Those logs.

EDIT: threshold settings for QDS in QV12

Queued jobs

View solution in original post

Miguel_Angel_Baeyens · ‎2018-05-02

Enable the script logs in the document settings > General > generate logfile, run one of the tasks and see where it fails (e.g.: a path to a file is not working, lack of permissions, etc.)

Then check the status in the QMC for such task and post here whatever the result is to further troubleshoot.

kakani87 · ‎2018-05-02

Hi Miguel ... thank you for responding

Here I'm sharing the log file for reference.

Earlier it was successfully generating the pdfs.

olivierrobin · ‎2018-05-02

hello

I would check the max. time allowed for a task to run

Miguel_Angel_Baeyens · ‎2018-05-02

This log is incomplete. It would be much useful if you can you share the one from the QVW that you can enable as I specified above?

kakani87 · ‎2018-05-03

As discussed I'm sharing the log file suggested by you.

Actually tasks got executed and generated pdfs

I have noticed the cpu usage is showing like 100% and keep on fluctuating yesterday when i post this issue.

How to reduce the cpu usage when the usage is high.

<?xml version="1.0" encoding="utf-8"?>

<Root>

</Root>

Miguel_Angel_Baeyens · ‎2018-05-03

In QlikView 12 for the sake of performance, resources in the distribution service server are used at its max, so expect high CPU usage (over RAM usage) if you are using this version of QlikView.

As far as I'm aware, this is expected and normal. What you can do is limit the threshold above which no more tasks will be run (if they are triggered they will be queued until the previous tasks have been completed).

If the tasks complete, perhaps they simply don't show up in the QMC?

As for the logs, in case needed, the ones generated along the QVW file (in the same folder) that you need to set up as mentioned above. The script logs, to see whether the script is taking longer on certain task like a join, a load or a store. Those logs.

EDIT: threshold settings for QDS in QV12

Queued jobs

kakani87 · ‎2018-05-03

But Currently I'm working with QVS 11.20

Thanks alot for spending your valuable time.

Miguel_Angel_Baeyens · ‎2018-05-03

In QV 11.20 you can set CPUAffinity, so how many CPUs should be working maximum at any point in time. I would recommend to set 1 or 2 to 0, in this case you should never see 100% utilization, if only the QlikView Distribution Service is running.

This setting is in the QVPR folder (by default C:\ProgramData\QlikTech\ManagementService\) in the file DistributionService.xml

The value is a string of 1 (to be used) or 0 (to not be used) for each core Windows can see (as in the Windows Task Manager). If your server has 16 cores and you want to leave 2 free, the line would look like something like this:

<DistributionService XSWebAdress="http://hostname:4720/QDS/Service" DSCID="<sid>" LogLevel="Normal" IsPublisher="true" MaxSimultaneousQvb="4" MaxSimultaneousReaderQVBs="20" IsCluster="false" SectionAccessUserName="" SectionAccessPassword="" CPUAffinity="1111111111111100" CPUPriority="Low" ApplicationDataFolder="C:\ProgramData\QlikTech\DistributionService" Username="" Password="" DisableTaskTriggersForDocAdmins="false" ShowAlerts="true" ClusterName="" ModifiedByUser="DIR\USER" ModifiedTime="<timestamp>" ID="<id>" />

kakani87 · ‎2018-05-08

Able to see QVDistributionService.exe.config in Distribution Services folder

As mentioned in the above DistributionService.xml no such kind of file available in Management Services folder

The server Config I'm handling will be like

CPU 4 cores with 64 gb memory