NPrinting Newsstand report generates Blank Report

[swapnil_kumbhar]

Hi Everyone,

We have NewsStand report which is generated based on user level filter applied to it.Currently we are facing issue that sometimes it generates blank reports & empty report is sent to users. When we run it again then it works fine.

I have checked the logs for same & following are the findings.

Scheduler Logs:

 1. Failed generation of report XYZ for user XYZ. ERROR: System.Exception: Filters applied to user and report XYZ define an empty set.

Engine Logs:

1. Exception during content resolution while processing request {"FilterSequenceToMaterialize":{"Filters":[{"Fields":[{"Name":"F\\UserFilter","OverrideValues":true,"SelectExcluded":false,"QvDataConnectionId":"XYZ","Values":[{"Type":1,"StringValue":"Value"}],"IsVoid":false},{"Name":"F\\_TaskFilter","OverrideValues":false,"SelectExcluded":false,"QvDataConnectionId":"XYZ","Values":[{"Type":1,"StringValue":"Yes"}],"IsVoid":false}],"Variables":[]}]},"TransformationId":"XYZ","EmptyStrategy":0,"RequestId":"XYZ","ResponseMetadata":{"TransformationId":"XYZ","RetriesAttempt":0},"ConnectionId":"XYZ","ConnectionString":"navigator=qliksense;proxyurl=https://Qlik Sense Server/;appid=XYZ;identity=Domain\\user","StatsCorrelationId":"FilterMaterializationExecution","Filter":{"Filters":[]},"Priority":5,"MaxRequestDurationInMinutes":720,"CanTriggerMoreRequests":false,"ExecutionId":"XYZ"}

2. Filters for request {"ColumnId":"O\\XYZ\\($Field$)\\=[XYZ w/ Credentials]","KeepSourceFormats":true,"TablePropertyValues":{},"ObjectId":"O\\XYZ","PropertyValues":{},"TransformationId":"XYZ","EmptyStrategy":0,"RequestId":"XYZ","ResponseMetadata":{"TransformationId":"XYZ","RetriesAttempt":0},"ConnectionId":"XYZ","ConnectionString":"navigator=qliksense;proxyurl=https://Qlik Sense Server/;appid=XYZ;identity=Domain\\userid","StatsCorrelationId":"Qlik.Reporting.Engine.Messages.Requests.ColumnNodeRequest.O\\XYZ","Filter":{"Filters":[{"Fields":[{"Name":"F\\Filter1","OverrideValues":true,"SelectExcluded":false,"QvDataConnectionId":"XYZ","Values":[{"Type":1,"StringValue":"Value"}],"IsVoid":false},{"Name":"F\\_Fliter2","OverrideValues":false,"SelectExcluded":false,"QvDataConnectionId":"XYZ","Values":[{"Type":1,"StringValue":"Yes"}],"IsVoid":false}],"Variables":[]}]},"Priority":5,"MaxRequestDurationInMinutes":720,"AbsoluteTimeout":"2020-05-14T00:15:00.5975486Z","CanTriggerMoreRequests":false,"ExecutionId":"XYZ"} produce an invalid selection

NPrinting Version : Qlik NPrinting November 2019

Qlik Sense Version : Qlik Sense November 2019

Thanks,

Swapnil

[Ruggero_Piccoli]

Hi,

The filters you applied to users, tasks, reports or objects are producing and empty dataset as per the error message "Filters applied to user and report XYZ define an empty set.".  You need to check your filters and correct where you are making the wrong selection.

I suggest you to remove all applied filters and start to run the task by adding a single filter at evrey run so you will see which filter is causing the issue.

Best Regards,

Ruggero

[swapnil_kumbhar]

Hi  Ruggero,

Thanks. I have checked the filters & currently we are using only User level filters. At Report level we are not using any filters. Is there any specific way to check those filters.

Thanks & Regards,

Swapnil Kumbhar 

[Obulreddy1]

If you are unsure of what those user filters are, you can find them under Admin -> Users -> 'Click on your user' -> Filters 

See screenshot for the navigation.

Just in case if you are using any import tasks for importing filters, I would recommend you to check the Recipients.xls file for the user filters. There might be cases where other developers might be creating a report for the same user with some filters on, which might not be relevant to your report. 

Regards,

Obulreddy

[Ruggero_Piccoli]

Hi,

Filters can be applied to users, reports, tasks and objects so you have to check all of them. A filter can select values from many fields and also this could generate an empty dataset. Please read how filters work in the page https://help.qlik.com/en-US/nprinting/April2020/Content/NPrinting/ReportsDevelopment/Static-dynamic-...

Best Regards,

Ruggero