CPU Performance issue in Qlikview 11.2 - Qlik Community

Anonymous · ‎2018-01-22

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

marcus_sommer · ‎2018-01-23

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