Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
amehta
Contributor II
Contributor II

Nprinting : Filtering issue..

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:

 

 

 

8 Replies
Frank_S
Support
Support

Are you using NPrinting Cluster Connections?
We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
amehta
Contributor II
Contributor II
Author

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

Frank_S
Support
Support

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.

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
amehta
Contributor II
Contributor II
Author

we dont use clusters

Frank_S
Support
Support

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. 

user and other filter conflict.PNG

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.

user guid.PNG

 

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
amehta
Contributor II
Contributor II
Author

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
Specialist III
Specialist III

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
Partner - Creator
Partner - Creator

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?