NPrinting: Verify Filter (empty result) Terminates... - Qlik Community

kruppas78 · ‎2016-01-14

Hi,

is it normal, that when my verify Filter creates an empty result, that the whole Task will be terminated?

My Problem is, that one User did not get a result and all following users dont get it, beause the Task will be terminated.

Is it possible, to use a verify filter (don't want to send empty Reports) and not to terminate the Task?

Thanks for your help!

Log:

Service 14.01.2016 11:27:44 Message Scheduler started

Service 14.01.2016 11:27:44 Message Reloaded QlikView NPrinting files

Service 14.01.2016 11:29:00 Message Service: event started

Service 14.01.2016 11:29:00 Message Run Schedule: VI Versenden Only

Service 14.01.2016 11:29:00 Message Run Job: VI Reports versenden Only

Service 14.01.2016 11:29:00 Message Run Task: Tages VI versenden

Service 14.01.2016 11:29:10 Message Open file: E:\proALPHA-QlikView\Data\VI\VI_Applikation.qvw

Service 14.01.2016 11:29:29 Information QlikView version: 11.20.12235.0

Service 14.01.2016 11:29:29 Message Clear all selections: E:\proALPHA-QlikView\Data\VI\VI_Applikation.qvw

Service 14.01.2016 11:29:29 Message Creating output folder: C:\Temp\NPrinting_Temporary_CC3CE67776F2454B95C459ADC7368D45\

Service 14.01.2016 11:29:29 Message Output folder created: C:\Temp\NPrinting_Temporary_CC3CE67776F2454B95C459ADC7368D45\

Service 14.01.2016 11:29:29 Message Creating output folder: C:\Temp\NPrinting_Temporary_Distribution_CE1C04F009DB486D9795BE274475BDD0\

Service 14.01.2016 11:29:29 Message Output folder created: C:\Temp\NPrinting_Temporary_Distribution_CE1C04F009DB486D9795BE274475BDD0\

Service 14.01.2016 11:29:29 Message Apply filter: Jahres_Monatsfilter

Service 14.01.2016 11:29:29 Warning Warning (verify filter): filter created empty result: MainDateYear {year(now()): 2016}

Service 14.01.2016 11:29:29 Message Terminate Task: Tages VI versenden

Service 14.01.2016 11:29:29 Message This task took 29 seconds to execute

Daniel_Jenkins · ‎2016-01-14

Hi Stefan,

From the log entries you provided it seems like an empty result (for all users) was returned after applying the filter Jahres_Monatsfilter. What are you expecting? Could you post a sample project (QVW, NSQ & Report Template) and also a sample final report showing what you expect?

- Daniel.

kruppas78 · ‎2016-01-15

here some Screens and part of the logfile.

all other recipients get a result and a Report. Only one User has an empty result and NPrinting Stops at this user.

Daniel_Jenkins · ‎2016-01-17

Hi Stefan,

I have tried to replicate the issue without success. I am using QlikView NPrinting 16.3.0.0 (SR3).

I added section access and a filter with verify filter enabled to ensure that the first recipient gets no result. The task showed the warning message and continued with the next recipient as expected. Are you sure that the task is not terminating after the last User/Recipient as it should? If you don't want to share your project here but still want someone to take a closer look I suggest that you open a case with Qlik Support.

Here is my log:

Source Date Time Type Message

Application 18/01/2016 10:08:25 AM Information QlikView NPrinting Designer

Application 18/01/2016 10:08:25 AM Information QlikView NPrinting version: 16.3.0.0

Application 18/01/2016 10:08:25 AM Information Log File: C:\NPrintingTraining\LogFiles\20160118_nprinting.log

Application 18/01/2016 10:08:25 AM Message Run Task: Section Access

Application 18/01/2016 10:08:25 AM Message Start QlikView security with the Elvis user

Application 18/01/2016 10:08:26 AM Message Open file: C:\NPrintingTraining\QlikViewDocuments\SalesDemoSectionAccess.qvw

Application 18/01/2016 10:08:27 AM Information QlikView version: 11.20.12904.0

Application 18/01/2016 10:08:27 AM Message Creating output folder: C:\NprintingTraining\Temp\NPrinting_Temporary_C4C6970A58AA4583BE641C85C86DA810\

Application 18/01/2016 10:08:27 AM Message Output folder created: C:\NprintingTraining\Temp\NPrinting_Temporary_C4C6970A58AA4583BE641C85C86DA810\

Application 18/01/2016 10:08:27 AM Message Creating output folder: C:\NprintingTraining\Temp\NPrinting_Temporary_Distribution_C55377DCB17F415A95C74C150E22A43D\

Application 18/01/2016 10:08:27 AM Message Output folder created: C:\NprintingTraining\Temp\NPrinting_Temporary_Distribution_C55377DCB17F415A95C74C150E22A43D\

Application 18/01/2016 10:08:27 AM Message Start Load Task

Application 18/01/2016 10:08:27 AM Message End Load Task

Application 18/01/2016 10:08:27 AM Message Start Execute Task

Application 18/01/2016 10:08:27 AM Message Start Section Access

Application 18/01/2016 10:08:27 AM Message Apply filter: AinoShoes

Application 18/01/2016 10:08:27 AM Warning Warning (verify filter): filter created empty result: ProductName {Aino Shoes}

Application 18/01/2016 10:08:27 AM Message End Section Access

Application 18/01/2016 10:08:27 AM Message End Execute Task

Application 18/01/2016 10:08:27 AM Message Start Output Distribution

Application 18/01/2016 10:08:27 AM Message End Output Distribution

Application 18/01/2016 10:08:27 AM Message Close file: C:\NPrintingTraining\QlikViewDocuments\SalesDemoSectionAccess.qvw

Application 18/01/2016 10:08:27 AM Message Start QlikView security with the Helen user

Application 18/01/2016 10:08:28 AM Message Open file: C:\NPrintingTraining\QlikViewDocuments\SalesDemoSectionAccess.qvw

Application 18/01/2016 10:08:28 AM Information QlikView version: 11.20.12904.0

Application 18/01/2016 10:08:28 AM Message Creating output folder: C:\NprintingTraining\Temp\NPrinting_Temporary_056698874E0A449CB17733AA32E4B90F\

Application 18/01/2016 10:08:28 AM Message Output folder created: C:\NprintingTraining\Temp\NPrinting_Temporary_056698874E0A449CB17733AA32E4B90F\

Application 18/01/2016 10:08:28 AM Message Creating output folder: C:\NprintingTraining\Temp\NPrinting_Temporary_Distribution_A23A0540A7894BC594401BDE839E08D3\

Application 18/01/2016 10:08:28 AM Message Output folder created: C:\NprintingTraining\Temp\NPrinting_Temporary_Distribution_A23A0540A7894BC594401BDE839E08D3\

Application 18/01/2016 10:08:29 AM Message Start Load Task

Application 18/01/2016 10:08:29 AM Message End Load Task

Application 18/01/2016 10:08:29 AM Message Start Execute Task

Application 18/01/2016 10:08:29 AM Message Start Section Access

Application 18/01/2016 10:08:29 AM Message Apply filter: AinoShoes

Application 18/01/2016 10:08:29 AM Message Filter field: ProductName {Aino Shoes} ()

Application 18/01/2016 10:08:29 AM Message Report type: Excel Workbook (Excel Workbook)

Application 18/01/2016 10:08:29 AM Message Producing report: Section Access

Application 18/01/2016 10:08:32 AM Message Report produced: Section Access

Application 18/01/2016 10:08:32 AM Message Creating report: Section Access (C:\NprintingTraining\Temp\NPrinting_Temporary_056698874E0A449CB17733AA32E4B90F\O00001-F00001.xlsx)

Application 18/01/2016 10:08:32 AM Message Report created : Section Access (C:\NprintingTraining\Temp\NPrinting_Temporary_056698874E0A449CB17733AA32E4B90F\O00001-F00001.xlsx)

Application 18/01/2016 10:08:32 AM Message End Section Access

Application 18/01/2016 10:08:32 AM Message End Execute Task

Application 18/01/2016 10:08:32 AM Message Start Output Distribution

Application 18/01/2016 10:08:32 AM Message Copying file: C:\NPrintingTraining\PersonalFolders\HelenBrolin\Section Access.xlsx

Application 18/01/2016 10:08:32 AM Message Copied file: C:\NPrintingTraining\PersonalFolders\HelenBrolin\Section Access.xlsx

Application 18/01/2016 10:08:32 AM Message End Output Distribution

Application 18/01/2016 10:08:32 AM Message Close file: C:\NPrintingTraining\QlikViewDocuments\SalesDemoSectionAccess.qvw

Application 18/01/2016 10:08:32 AM Message Terminate Task: Section Access

Application 18/01/2016 10:08:32 AM Message This task took 6 seconds to execute

Application 18/01/2016 10:08:32 AM Message -------------------

HTH - Daniel

kruppas78 · ‎2016-03-10

So we deactivated the verify filter and it works. maybe we test it after the next update.

Can be closed.

NPrinting: Verify Filter (empty result) Terminates Task