topic Re: [NPrinting] Report not working randomly in Qlik NPrinting

[NPrinting] Report not working randomly

Diane — Thu, 16 Mar 2023 16:22:43 GMT

Hello,
We have a report that runs in a very random way. when it runs in 2 minutes, sometimes it doesn't run even after 2 hours. When it runs, there are 12 QV.exe that are launched on the Nprinting engine while it is the only one that runs, I don't know if it's normal because for the others, there is only one QV.exe that is launched
We tried to reload the connections before relaunching it, there is no unsupported object. It is based on a qlikview report.
The server is not overloaded with either nprinting or Qlikview.
Do you have any idea?

thanks in advance

Re: [NPrinting] Report not working randomly

David_Friend — Thu, 16 Mar 2023 17:18:51 GMT

@Diane I would start off by verifying the basics here:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/NPrinting-with-QlikView.htm

Are NP and QV on separate servers? What version is QV?
How large is the QVW?
Section Access?
Do NP and QV servers have their own dedicated service accounts?
I usually don't worry too much about the qv.exe processes, NPrinting will decide how many are needed.
Filters?
Is it just this one publish task you have issues with? If so, maybe re-create that report and task?
When you say 'random' any idea of how often this is happening?

Re: [NPrinting] Report not working randomly

Frank_S — Thu, 16 Mar 2023 19:41:04 GMT

@Diane

Also check:

Your QVWs for unsupported items - Unsupported QlikView Document item... - Qlik Community - 1714896
Ensure that you are not sharing your NPrinting service account with any separate NP nor any QlikView environments - Dedicated NPrinting Server & Engine Service Accoun... - Qlik Community - 1716056

KInd regards...

Re: [NPrinting] Report not working randomly

Lech_Miszkiewicz — Thu, 16 Mar 2023 22:02:32 GMT

Hi @Diane This normally is a gold example of one or few unsupported objects and/or configurations:

check your qvw for hidden sheets and objects
check for triggers
make sure you have that configuration: https://support.qlik.com/articles/000098313?_ga=2.56552877.726009969.1611644496-2102903719.1607042628
make sure your NPrinting server meets all requirements (also recommendations re number of CPU cores. I assume you should know this since you work with NPrinting but I will repeat for others here that larger number of CPU cores may not necessarily mean that NPrinting will work better). You have to calculate workload on QlikView server caused by NPrinting opening concurrently the largest app you use in NPrinting reports as many times as many CPU cores you have. There are also recommendations regarding max number of cores written in help documentation which should be studied.

That aside - check the qvw for hidden sheets and try so set settings I gave you link to and let us know how you go.

good luck

Re: [NPrinting] Report not working randomly

Diane — Mon, 20 Mar 2023 12:23:44 GMT

Hello,
- We have the following number of CPU for our engine:for the account we use the same service account for the NPrinting engine and NPrinting server (for Qlikview et Qliksense are different account), but each one has its dedicated server. do we have to have separate accounts?

In the recommendations it is marked 12 CPU per engine if we use only Qlikview. On our side we use Qlikview but also Qlik Sense, does our engine have to be 12 CPU? In our case 12 CPU = 12 cores or 12 logical processors?

- for the account we use the same service account for the engine and NPrinting server, but each one has its dedicated server. do we have to have separate accounts?

- We are looking at the other elements

Thanks in advance

Re: [NPrinting] Report not working randomly

David_Friend — Mon, 20 Mar 2023 12:25:22 GMT

@Diane yes its required that each NPrinting server/engine have its own dedicated and separate Service Account, otherwise you will have task failures.

Re: [NPrinting] Report not working randomly

Lech_Miszkiewicz — Mon, 20 Mar 2023 12:48:01 GMT

@David_Friend Wasnt clear-you can have the same account for server and 1 engine, but if you have more than 1 engines then you need to have dedicated accounts for each engine.
you also need to have dedicated accounts for QlikView and Qlik Sense.

Regarding CPU-i normally have no more than 12 logical processors if i connect that engine to QlikView (regardless if i connect also to Qlik Sense or not) as that does not matter

Re: [NPrinting] Report not working randomly

Maarten_Bitmetric — Mon, 01 May 2023 09:23:04 GMT

@Diane - did you ever find a solution? We are running into the exact same problems: https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-erratic-behavior-Publishing-works-flawlessly-then/td-p/2066256