Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
kdmarkee
Specialist
Specialist

Task times for reports with multiple email destinations

I have an Excel report that uses a cycle, and has levels and paging, and the destinations include one network folder, 2 individual email addresses (one of which is myself), and an NP Group that has 3 users/emails.  I have noticed that if I run this just for myself and the folder destinations, it runs in about 30 mins, however when all destinations are included (5 user emails and 1 folder) it runs well over 3 hours (I actually killed the task 3.5 hrs in; it was 83% done).  I know cycles, levels and paging add a lot of performance overhead, but what else is happening to make this run so long?  Does NP generate one report and then distribute it or is it going through the process of re-generating a report for each destination?  Does it not like an NP Group as a destination?  Looking for any insight.  Thanks.

Labels (2)
19 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @kdmarkee 

I am assuming this is the result of 5 user emails being part of the group which (i think) is resulting in NPrinting producing individual reports for each user (just if those users had any user filters in them).

 

@Ruggero_Piccoli@Frank_S  - do we have any official documentation regarding this? My understanding would be that if there is at least one person who is part of distribution and has the user filter assigned (filter from the NPrinting app report is created in) then NPrinting needs to create report for each user individually as it needs to assume that each user may have different filter hence requires different report.

Or is there any other behaviours in this regard. Would you be able to point us either to documentation or article where this is explained?

I would hope that if users dont have any user filters for NPrinting app the report is running in then report would be generated once (same for all) and distributed to user emails/folders... If this does not happen, then there is major risk in whole performance design.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Ruggero_Piccoli
Support
Support

Hi,

If all 5 users have not filters the report is generated only one time. If each user has a filter the report is generated for each one. So I think in this case the 5 users have filters. 

You could upgrade to latest version but I think this will not increase the generation speed. You could evaluate to increase the hardware resource by following the suggestions in https://help.qlik.com/en-US/nprinting/November2020/Content/NPrinting/DeployingQVNprinting/Performanc....

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @Ruggero_Piccoli 

can we precise this little bit more? is this global setting or App/connection based setting within NPrinting repository?

If all 5 users don't have any filters for one "1 NP" NPrinting app/connection but they have some filters for "2 NP" NPrinting app/connection then how many times report which is build in App "1 NP" gets generated? Is it only 1 time as none of the user filters is associated with that NPrinting app?

I know we can test it but I would like confirm this design rather than find out by assumption.

Appreciate your input on this - thanks!

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Ruggero_Piccoli
Support
Support

Hi @Lech_Miszkiewicz ,

I'm collecting more details and opening a documentation improvement do document this topic. I think it is important to know to optimize the performances of Qlik NPrinting installation.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks Ruggero - thats great!

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
kdmarkee
Specialist
Specialist
Author

None of my users in this scenario have any user filters for the NPrinting app the report is running in.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @kdmarkee 

Do your users have any other user filters for other NPrinting apps (I assume they do)?

I guess this may be clarification we need from @Ruggero_Piccoli once he gathers it. In my opinion if other apps filters can cause such performance decrease, then it would be something R&D should look at...

Lets wait for official documentation-cheers

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Ruggero_Piccoli
Support
Support

Hi,

Are you using section access?



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
kdmarkee
Specialist
Specialist
Author

Thanks to you both for your continued involvement.  Here is some additional info...

Of the 5 users on this task, none of them have any user filters associated to any of my NP apps in my entire NP environment.  The report associated to this task does have a report filter, however, if that is relevant.  Additionally, if relevant, the users on this task do get other reports from other NP apps and tasks that do have their own report filters as well.  Hopefully you followed that… short answer, no user filters at all anywhere for these 5 users.

There is no section access in place, to answer that question. 

Additionally, I ran some more tests yesterday and today, and on average, it seems like NP needs 25 mins per user.  With all users and folder included, the max testing time I got was 2.5 hrs (we got a faster vm this week, so my times are better this testing round than the original test time of 3.5+ hrs).  

My gut tells me it has something to do with one or more of:  cycles, paging, levels, or perhaps even just the report filter itself.  I only say that because I have other excel reports, without any of these features, set up for the same set of users/destinations and they run very fast.  I will try to do further testing by taking one feature off at a time to see if I can prove one of those features as being the culprit (which seems like a bug in that case, as if all the users are getting the same exact report, it shouldn’t add additional time for each user included in Destinations).