topic Re: Nprinting Processing in Qlik NPrinting

Nprinting Processing

FrankC — Sat, 13 Aug 2022 13:25:22 GMT

Hello

Is there any way to force the Nprint Engine to run 1 request at a time (on-demand) instead of allowing a subsequent to start until the first job has completed?

thanks for any advice.

Re: Nprinting Processing

Digvijay_Singh — Mon, 15 Aug 2022 04:02:16 GMT

I don't think its possible.

@Frank_S what is your take on this?

Re: Nprinting Processing

Frank_S — Mon, 15 Aug 2022 14:30:20 GMT

The NPrinting Scheduler service manages usage of available NP engine processes based on an internal algorithm.

There is no way to modify the algorithm.
If your site's engine has insufficient resources, then suggest upgrading CPU and RAM or acquiring a second engine.

Also see:
Finetuning and preparing your NPrinting 19+ Deploy... - Qlik Community - 1716222

Re: Nprinting Processing

andregas — Tue, 16 Aug 2022 16:20:44 GMT

Hello @FrankC,

I suggested a similar add some months ago, if you think it could be usefull please upvote it: https://community.qlik.com/t5/Suggest-an-Idea/Define-a-maximum-number-of-cuncurrent-tasks-in-NPrinting/idi-p/1859610

Regards

Re: Nprinting Processing

David_Friend — Tue, 16 Aug 2022 19:00:56 GMT

@andregas like Frank was saying there is not a way to modify the algorithm...if you want OnDemand reports to be processed first the only way (that I am aware of) is to stand up a separate NP Environment just for OnDemand reports.

Re: Nprinting Processing

andregas — Wed, 17 Aug 2022 07:10:38 GMT

Hi @David_Friend,

I'm not asking to change the algorithm but to add a limit at the queue. I want choose the number of the reports could be elaborated at the same time, similar setting existing in QlikView or Qlik Sense (max concurrent reload).

Re: Nprinting Processing

Ruggero_Piccoli — Wed, 17 Aug 2022 11:34:07 GMT

Hi,

No, you cannot set a max number of requests or other parameters. They are calculated by the Qlik NPrinting Scheduler based on available number of Engines and hardware resources using an internal optimization algorithm. About performances you can check https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Performance.htm.

Note also that the time needed to create a report depends also on the structure of the template (for example many nested levels resulted in longer creation time) so, if you need to speed up the creation on some specific reports you can optimize the templates structure. On-Demand requests already have an higher priority.

To optimize the performances I also suggest to avoid to use Section Access, that is supported but it is slower than native Qlik NPrinting filters. Check also the workload of the QlikView or Qlik Sense server you are connecting Qlik NPrinting.

Best Regards,

Ruggero

Re: Nprinting Processing

andregas — Wed, 17 Aug 2022 12:29:56 GMT

Hi @Ruggero_Piccoli ,

If I could be honest this algotithm is working very badly...

Generally I managed the NP tasks using an external scheduler and API because if NPrinting is working with more than 4 tasks at the same time, generally it completes them after double of time that it request to elaborate them singularly (all tasks request at least the double of time, so the total time is x2).

With on-demand I cannot schedule or manage when and how many reports start at the same time. In one of the my case study the client has 400 users could generate reports on-demand and, based on filters, the report could be request 1-30 minutes to generate singularly, but usually, because the users start them randomly, after 4 hours NPrinting has still elaborated them. It's frustrating, the users (or the system supervisor or the system timeout) abort the requests and send me a complaint.

Setting a limit of concurrent elaboration could be a simple work-around to optimize the times.

Re: Nprinting Processing

Ruggero_Piccoli — Wed, 17 Aug 2022 13:07:17 GMT

Hi,

Based on the description it seems that the installation is undersized compared with the workload or it could be too heavy for the connected Qlik Sense server. When you run multiple tasks at the same time the Scheduler distributes the resources on all of them, it is not waiting that the first started ended to start the second task etc. If an On-Demand request enter at the same time the Scheduler has to manage the resources it has.

I suggest you to monitor the hardware resources usage of Qlik NPrinting and Qlik Sense servers and evaluate to increase them if you cannot move the scheduled tasks to avoid the time when users request On-Demand reports.

Best Regards,

Ruggero