Nprinting Report Cycle Generation Problem

[rafatashiro]

Hello, Qlikers!

I have to generate 8 different reports with a loop in a field of my connection (qvw app).

My problem is that this process takes more than 3 hours and fails. My report type is HTML and the size of my qvw is 3.5 GB.

At this moment I am using a field based cycle and my logs doesn't explain the reason of failing.

Does exist a better way of doing this?

My NP version is May 2021 SR1 (Version: 21.14.4.0).

Thanks.

Qlik NPrinting QlikView 

[Lech_Miszkiewicz]

I would start with optimisation and reduction of the qvw size. There is usually room for improvement to allow for faster report generation. 

i cannot comment more on that - i am assuming you are already using qvp server connection and you have sufficient resources to run this task

[Frank_S · Accepted solution]

There are many possible reasons for this. 
In reality this should not take that long...so let's begin.

1. Your QVW at 3.5 gb file size can grow in memory quite a lot from there. for example depending on complexity and number of charts and other objects in the QVW it can get even as high around 35 GB in memory. 

• So how much CPU and ram exists on your NP server and QlikView server?
• Are you using QVP or Local NP connections?
• Possible cause: insufficient system resources. Finetuning and preparing your NPrinting 19+ Deploy... - Qlik Community - 1716222

2. Do you have any triggers or other unsupported items in your QVW? ie: always one selected values, on open triggers etc.

• Unsupported QlikView Document item... - Qlik Community - 1714896

3. Do you have a dedicated NP server/engine service account? 

• Without a dedicated NP service account you will encounter unexpected reporting results and behavior not withstanding complete failure of NPrinting services including failing connections and publish tasks etc.
• Dedicated NPrinting Server & Engine Service Accoun... - Qlik Community - 1716056

Resolutions:

• System resources: See the article above about system sizing
• Create a dedicated QVW without unneeded reporting charts and objects. This will reduce the size of your QVW as well.
• Ensure you have a dedicate NP server/engine service account.
• Use 'user filters' to create one workbook per recipient. ie: create 8 NP users and apply your respective filter to each user. then add each user to your publish task. This takes more time to set up but is much faster result then using NP cycles. Also if you have more than 3 cycles, you will see severely dimished performance...especially with a 3.5 GB file. See https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Cycling-your-repo... 

Kind regards...