Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

CPU Performance issue in Qlikview 11.2

Hi All,

I am facing CPU performance issue in qlikview 11.2 when more than 5 scripts are running simultaneously (These scripts are scheduled to run in every 5 mins). CPU usage reached to 100%, as a result of which qlikview management console is getting hung.


After restarting of the Qlikview services all the scripts ran successfully. But the same issue continues after 3-4 hours. I don't have Qlikview publisher license. I have only Qlikview server license.

Please help in resolving this issue.

Below is the log file details:

1/22/2018 02:24:19.1492520 Information Starting task 'BIBusiness/Copath/busElapsedTimeBase.qvw'. Id:3e804b68-7d3d-40cd-bf92-8ee6763ccbe9. Triggered by 'ScheduleTrigger'. Id:2face6f0-0730-4e71-bc45-086907ed6a97

1/22/2018 02:24:19.1722531 Information Entering Task Execution.

1/22/2018 02:24:19.1722531 Information ClusterID=1

1/22/2018 02:24:19.1722531 Information QDSID=e441982b-7763-1452-9d69-100a75b15fa5

1/22/2018 02:24:19.1722531 Information TaskID=3e804b68-7d3d-40cd-bf92-8ee6763ccbe9

1/22/2018 02:24:19.1722531 Information MaxRunTime=06:00:00

1/22/2018 02:24:19.1722531 Information MachineName=************

1/22/2018 02:24:19.1722531 Information Max attempts:1

1/22/2018 02:24:19.1722531 Information Current Attempt=0

1/22/2018 02:24:19.1722531 Information Task Dependencies are OK

1/22/2018 02:24:19.1882548 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

1/22/2018 02:24:19.1922547 Information Opening "E:\Program Files\Sunquest\DI\SQBIDocuments\BIBusiness\Copath\busElapsedTimeBase.qvw"

1/22/2018 02:25:25.3224638 Information Failed to allocate new QlikView Engine. Retrying! Max usage reached. Current usage count=3 of 3 (of type non-reader).

1/22/2018 02:25:30.3237873 Information Allocating new QlikView Engine. Current usage count=1 of 3 (of type non-reader).

1/22/2018 02:25:30.3237873 Information Max retries:5

1/22/2018 02:25:30.3237873 Information Attempt:01

1/22/2018 02:25:31.3048457 Information Opened the QlikView Engine successfully. ProcessID=11164

1/22/2018 02:25:31.3058458 Information Allocated QlikView Engine successfully. Current usage count=2 of 3 (of type non-reader). Ticket number=15270.

1/22/2018 02:25:31.3088452 Information Loading document "E:\Program Files\Sunquest\DI\SQBIDocuments\BIBusiness\Copath\busElapsedTimeBase.qvw" (0.18 Mb)

1/22/2018 02:25:31.3778544 Information Physical FileSize=0.18 Mb. Memory Allocation Delta for this file=2.61 Mb. Available Physical Memory Before Open=14527.88 Mb. Available Physical Memory After Open=14510.81 Mb. Total Physical Memory=24575.49 Mb.

1/22/2018 02:25:31.3788538 Information Attempted to load the document without data.

1/22/2018 02:25:31.3788538 Information The document was loaded successfully.

1/22/2018 02:25:31.3788538 Information Document was opened successfully

1/22/2018 02:25:32.2969087 Information Starting reload

1/22/2018 02:25:32.3129128 Information QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

1/22/2018 02:25:32.3149121 Information The Source Document is being reloaded. DocumentPath=E:\Program Files\Sunquest\DI\SQBIDocuments\BIBusiness\Copath\busElapsedTimeBase.qvw

1/22/2018 02:25:32.3149121 Information Waiting for the document log "E:\Program Files\Sunquest\DI\SQBIDocuments\BIBusiness\Copath\busElapsedTimeBase.qvw" to become available.. Check until 1/22/2018 2:26:02 AM

1/22/2018 02:25:32.3659133 Information Found a document log. FileName=E:\Program Files\Sunquest\DI\SQBIDocuments\BIBusiness\Copath\busElapsedTimeBase.qvw.log

1/22/2018 02:25:32.3659133 Information Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20180122\022419 - BIBusiness_Copath_busElapsedTimeBase.qvw\DocumentLog.txt

1/22/2018 02:25:33.0359575 Information The Source Document reload complete. DocumentPath=E:\Program Files\Sunquest\DI\SQBIDocuments\BIBusiness\Copath\busElapsedTimeBase.qvw

1/22/2018 02:25:33.0369558 Information Memory Allocation Delta for this file=9.97 Mb. Available Physical Memory Before Reload=15307.07 Mb. Available Physical Memory After Reload=15221.03 Mb. Total Physical Memory=15221.03 Mb.

1/22/2018 02:25:33.2969759 Information Reloading.

1/22/2018 02:25:33.3749789 Information The Source Document was reloaded successfully.

1/22/2018 02:25:33.4619817 Information Reload finished successfully

1/22/2018 02:25:33.4619817 Information Start saving document

1/22/2018 02:25:35.8011425 Information Check in document: E:\Program Files\Sunquest\DI\SQBIDocuments\BIBusiness\Copath\busElapsedTimeBase.qvw

1/22/2018 02:25:35.8171463 Information Closing the document.

1/22/2018 02:25:36.3281682 Information Closed the QlikView Engine successfully. ProcessID=11164

1/22/2018 02:25:37.2862293 Information No distribution required.

1/22/2018 02:25:37.2912288 Information Task Execute Duration=00:01:18.1189757

1/22/2018 02:25:37.2912288 Information The task "BIBusiness/Copath/busElapsedTimeBase.qvw" finished successfully

1/22/2018 02:25:37.2932289 Information TaskResult.status=Finished

1/22/2018 02:25:37.3032283 Information Notifying all triggers of new state:Finished

1/22/2018 02:25:37.3042344 Information Notifying all triggers of new state:Finished - completed

1/22/2018 02:25:37.3052324 Information Saving Task Result

Thanks in Advance

1 Reply
marcus_sommer

It seems that there is just too much workload for your used CPU. This meant you need to replace the CPU with a stronger ones and/or distribute your concurrent tasks in a different way to avoid these peaks of the workload and/or to optimize your loadings/datamodels to less resource-consuming ones.

Further there might be a problem with the number of parallel tasks like hinted in your marked parts of the log-file but increasing this number within the settings won't be of any use if there aren't enough resources which could do the work.

- Marcus