article NPrinting Schedule Monitor (NP17+) and Failed Task reporting in Member Articles

NPrinting Schedule Monitor (NP17+) and Failed Task reporting

marcginqo — Mon, 23 Sep 2019 19:21:48 GMT

This article gives an overview of a Qlik Sense app I created to get a calendar like view of scheduled NPrinting task in you environment as well as automated failed task reporting from Qlik Sense app.

Re: NPrinting Schedule Monitor (NP17 & 18) and Failed Task reporting

Stephen_Jasionowski — Tue, 16 Jul 2019 15:51:01 GMT

Awesome work, Marc! This will be a very valuable addition to the product

Re: NPrinting Schedule Monitor (NP17+) and Failed Task reporting

userid128223 — Fri, 31 Jul 2020 11:50:36 GMT

Can i create a local copy of repository database on my laptop and use QlikSense desktop to connect via your app? I understand it will not be live view but would it work?

Re: NPrinting Schedule Monitor (NP17+) and Failed Task reporting

marcginqo — Wed, 05 Aug 2020 14:40:24 GMT

Hi @userid128223

Yes, that should work. You have to create a connection to your Postgres database and this will be used to retrieve data. You set change this line of code in the app:

SET vNPRepoConnection = <connection name>'

You also need the REST API's because not all the information can be retrieved from the database, for example the upcoming tasks (I think this is initially what you where looking for).

If you have any questions please let me know.

Marc

Re: NPrinting Schedule Monitor (NP17+) and Failed Task reporting

userid128223 — Thu, 06 Aug 2020 13:00:22 GMT

Hi Marc

Anyway you can publish same app for QlikView?

Re: NPrinting Schedule Monitor (NP17+) and Failed Task reporting

marcginqo — Fri, 21 Aug 2020 20:00:55 GMT

Hi @userid128223 ,

There is no QlikView version available, I'm sorry.

Marc

Re: NPrinting Schedule Monitor (NP17+) and Failed Task reporting

florent1 — Wed, 13 Jul 2022 15:58:44 GMT

Hello @marcginqo,

Thank you so much for this ! I've been using it very regularly for a couple years, it is very helpful.

However, do you think it would be possible for you to explain how to retrieve the execution tasks logs ?
I'm pretty sure a table exists, but I can't find it.
My need here is to know which tasks didn't go through because of a condition evaluated to false.

Thank you,

Florent

Re: NPrinting Schedule Monitor (NP17+) and Failed Task reporting

marcginqo — Sat, 24 Sep 2022 03:32:15 GMT

Hi @florent1,

Sorry for the very late reaction. I will look I to this next week and let you know as soon as possible what the options are.

Marc

Re: NPrinting Schedule Monitor (NP17+) and Failed Task reporting

marcginqo — Mon, 26 Sep 2022 15:25:46 GMT

Hi @florent1

I'm not sure if there is a way of getting information regarding the tasks that did not go through due to a condition set.

There might be something in the NPrinting PostgreSQL database that is used in the Schedule Monitor as well. I could not find a part in the API's that will give you that information.

In the Schedule Monitor there is a piece that loads data regarding Task Executions but no condition status in there.

Maybe @Stephen_Jasionowski knows about this.

Marc