topic Nprinting : Filtering issue.. in Qlik NPrinting

Nprinting : Filtering issue..

amehta — Wed, 13 Feb 2019 17:08:58 GMT

Hello, we are facing a strange issue. we use nprinting 2018 November

1. We have created a App and connection

2. Generation of Cache was successful

3. when we create a filter some fields show fully cached while when we select another they dont show cached.

4. Now we select the field which does not show cached and put a value there. On demand report running gives the below error.

we are not sure what is happening, my take is that the field which has higher number of distinct records doesnt get cached. can you please let me know if you have faced this issue and a possible solution

-----------

Qlik.NPrinting.Repo 18.39.6.0 Qlik.NPrinting.Repo.Plan.ReportFailurePlanNodeExecutor 20190213T115750.387-05:00 ERROR G2AZRSRVNPRT02 945e82e1-b2c6-490f-9925-4216690586eb 0 0 00000000-0000-0000-0000-000000000000 0 59c28a2a-fb00-43fc-9a48-249916b19964 0 0 Failed generation of report 59c28a2a-fb00-43fc-9a48-249916b19964 for user 945e82e1-b2c6-490f-9925-4216690586eb. ERROR: System.Exception: Cannot apply filter Filters: [Fields: [Name: F\LocationSeries, ConnectionId: 457c883b-1d27-46ef-a986-476a647149a8, Values: [String:9001], Override: False, Void: False, Name: F\FinancialYear, ConnectionId: 457c883b-1d27-46ef-a986-476a647149a8, Values: [String:2018], Override: False, Void: False, Name: F\Qtr, ConnectionId: 457c883b-1d27-46ef-a986-476a647149a8, Values: [String:Q4], Override: False, Void: False, Name: F\CUSTOMERID, ConnectionId: 457c883b-1d27-46ef-a986-476a647149a8, Values: [String:10007, String:10008], Override: True, Void: False], Void: False], Bookmark: Server\BM04-60, Void: False to current document data. Requested fields with evaluates are:

Re: Nprinting : Filtering issue..

Frank_S — Wed, 13 Feb 2019 17:47:11 GMT

Are you using NPrinting Cluster Connections?

Re: Nprinting : Filtering issue..

amehta — Wed, 13 Feb 2019 18:26:38 GMT

I am not sure if I understand what you mean by Cluster Connections

Re: Nprinting : Filtering issue..

Frank_S — Wed, 13 Feb 2019 18:32:33 GMT

Check this link regarding NP cluster connection configuration.

https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/GettingStarted/HowCreateConnections/Connect-to-QlikView-docs.htm#anchor-8

The reason I ask is that there is a known bug that affects some customers when NP cluster connections are used.

The log entry showing the BM (bookmark) entry "Bookmark: Server\BM04-60" is an indication that you 'might' be incurring the same issue.

Re: Nprinting : Filtering issue..

amehta — Wed, 13 Feb 2019 18:36:04 GMT

we dont use clusters

Re: Nprinting : Filtering issue..

Frank_S — Wed, 13 Feb 2019 19:04:05 GMT

check for filter conflicts for your user with GUID 945e82e1-b2c6-490f-9925-4216690586eb.

The logging indicates that filters cannot be applied due to filter conflict regarding your user with GUID 945e82e1-b2c6-490f-9925-4216690586eb with possibly the Customer ID dimension.

If 'override' is enabled on the filter, try to remove it.

Also check that the user filter and filters applied to the report, task, template filter object are not conflicting as this too can cause the 'failure to apply' filter message.

See the following link regarding filter rules in order to prevent filter conflicts:

https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm

The user GUID is found in the browser address bar here.

Re: Nprinting : Filtering issue..

amehta — Wed, 13 Feb 2019 20:02:59 GMT

thank you for your prompt response i have removed the over ride check box i still see the issue.

The GUID is my user id as i am trying to run it ondemand

Re: Nprinting : Filtering issue..

Daniel_Jenkins — Wed, 13 Feb 2019 22:45:50 GMT

Hi,

Only the first 1000 values are cached so if your field has a larger number of distinct values they will not all be cached. It makes no difference to the actual running of the report as at run-time the actual source document (with it's current data) is queried. You can get more information under Selecting values here: https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm

Regarding your issue, the message states that the combination of filters specified cannot be applied. To troubleshoot this try the following:

Log into the AccessPoint as the user corresponding to NPrinting userID 945e82e1-b2c6-490f-9925-4216690586eb
Open the document used in the NPrinting Connection
Clear all selections and then make these selections:LocationSeries: 9001
FinancialYear: 2018
Qtr: Q4
CUSTOMERID: 10007 & 10008
If you have any User Filters for that specific User simulate those as well by making relevant selections
Check the charts used in the report

HTH - Daniel.

Re: Nprinting : Filtering issue..

danielgargiulo — Wed, 01 May 2019 00:46:36 GMT

we can see a similar issue. is there a way to allow the filters to be applied and override any previous filters if they conflict? i.e similar to what would happen in the Qlik Application?