Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

julian_rodrigue
Valued Contributor

NPrinting 17.1.2 Issue - multiple qv.exe processes after a publish task has ended

Hello experts

I'm  testing NPrinting 17.1.2 in order to migrate a current NPrinting 16 enviroment.

But, I have detected some issues so far:

- There are multiple QV.exe processes running on memory, even when the publish task has ended. This is a real problem, because with every task, there are more new QV.exe processes and the available memory is running out, until there is not more. This problem happens with any kind of report (Pixel Perfect, PPT, etc)

- How can I check the progress of a publish task?... how much time took from the beginning to the end?... how can I read the logs?

I will update this post with any new discoveries, but, there is information about this issues that you guys could share with me?

Thanks in advance

Julian

6 Replies
Employee
Employee

Re: NPrinting 17.1.2 Issue - multiple qv.exe processes after a publish task has ended

Hi Julian,

   Had you solved this situation? We have the same issue. I guess it´s a default situation and going to open a case to Qlik to be able understand this situation.

Ricardo Gerhard
OEM Solution Architect
LATAM
julian_rodrigue
Valued Contributor

Re: NPrinting 17.1.2 Issue - multiple qv.exe processes after a publish task has ended

Hello Ricardo

Unfortunately, we didn't have any possitive answer. This is the transcription of a cuestionarie send to Qlik Support, and honestly I'm not happy with the answers:

"

Hi Julian,

In the documentation, is it recommended that NPrinting had a dedicated server for this reason.

"This behavior imply that my server, on the time, suddenly will lack of any available RAM? If I add more qvw files as datasources, and I add more reports to NPrinting, the current server will be not enough?

--Yes, NPrinting will continue to open qv.exe instances for each core available on the server and each instance will consume RAM while open.

Even if this reports are not on execution at the same time? or its execution is generated monthly, weekly, etc?

--When the core limit is reached, it will then start to re-cycle the active sessions.

How does work the NPrinting memory deallocation?"

--This information has been provided from R&D

While the name is NPrinting 17, this is basically a 1.0 product with a complete new architecture and design so a lot of these questions have not been answered yet being such a new product."

We have decided to try using QlikView Server as datasource, instead of the local qvw file, because QVS may be has a better RAM comsumption control. May be this could be a workaround for this.

We are testing NPrinting 17.2 and so far, the behavior is the same as 17.1.

I hope you have better news, and can share it with us.

Best regards

Julian

maxxieshi
New Contributor II

Re: NPrinting 17.1.2 Issue - multiple qv.exe processes after a publish task has ended

Dears,

I also have met same problem, and I use NP 17.3 edition,do you have any process on it ?

Lech_Miszkiewicz
Honored Contributor III

Re: NPrinting 17.1.2 Issue - multiple qv.exe processes after a publish task has ended

The upcoming release is addressing open QV.exe session "issue".

On the other hand i do not think it is a issue if:

  • you use QVP connection - Local connection will use a LOTmore RAM (and i am talking 1000% more!!!) per document, where server connection will levarage QVS service, RAM management, Cacheing etc - so this is critical to understand and it was a case also with NPrinting 16! Ths was always a case with QlikView (not only with NPrinting - so it is really don to understanding how QlikView Desktop vs QlikVIew server works and in this case you want QlikView server solution in use)
    • open QV.exe with QVP connection will not use much resources as it behaves like just another concurent server user
  • setup NPrinting on different box than QV. NPrinting will use up all available resources when generating reports so this is main reson wy it should not be installed on QV box
  • understanding how to prepare QV document to work with NPrinting is another important thing. If you just blindly take any available qvw file it will use a lot more resources than a document preped for NPrinting usage (stripped down to all required by NPrinting fields, objects, variables etc.

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
kdmarkee
Contributor III

Re: NPrinting 17.1.2 Issue - multiple qv.exe processes after a publish task has ended

I am on 17.5 (waiting for April/May 2018 version to upgrade).  What if you have all those things in place, that is, I have QV on one server and NP on another, and I have taken my qvw and limited it by not only the data I need to report on but also took out any tabs I didn't need.  My publish tasks run way too long and inconsistently...for one task for example...one day it takes 20 mins, on another it can take 2.5 hours, and there are times I decide to kill the task because no progress has been made after 4 hours. The reports have all the bells and whistles like cycles, levels, paging (and only a few users get them).  If stripping down my qvw in combination with these features works this poorly, this tool won't work for us long term as we have even more complicated reports that will go to many more users.

Lech_Miszkiewicz
Honored Contributor III

Re: NPrinting 17.1.2 Issue - multiple qv.exe processes after a publish task has ended

Hi Kris,

I am aware that report generation speed is an issue and i have been also vocal about it. I am especialy pointing here towards qvp connection which technicly - long term - is more stable, but has this lag with report generation process!

From my experience though there are some things which can be done within templates, for example:

  • Limit usage of images and where possible use native charts/table
  • the same here - If you are using excel reports with charts - try not to use images (but Excel charts instead if possible)
  • Make sure you use cycles, levels and pages wisely - as they are extending significantly report generation times

Did you observer QlikView server performance once NPrinitng is doing report generation? How does you CPU and RAM look like? Is it spiking very high or within reasons?

Also NPrinting server & engine configuration - especialy for QlikView. I trust you are fully aware of the below instructions from help documentation and recommendations regarding number of cores for engine running qvp connections:

https://help.qlik.com/en-US/nprinting/February2018/Content/DeployingQVNprinting/Performance.htm

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser