topic Re: Nprinting - Cycling in Qlik NPrinting

Nprinting - Cycling

FrankC — Thu, 26 Aug 2021 15:54:28 GMT

Hello

Is there a log that keep tracks of what values are processed? I have a report that works fine. It creates 715 PDF files. The problem is there should be 718. I have added an on-demand option (clone of the report with cycle unchecked) and when I select one of the missing values, the report is generated just fine. I am not sure why the file isn't being generated during the main execution.

Any thoughts on how to debug?

Re: Nprinting - Cycling

Frank_S — Thu, 26 Aug 2021 16:37:24 GMT

Hi @FrankC

So just to be clear.

The issue is with your NPrinting Publish Task which contains a report that has a cycle enabled for it?
Have you checked Qlik Sense for unsupported items like 'always one selected' fields, alternate states etc? https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/GettingStarted/HowCreateConnections/Connect-to-QlikSense-apps.htm#anchor-1
Check filter rules: there is the possibility that you have a filter conflict resuling for example in an 'empty set' message in the logs. Ie: a report filter and publish task filter. This could cause the issue in the publish task and could by why you don't see the issue is the On Demand report execution. See filter rules: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-3

Troubleshooting suggestions:

ensure there are no unsupported items
ensure no filter rules are broken
in the NP web console at 'Admin>Task Executions>click the task name and review the execution log messages for the task
open the NP engine, Web engine and scheduler log files and look for specific errors associated with the execution time of the publish task. Empty set or some other filter error may become evident.

Kind regards...

Re: Nprinting - Cycling

Lech_Miszkiewicz — Thu, 26 Aug 2021 22:26:44 GMT

Hi,

1. Frank suggestion regarding filters is right. Very important thing to remember is how Qlik Sense works and how associative engine works. Scenario which you have may be possible when you have a filter which excludes yours 3 values from your possible selection, however your charts can have set analysis to negate those filters. This can cause situation in which 3 of your values are not available in cycle (since they are excluded by selection) but are available in the chart as set analysis can be ignoring filters applied. I know - since you have tested it with OnDemand it should work anyway though!

2. When generating reports is it possible that you could have some sort of filter you were not aware of? like user filter or section access?

3. The other thing would be to check what are the characters used in the cycled field - if there are some charachters which are not allowed in filenames it can be a cause of those not generating. In that case I would try to autonumber this field in data load script (or create autonumbered copy of that field) and try to run cycle through that

I hope it makes sense.

Re: Nprinting - Cycling

Ruggero_Piccoli — Fri, 27 Aug 2021 07:05:32 GMT

Hi,

When you create a cycle you have to include the cycled field in the output file name. You can place it as first so you can order generated fields by that field. Then you can do a dir *.xlsx > list.txt (I suppose you are generating Excel reports otherwise change the extension) to have the complete list of generated reports in a file, import the list.txt in Excel and compare it with the list of distinct values of the cycled field exported from Qlik. That should helps you in understanding which are the missing values.

You can also create a Qlik variable that contains the GetCurrentSelections() results and place it in the template or in the file name (pay attention to respect Windows file names rules in this case) to check if there are other filters applied.

I suppose that you are sure that the 3 missing values are available in the source app.

Best Regards,

Ruggero

Re: Nprinting - Cycling

Digvijay_Singh — Mon, 30 Aug 2021 13:43:42 GMT

What do you see if you apply new filter with those 3 missing filter values to your main execution?