topic Re: NPrinting Leaves Open Sessions In QlikView in Qlik NPrinting

NPrinting Leaves Open Sessions In QlikView

lgtsotrsdh — Fri, 15 Nov 2024 20:58:08 GMT

Hi,

NPrinting is currently leaving a lots of open sessions in QlikView even after it hasn't used the document for hours. These sessions can be viewed in the QVS Statistics view in the QMC. A restart of the service on the Document Server clears all these sessions. Can this be done without restarting the service and kicking out all users?

I'm using QlikView May 2023 and NPrinting May 2023 SR1.

Thanks,

Scott

Re: NPrinting Leaves Open Sessions In QlikView

Frank_S — Mon, 12 Aug 2024 17:44:48 GMT

Hi @lgtsotrsdh

Please see this article at your convenience.

https://community.qlik.com/t5/Official-Support-Articles/How-does-Nprinting-Handle-Multiple-Concurrent-Publish-Task/ta-p/1814533

You may notice QlikView processes remain in memory. This is done by design to enable NPrinting to reuse open sessions in case the QVWs are used again for additional reporting. Thus speedier results on subsequent tasks. If new tasks are started that utilize different QVWs, then the NP scheduler service will close the open sessions and start new sessions.

Kind regards...

Re: NPrinting Leaves Open Sessions In QlikView

lgtsotrsdh — Mon, 12 Aug 2024 18:16:18 GMT

Interesting. This is a process that sends publish requests using the same document over and over using different filters and the executions overlap so it sounds like this could be helpful. Any recommendations on what to do about it?

Thanks for the response.

Scott

Re: NPrinting Leaves Open Sessions In QlikView

Lech_Miszkiewicz — Mon, 12 Aug 2024 21:46:45 GMT

you can read this: https://community.qlik.com/t5/Official-Support-Articles/How-to-remove-the-Idle-Connections-from-Nprinting-Related/ta-p/1714686

cheers

Re: NPrinting Leaves Open Sessions In QlikView

lgtsotrsdh — Tue, 13 Aug 2024 10:45:01 GMT

Thanks but I already applied that last week. It successfully removed all the idle connections that I can see using the NPrinting admin/plan link.

These are connections to the document server that I can view through the QMC. I don't know if there's anywhere else they can be viewed. Appreciate the response though. It took some serious searching to find that article last week.

For the record, I also applied this solution last week:

https://community.qlik.com/t5/Official-Support-Articles/Force-Qlik-NPrinting-to-automatically-close-idle-QV-exe/ta-p/1827411

It successfully killed the sessions on the NPrinting servers where the engines are running. Still the connections to the document server persist.

Re: NPrinting Leaves Open Sessions In QlikView

David_Friend — Thu, 29 Aug 2024 14:59:09 GMT

@lgtsotrsdh are you seeing any adverse behavior as a result

Re: NPrinting Leaves Open Sessions In QlikView

lgtsotrsdh — Tue, 12 Nov 2024 16:09:40 GMT

I was just reviewing some things and saw that I never answered David from Support's question. Yes we are seeing adverse behavior. Our larger applications can no longer be opened from the server and the service has to be restarted to clear out the connections.

Re: NPrinting Leaves Open Sessions In QlikView

David_Friend — Tue, 12 Nov 2024 16:43:49 GMT

hmmm...that could be a sign of not enough RAM perhaps?

Re: NPrinting Leaves Open Sessions In QlikView

lgtsotrsdh — Tue, 12 Nov 2024 18:20:37 GMT

Good thought but we would have plenty of RAM if all those open sessions weren't eating it up. That's the only time we've been seeing this issue.

Re: NPrinting Leaves Open Sessions In QlikView

David_Friend — Tue, 12 Nov 2024 19:01:10 GMT

@lgtsotrsdh any warnings or errors in your NPrinting logs? They are under c:\programdata\nprinting\logs

When you implemented https://community.qlik.com/t5/Official-Support-Articles/Force-Qlik-NPrinting-to-automatically-close-idle-QV-exe/ta-p/1827411

Did you use the default value or customize it?

Re: NPrinting Leaves Open Sessions In QlikView

Frank_S — Tue, 12 Nov 2024 19:09:16 GMT

Then what you may be encountering @lgtsotrsdh are unsupported QVW items.

Please check these carefully in all QVWs associated with the NPrinting report including any binary loaded QVWs.

Unsupported QlikView objects

Kind regards...

ps: the workaround is to create QVW copies, remove those from the copies and use the copied QWVs for reporting purposes.

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

Also ensure your NPrinting service user account is not shared with any other QlikView or NPrinting server environment services.

Dedicated NPrinting Server & Engine Service Accoun... - Qlik Community - 1716056

Re: NPrinting Leaves Open Sessions In QlikView

David_Friend — Tue, 12 Nov 2024 19:12:07 GMT

ah SMH Frank is right I forgot those!