topic Re: Nprinting in Qlik NPrinting

Nprinting - Cache generating multiple times through script

Vinn_Qlik — Sat, 18 Apr 2020 10:17:42 GMT

Hi ALL,

We have Nprinting reports, Generate connection cache shows the status as completed, but it wont publish the report and again it will start generate connection cache automatically.

Qlik NPrinting September 2018 SR2 - Version: 18.29.9.0

Qlik Sense November 2018 patch 3 - qliksense server 12.44.5

Re: Nprinting

Lech_Miszkiewicz — Thu, 16 Apr 2020 12:48:37 GMT

I have never heard of such behaviour so i suspect it is something you have in your setup.

Do you have any triggers setup on connection metadata reload
do you use any scripts, like RestFull API to trigger reports?

we need a lot more information to help as your description is to generic to answer such unusual behaviour

Re: Nprinting

Ruggero_Piccoli — Thu, 16 Apr 2020 14:09:44 GMT

Hi,

Connection cache can be triggered to be regenerated automatically, so check if you have defined a trigger.

Then please supply more details so we can better understand the problem .

Best Regards,

Ruggero

Re: Nprinting

Vinn_Qlik — Sat, 18 Apr 2020 09:59:06 GMT

Hi Lech,

Thanks for the Quick response. Please find the below inline comments for more details.

Do you have any triggers setup on connection metadata reload

No , there are no triggers setup in Nprinting

do you use any scripts, like RestFull API to trigger reports?

Yes , we are publishing reports through scripts ( REST API ) only.

Issue : We are triggering the reports through script. It is scheduled/run in QMC, on few occasions ( Generate connection cache - task in nprinting ) is getting triggered multiple times but publish report is triggered only once.I have attached screenshot here for reference.

Kindly share your feedback. Thanks again for prompt response.

Re: Nprinting

Vinn_Qlik — Sat, 18 Apr 2020 10:03:39 GMT

Hi Ruggero,

Thanks for the Quick response.

No , there are no triggers setup in Nprinting. We are triggering/publishing reports through scripts, like RestFull API only.

Kindly share your feedback. Thanks again for prompt response.

Re: Nprinting

Lech_Miszkiewicz — Sat, 18 Apr 2020 13:03:41 GMT

Its your script issue then not nprinting issue.
share your script so we can see what you are doing wrong.

you can also try using my library. Check it out on https://nprintingadventures.com

Re: Nprinting

Vinn_Qlik — Sun, 19 Apr 2020 03:34:27 GMT

Hi ,

Thanks for sharing the above link.

Please find the attached qvf file which we are using to trigger the reports. Please not that Issue is not occurring on daily basis, it is intermittent. In recent times, it is occurring very often. Could you validate the script and help us. Meanwhile, I will go through my library.

Regards,

Ravi

Re: Nprinting

Lech_Miszkiewicz — Sun, 19 Apr 2020 23:04:20 GMT

Hi,

there is nothing in your scriptwhat would indicate why reload metadata task is running so many times. You may want to look also at your script log.

As an alternative you may want to use my library.

The other comment is - why are you reloading metadata wit every task run? Do you use LOCAL QlikView connection as source of your report? If not I would simply remove it from the script.

cheers

Lech

Re: Nprinting

Vinn_Qlik — Mon, 20 Apr 2020 07:21:12 GMT

Hi Lech,

Thanks

Could you please provide the updated script. So that will run and check if we are able to reproduce the issue at our end.

Thanks

Ravi.

Re: Nprinting

Lech_Miszkiewicz — Mon, 20 Apr 2020 07:37:23 GMT

Hi,

I have already given you link to my blog and repository

https://nprintingadventures.com

you need to configure it on your end

Re: Nprinting

Lech_Miszkiewicz — Thu, 23 Apr 2020 04:47:38 GMT

Hi @Vinn_Qlik & @Ruggero_Piccoli

I came back to this topic because i think there is a bug in NPrinting.

I observed similar behaviour on one of the tasks I am executing via API. I am sending single POST method, but then task gets triggered multiple times.

I am not sure if this is something on NPrinting side or maybe (in my case) Qlik Sense REST connector... If the issue persist then I will log a support case re this.

You may want to do the same as it will be easier to troubleshoot or replicate once we have data from multiple environmnets.

I am gathering logs now to see if there is anything in them

cheers

Lech

Re: Nprinting

Vinn_Qlik — Thu, 23 Apr 2020 07:07:34 GMT

Hi Lech,

@Lech_Miszkiewicz - Thanks for the below update. We will also gather the logs and will log a case with Qlik .

Kindly requesting you to keep us posted if you come across any alternate solution to this.

Regards,

Ravi

Re: Nprinting

Lech_Miszkiewicz — Thu, 23 Apr 2020 08:05:42 GMT

Purely from NPrinting point of view and Qlik Sense load script we are using I don't see anything what would trigger reload multiple times.

I am assuming it has something to do with actual RESTFull API call over REST connector which I am not an expert in and dont know how to debug.

You may want to turn on DEBUG mode on REST, NPrinting and Qlik Sense logs to gather as much data as it is required for possible support case. Check help site on how to do this!

Re: Nprinting

Lech_Miszkiewicz — Thu, 23 Apr 2020 08:09:06 GMT

BTW -

which version of Qlik Sense are you currently on?
Did you upgrade recently?
Is this issue new or persistent? (maybe it started since you upgraded Qlik Sense -assuming that you did an upgrade)?

Answering those questions would possibly allow us to narrow it down to one of the components...

In my case this is new and started recently when I upgraded to Qlik Sense February 2020

Re: Nprinting

Ruggero_Piccoli — Thu, 23 Apr 2020 08:38:36 GMT

Hi @Lech_Miszkiewicz @Vinn_Qlik ,

Please link this conversation in the support ticket. At the moment I'm not aware of a similar bug so I think it is better to investigate.

Best Regards,

Ruggero

Re: Nprinting

Lech_Miszkiewicz — Thu, 23 Apr 2020 09:00:18 GMT

Hi @Ruggero_Piccoli ,

sure I will.

it will be hard one to investigate as issue is hard to replicateand and does not always happen. For me it just started few days ago - I didn't even noticed it until one of the users asked me why we are sending the same report 2,3 sometimes more times minute after minute...When I sterted looking at report generation history i noticed that it started happening since we did upgrade..

unfortunatelly I cannot now link it to either Qlik Sense or NPrinting upgrade as both were done in very close time.

anyways - I will keep you posted.

I am going to observe this closely now and will log ticket once I am confident that there is nothing wrong with the way i set it up.

Re: Nprinting

blaise — Thu, 23 Apr 2020 13:37:33 GMT

Can it be QS that does some sort of profiling of the data and/or check's the data connections?

I've had issues recently with a project Im working on where i create app+connection+report in the QS script. If i duplicate this app (the script uses the documentName() as app id for the created NP connection) and press the Data button (instead of menu - data load editor) i can see that my post calls are sent to NP. This should be a "as standard the user would like to go to Data Manager instead of data load editor" issue but i just wanted to point it out if that can be of any help.

Either sense (proxy) log or rest connector log should show multiple attempts I guess. I will also keep a closer look at my API calls.

Re: Nprinting

Lech_Miszkiewicz — Thu, 23 Apr 2020 23:12:15 GMT

Hi @blaise

well - I still don't know, but I can confirm indeed that one random app reload (or i should say NPrinting publish Task) trigger happend when i just duplicated app and jumped between Analysis/Data views (UI, load script).

In my case strange thing is that this also happens when reload simply runs from QMC Task.

I am more and more convinced that this has something to do with Qlik Sense behaviour.... lets keep an eye on it!

Re: Nprinting - Cache generating multiple times through script

Lech_Miszkiewicz — Mon, 27 Apr 2020 01:42:46 GMT

Hi @Vinn_Qlik

is the qvf you have sent me the exact one you are using to trigger your nprinting task?

Can you send me a qliksense task script log from the execution which triggered multiple metadata reloads?

or if you prefer we can take it offline. PM me and we may just quickly schedule a zoom to look at it. Cheers

Re: Nprinting - Cache generating multiple times through script

Lech_Miszkiewicz — Wed, 06 May 2020 09:00:30 GMT

Hi @Ruggero_Piccoli

yesterday I had a chat with @Vinn_Qlik and I reviewed his script. My conclusion is that the issue is sitting in Qlik Sense and the way Qlik Sense is handling reload tasks.

What we observed was that for all tasks where we had multiple "cache generations" in NPrinting we also had multiple attempts to run task by scheduler. This was visible in Qlik Sense monitoring apps when you look at the stages of particular reload task. It went through multiple stages and investigating it showed that task was "Triggered"-->"FinishedFailure"--> "Retry"-->(here on depending on the day there were multiple instances of "FinishedFailure"--> "Retry")and finally --> "FinishedSuccess".

In shor number of task executions in NPrinting was equal to number of retries.

I conclude this is not NPrinting issue or script issue. It is just something wrong with Qlik Sense environment (or maybe even it is working as designed). If @Vinn_Qlik wants to investigate further I guess he needs to open support ticket and work with support to troubleshoot those reloads with "FinishedFailure" statuses.

cheers

Lech