4 Replies Latest reply: Mar 10, 2016 3:45 AM by Stefan Jacobi RSS

    NPrinting: Verify Filter (empty result) Terminates Task

    Stefan Jacobi

      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

        • Re: NPrinting: Verify Filter (empty result) Terminates Task
          Daniel Jenkins

          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.

            • Re: NPrinting: Verify Filter (empty result) Terminates Task
              Stefan Jacobi

              here some Screens and part of the logfile.

               

              NP_Filter.jpg

               

              NP_Recipients.jpg

               

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

                • Re: NPrinting: Verify Filter (empty result) Terminates Task
                  Daniel Jenkins

                  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

              • Re: NPrinting: Verify Filter (empty result) Terminates Task
                Stefan Jacobi

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

                 

                 

                Can be closed.