Nprinting : Filtering issue..

[amehta]

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:

[Frank_S]

Are you using NPrinting Cluster Connections?

[amehta]

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

[Frank_S]

Check this link regarding NP cluster connection configuration.

https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/GettingStarted/HowCreateConnect...

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.

[amehta]

we dont use clusters

[Frank_S]

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-dynam...

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

[amehta]

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

[Daniel_Jenkins]

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-dynam...

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.

[danielgargiulo]

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?