topic Re: NPrinting connections stuck on generating in Qlik NPrinting

NPrinting connections stuck on generating

bethany_ — Wed, 25 Sep 2019 18:40:54 GMT

Hello all,

We have just started using NPrinting (we've got version 17.6) and are having difficulty with reloading the caches. We have two files that trigger overnight (2am and 4am), but in the last two weeks they just stay on 'generating', until the next morning when the previous attempt aborts and the new attempt starts. Trying to manually reload metadata doesn't work either on the two files, or on other connections.

I've verified the connection and that seems to work fine - we previously had a licencing issue when that was run, but that has been resolved. I've checked the licence activation and it all seems happy - I'm at a bit of a loss as to where the issue is. Any suggestions on where I can look next?

Thanks!

Re: NPrinting connections stuck on generating

Daniel_Jenkins — Thu, 12 Apr 2018 00:40:27 GMT

Hi Bethany,

What type of Connection (QlikView local/server/cluster, Qlik Sense)? If QlikView and not Local, does the version of QV Desktop used match the version of QV Server used?

What do the NPrinting logs say?

- Daniel.

Re: NPrinting connections stuck on generating

Ruggero_Piccoli — Thu, 12 Apr 2018 08:32:19 GMT

Hi,

I would to suggest you to upgrade to February 2018. There is this solved bug:

Cache and metadata reload from QlikView Server remained in Generating status

The cache and metadata reload process of some QlikView Server connections remained in Generating status forever.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.

Re: NPrinting connections stuck on generating

bethany_ — Thu, 12 Apr 2018 08:45:49 GMT

Hi Daniel,

It's a server connection, and desktop and server versions match.

On checking the task executions, it does show the progress as 0% and the elapsed time of 00:00 even though the event triggered nearly 6 hours ago - it looks like it's saying triggered but not actually doing anything

Thanks

Bethany

Re: NPrinting connections stuck on generating

bethany_ — Thu, 12 Apr 2018 13:08:50 GMT

Hi Ruggero,

We've installed the Feb 18 upgrade and it seems to be working now! Thank you

Re: NPrinting connections stuck on generating

Lech_Miszkiewicz — Fri, 13 Apr 2018 02:07:50 GMT

yeeeeep

I battled this for soooo long time until it was called a BUG

It was a quite rare behaviour though.

glad that Feb 2018 solves it. cheers Lech

Re: NPrinting connections stuck on generating

pnowicki — Thu, 02 Aug 2018 21:41:21 GMT

After upgrading to June 2018 from November 2017, all of our metadata needed to be re-generated across all our Nprinting reports. Trying to do so now and generating the cache is stalled, taking forever without any progress. Followed all of the tips on the community website, but to no avail. I think we are going to roll back to our backup of November 2017.

Re: NPrinting connections stuck on generating

Lech_Miszkiewicz — Thu, 02 Aug 2018 23:24:40 GMT

Hi Paul, What does connection verification say when you are running it?

Re: NPrinting connections stuck on generating

Ruggero_Piccoli — Fri, 03 Aug 2018 07:03:00 GMT

Hi,

Check the logs if there are some specific error messages. Refreshing the caches after an upgrade is normal because from a version to a newer the cache could be different to manage new feature. Of course the metadata reload process must work fine.

If the problem persist please open a support ticket so one of us can remotely connect with you to deeper investigate.

Best Regards,

Ruggero

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

Re: NPrinting connections stuck on generating

bethany_ — Fri, 03 Aug 2018 08:23:30 GMT

Yes, we've got this issue back again. After we upgraded to Feb 18 it was working fine, now we've upgraded to June 18 it's stopped working again. I'm wondering if Nprinting is the correct platform for us to produce reporting on seeing how it's so temperamental.

Re: NPrinting connections stuck on generating

Ruggero_Piccoli — Fri, 03 Aug 2018 14:36:37 GMT

Hi,

We cannot deeper investigate via community messages. Please open a support ticket. Attach the whole logs and the versions of the software you are using. If possible attach a copy of the original app or document also with scrambled or reduced data. We need everything that will be useful to reproduce the issue. Thanks.

Best Regards,

Ruggero

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

Re: NPrinting connections stuck on generating

singambd — Tue, 05 Feb 2019 10:41:26 GMT

Hi Ruggero,

Issue:-

I am trying to generate in NPrinting QlikView connection it is running for long time. Version Sep 2018.

I am facing the connection generation issues in Sep 2018 version also . Can you please guide me any other options.

Regards,

Singam

Re: NPrinting connections stuck on generating

singambd — Tue, 05 Feb 2019 10:42:06 GMT

Hi Ruggero,

Issue:-

I am trying to generate in NPrinting QlikView connection it is running for long time. Version Sep 2018.

I am facing the connection generation issues in Sep 2018 version also . Can you please guide me any other options.

Regards,

Singam

Re: NPrinting connections stuck on generating

Frank_S — Tue, 05 Feb 2019 16:20:19 GMT

Check the following article which may contain the solution you are looking for.

https://support-cdn.qlik.com/articles/000028729

Re: NPrinting connections stuck on generating

renuka_sasikumar — Wed, 27 Feb 2019 07:24:00 GMT

Hi @Ruggero_Piccoli ,

I was also facing the same issue, Yesterday I upgraded to N Printing February 2019, still the same error.

February 27, 2019 12:02:36 PM Error Cache generation failed: Exceeded maximum number of retries. Check logs for details.

Here the client is planning for up gradation, the connection was getting generated previously, suddenly from last two days, it's a fluctuation, now completely in error. If this continues, they will drop the plan of Upgradation & will continue with v16.

Please kindly suggest if anything.

Regards,

Renuka S

Re: NPrinting connections stuck on generating

singambd — Wed, 27 Feb 2019 07:35:32 GMT

Hi Ranuka,

According to my analysis this will happen.

1. Due to the environment which is not configured as per the Qlik suggested It means Ram and Cores .

2. Connection get stuck for this we need to restart the service after restarting the service also still the task status in generating status then we need to re boot the server.

Thanks and Regards,

Singam

Re: NPrinting connections stuck on generating

Ruggero_Piccoli — Wed, 27 Feb 2019 15:08:50 GMT

Could this help?

Upgrade to November 2018 or newer

If you are upgrading to April 2019 from September 2018 SR2 included or older version you must:

Open port 4997 outbound on Qlik NPrinting Server and inbound on all Qlik NPrinting Engines
Reinstall all your Qlik NPrinting Engines and providing a password for certificate exchange
Open the Engine manager in the Web Console
Open the detail page for each Engine and send the certificate after inserting the same password you used during the engines reinstallation

Qlik NPrinting Engines stay offline until the certificate exchange is performed. Older Engine versions cannot connect to a Qlik NPrinting April 2019 Server

Best Regards,

Ruggero

Re: NPrinting connections stuck on generating

renuka_sasikumar — Fri, 01 Mar 2019 07:29:17 GMT

Thank You, This helped me.