topic Re: NPrinting Server Connection Stuck On "Generating" in Qlik NPrinting

NPrinting Server Connection Stuck On "Generating"

amweiner — Sat, 24 Sep 2016 03:28:54 GMT

I am having a problem with the On Demand printing feature in NPrinting 17.2.

I upgraded to Qlikview 11.20 SR 15 and NPrint 17.2. I also installed the On Demand feature. Everything seems to have installed correctly (no errors on installation). I ensured that the Nprint service account is assigned to the appropriate groups on the server (Qlikview Administrators and Qlikview Management API). I also set the On Demand trusted server setting.

For setting up the connection, I am following the on demand configuration instructions by setting the connection as a server connection (as opposed to a local connection). After creating the connection, it is stuck in the "Generating" status and never finishes. I am able to generate cache using local connections on the same documents (although somewhat slower to generate than in 17.1).

I did try to create an on demand report using an existing local connection, but the on demand button doesn't surface on AccessPoint.

Questions: To use the On Demand feature, must I use a server connection to the qvw? And if that is the case, what could be causing the cache to never finish generating?

Re: NPrinting Server Connection Stuck On "Generating"

dineshsingh — Sun, 25 Sep 2016 20:55:20 GMT

Hi Ann Weiner,

Please make sure your engine is showing online status in Main Menu > Admin > Engine Manager window. Also, try to restarting NPrinting Services of server/engine. For On-Demand Printing feature, please go thru following links:

QlikView NPrinting On Demand - Qlik NPrinting - YouTube

On-Demand reports ‒ Qlik NPrinting‌

Hope this helps.

Many Thanks,

Dinesh

Re: NPrinting Server Connection Stuck On "Generating"

pauljohansson — Mon, 26 Sep 2016 13:17:47 GMT

I managed to create a data connection 3 days ago using 17.2 to local files and files that are published into the Server.

Today when I need to reload the meta data, it gets stuck at "generating" for all these connections.

Restarting services does not help, the log file says:

"Reload metadata task 3b19040f-b086-4cfc-9345-2b5b66335e01 sent to queue"

Paul

Re: NPrinting Server Connection Stuck On "Generating"

amweiner — Mon, 26 Sep 2016 16:02:55 GMT

Yes, the engine is online. And I did use the configuration steps that are in the YouTube and in the documentation. I restarted all of the services, and still have the same problem.

Re: NPrinting Server Connection Stuck On "Generating"

lars_plenge — Fri, 03 Mar 2017 12:37:43 GMT

Hi Paul

Did you find a solution to your problem? I have the same issue.

Regards

Lars

Re: NPrinting Server Connection Stuck On "Generating"

tka_ovako — Mon, 27 Mar 2017 10:49:47 GMT

Hello.

Same issue here. I tried to restart engine status and also I restarted NPrinting Sevices but problem not solved.

Regards

Timo

Re: NPrinting Server Connection Stuck On "Generating"

Gianluca_Perin — Tue, 28 Mar 2017 07:06:44 GMT

Hi Ann,

try this:

Stop NPrinting Engine service.
Make sure that the NPrinting Engine process is not running from the Windows task manager
Make sure that all the qvw.exe are not running from the Windows task manager
Stop NPrinting Scheduler service
Make sure that the NPrinting Scheduler process Is no more running from the Windows task manager
Stop NPrinting Messaging service (or RabbitMQ service depending on the NPrinting version that you're using)
Start NPrinting Scheduler service
Start NPrinting Messaging service (or RabbitMQ)
Start NPrinting Engine service
Wait for the Engine to came back online
Reload the cache

Let me know if this works.

Best

Re: NPrinting Server Connection Stuck On "Generating"

tka_ovako — Tue, 28 Mar 2017 07:30:14 GMT

Hey Gianluca!

For me that works. We did reboot to our server but that didn't work. I found that Nprint Scheduler prosess was stucked. After killing that process and after restarting Nprinting Scheluder service Nprint works again.

Thanks a lot!

Regards

Timo

Re: NPrinting Server Connection Stuck On "Generating"

amweiner — Tue, 28 Mar 2017 14:25:00 GMT

Yes, I go through the steps of stopping all of the services when ever we have cache generating issues. The problem is that this issue seems intermittent, and is a rather disruptive way to recover. Wish there were more transparency in the administration of NPrint, so that we can see exactly where the failure is and correct it, rather than having to restart everything. My guess is that will be in a future release of Nprinting.

Re: NPrinting Server Connection Stuck On "Generating"

luizcdepaula — Wed, 12 Apr 2017 10:47:14 GMT

Hello Gianluca,

I am having the same issue and I followed your steps to stopping the services. The NPrinting Scheduler service was stuck and I had to stop it from the Windows Task Manager. It stopped. However, the Cache Status is still stuck on Generating.

We tried to reboot the server and still does not work. Do you think I will have to recreate another connection?

Thanks,

Re: NPrinting Server Connection Stuck On "Generating"

luizcdepaula — Wed, 12 Apr 2017 11:13:38 GMT

Just FYI.

When stopping the services, the NPrinting Scheduler service has to be the first one to be started, however, if you don't start the other two services right away, Messaging service and Engine service, the Scheduler will stop, and will not fix the issue.

The process definitely works, just keep in mind that when restarting the services, start one after the other quickly, as soon as it says Running.

Thanks,

Re: NPrinting Server Connection Stuck On "Generating"

kevinpintokpa — Tue, 01 Aug 2017 23:28:03 GMT

Hi Gianluca, gpr‌

I have created this batch file to mirror your suggested order for NPrinting service shutdown and startup. Can you please look at it and offer any feedback?

net stop "Qlik NPrinting Engine"

net stop "Qlik NPrinting Scheduler"

net stop "QlikNPrintingMessagingService"

net stop "Qlik NPrinting Web Engine"

net stop "QlikNPrintingRepoService"

echo Waiting for 30 seconds

timeout /t 30

net start "Qlik NPrinting Scheduler"

net start "QlikNPrintingMessagingService"

net start "QlikNPrintingRepoService"

net start "Qlik NPrinting Engine"

net start "Qlik NPrinting Web Engine"

Re: NPrinting Server Connection Stuck On "Generating"

kevinpintokpa — Tue, 01 Aug 2017 23:41:01 GMT

Bah, for some reason, I cannot edit my own post. I tweaked the order a little and here it is:

net stop "Qlik NPrinting Engine"

net stop "Qlik NPrinting Scheduler"

net stop "Qlik NPrinting Web Engine"

net stop "QlikNPrintingMessagingService"

net stop "QlikNPrintingRepoService"

echo Waiting for 30 seconds

timeout /t 30

net start "Qlik NPrinting Scheduler"

net start "QlikNPrintingMessagingService"

net start "QlikNPrintingRepoService"

net start "Qlik NPrinting Engine"

net start "Qlik NPrinting Web Engine"

This seems to work without any error or warning messages.

Re: NPrinting Server Connection Stuck On "Generating"

Gianluca_Perin — Wed, 02 Aug 2017 07:19:36 GMT

Hi Kevin,

the first part is fine.

For the second one I would say:

net start "QlikNPrintingRepoService" (Database)

net start "QlikNPrintingMessagingService" (Queuing system that carries messages from scheduler to engine)

net start "Qlik NPrinting Scheduler"

net start "Qlik NPrinting Engine"

net start "Qlik NPrinting Web Engine"

Best

Re: NPrinting Server Connection Stuck On "Generating"

kevinpintokpa — Wed, 02 Aug 2017 21:40:13 GMT

Great. I tried out the changes and they seem to work fine.

For those interested, place the following lines into a .cmd or .bat file:

net stop "Qlik NPrinting Engine"

net stop "Qlik NPrinting Scheduler"

net stop "Qlik NPrinting Web Engine"

net stop "QlikNPrintingMessagingService"

net stop "QlikNPrintingRepoService"

echo Waiting for 30 seconds

timeout /t 30

net start "QlikNPrintingRepoService"

net start "QlikNPrintingMessagingService"

net start "Qlik NPrinting Scheduler"

net start "Qlik NPrinting Engine"

net start "Qlik NPrinting Web Engine"

Re: NPrinting Server Connection Stuck On "Generating"

Lech_Miszkiewicz — Thu, 03 Aug 2017 03:42:07 GMT

First thing is:

OnDemand functionality is supported only with server connection!

note from help documentation:

You must have connections to your QlikView Server.

QlikView Server and QlikView Cluster connections are supported with On-Demand. Local connections are unsupported for On-Demand. See Creating connections .

https://help.qlik.com/en-US/nprinting/June2017/Content/On-Demand/Install-Components.htm

To create server (qvp) connection you must ensure that NPrinting service account user is:

local administrator on QlikView server
QlikView administrator on QlikView server
Is a dedicated NPrinting account and it is not used by any other service

I have gone step by step with everything here:

How to connect Qlik N printing 17.4 to Qlik View server

now regarding to your problem.

As you are on older NPrinting version i would suggest to upgrade to nPrinting June 2017. In your current setup you may have stale generate metadata task which is never ending.

If you do not want to upgrade, delete this stale connection, restart NPrinting server and start over using all steps provided in link.

cheers

Lech

---------------------------------------------

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.