Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

TASKS IN QMC NOT RUNNING

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.

1 Solution

Accepted Solutions
Highlighted

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

15 Replies
Highlighted

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.

Highlighted
Specialist
Specialist

Hi Miguel ...  thank you for responding

Here I'm sharing the log file for reference.

Earlier it was successfully generating the pdfs.

Highlighted
Specialist III
Specialist III

hello

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

Highlighted

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?

Highlighted
Specialist
Specialist

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>

  <LogIndex LogID="58867c16-f770-448f-9b09-7c5fa1db833c" TaskName="RM Wise Auto Email" Date="2018-05-01" Time="10:35:00" ClusterID="1" FullLogPath="C:\ProgramData\QlikTech\DistributionService\1\Log\20180501\103500 - RM Wise Auto Email\TaskLog.txt" />

  <LogIndex LogID="463626f2-6062-4839-886f-b11b0697a1a1" TaskName="RM Wise Auto Email" Date="2018-05-01" Time="11:32:44" ClusterID="1" FullLogPath="C:\ProgramData\QlikTech\DistributionService\1\Log\20180501\113244 - RM Wise Auto Email\TaskLog.txt" />

  <LogIndex LogID="6fbf9b12-035e-4f1f-b3d2-ddacd69bef4a" TaskName="RM Wise Auto Email" Date="2018-05-02" Time="13:35:30" ClusterID="1" FullLogPath="C:\ProgramData\QlikTech\DistributionService\1\Log\20180502\133530 - RM Wise Auto Email\TaskLog.txt" />

  <LogIndex LogID="b2e5444e-f218-4dae-afdf-9ed53272adf4" TaskName="RM Wise Auto Email" Date="2018-05-02" Time="14:33:30" ClusterID="1" FullLogPath="C:\ProgramData\QlikTech\DistributionService\1\Log\20180502\143330 - RM Wise Auto Email\TaskLog.txt" />

  <LogIndex LogID="1fcdaa95-6377-437c-a239-8a914a588e19" TaskName="RM Wise Auto Email" Date="2018-05-02" Time="17:46:26" ClusterID="1" FullLogPath="C:\ProgramData\QlikTech\DistributionService\1\Log\20180502\174626 - RM Wise Auto Email\TaskLog.txt" />

</Root>

Highlighted

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

Highlighted
Specialist
Specialist

But Currently I'm working with  QVS 11.20

Thanks alot for spending your valuable time.

Highlighted

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>" />

Highlighted
Specialist
Specialist

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