topic Re: Nprinting job runs indefinitely in Qlik NPrinting

Nprinting job runs indefinitely

mgranillo — Fri, 17 Nov 2017 21:38:47 GMT

Anyone had issues with a scheduled Nprinting job not stopping and running for hours?

I reviewed the logs and no error was present but log entries did stop generating at 5:45 when our first job of the day is scheduled to run. Here's the log on the failure:

Service 11/10/2017 5:45:00 AM Message Run Job: Import Recipients and Email Report

Service 11/10/2017 5:45:00 AM Message Run Task: Import Recipients

Service 11/10/2017 5:45:00 AM Message Creating output folder: C:\NPrinting\Temp\NPrinting_Temporary_1DE1F9A937EE4CD891AF83EA6BEC3A05\

Service 11/10/2017 5:45:00 AM Message Output folder created: C:\NPrinting\Temp\NPrinting_Temporary_1DE1F9A937EE4CD891AF83EA6BEC3A05\

Service 11/10/2017 5:45:00 AM Message Creating output folder: C:\NPrinting\Temp\NPrinting_Temporary_Distribution_124D22566AA64222A3C8599BA0CBA26F\

Service 11/10/2017 5:45:00 AM Message Output folder created: C:\NPrinting\Temp\NPrinting_Temporary_Distribution_124D22566AA64222A3C8599BA0CBA26F\

Service 11/10/2017 5:45:00 AM Message Start Execute Task

Service 11/10/2017 5:45:00 AM Message Start Recipient Imports

Service 11/10/2017 5:45:00 AM Message Run recipient import "Import"

Service 11/10/2017 2:57:14 PM Information Service - QlikView NPrinting Designer

Service 11/10/2017 2:57:14 PM Information QlikView NPrinting version: 16.6.0.0

Service 11/10/2017 2:57:14 PM Information Log File: C:\NPrinting\Log\20171110_NPrintingSvc.log

I eventually found no reports had generated around 3 PM and restarted the server. That's why entires start again at 2:57PM

Is there any way to be alerted about this? The only way I found out about this was our users started asking why they hadn't received their daily reports.

Re: Nprinting job runs indefinitely

Lech_Miszkiewicz — Sun, 19 Nov 2017 22:34:45 GMT

Hi,

there is no automated process to alert you about failed jobs/tasks.

In NPrinting 16 i used to:

Create a QV app reading NPrinting Log Files
Create a NPrinting Excel Report showing most recent logs
1. Schedule this report after each report i generated with NPrinting
2. then i had 3 scenarios:
  1. if i did not receive a log report i knew jobs are stucked
  2. if did receive a report with errors - they were highlighted
  3. i receive a report that everything went OK

It is not an ideal solution, but it was giving me overview how my tasks were running.

regards

Lech

Re: Nprinting job runs indefinitely

mgranillo — Mon, 20 Nov 2017 14:16:59 GMT

Lech,

Thanks for the solution. That should do the job. Not ideal, like you said, since we have lots of jobs so this will generate lots of emails but better than nothing.

Mike

Re: Nprinting job runs indefinitely

mgranillo — Wed, 22 Nov 2017 17:27:45 GMT

A solution I implemented was a python script that reads the error log and generates an output error report. Then I setup an email that sends only if there's an error in the output. If anyone is interested, let me know, I can write up some instructions on how to implement.

Re: Nprinting job runs indefinitely

Arthur_Fong — Thu, 04 Jan 2018 09:39:59 GMT

Hi Michael,

Can you please list down the instructions to implement this email alert?

Thanks and regards,

Arthur Fong

Re: Nprinting job runs indefinitely

mgranillo — Fri, 05 Jan 2018 15:38:09 GMT

I've posted a document: Python Nprinting Scheduled Job Report