Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Nprinting On-Demand April 2019 Request Failed Defect and Workaround

We encounter a problem with the NPrinting On-Demand when we publish a Qlik Sense App. Below, I describe the problem, provide Nprinting engine error logs, and describe a workaround.

Problem description:

Nprinting On-demand Request April 2019 fails when Qlik Sense app is published to stream. 

I develop the app in my workstream, build the NPrinting report in excel, and configure the Nprinting on-demand button. Everything works fine. However, when I published the app, the on-demand feature no longer works. I've copied the Nprinting error logs to this post. 

Our Configuration

  • Qlik Sense Enterprise ver April 2019 patch 1
  • Qlik NPrinting April 2019

Workaround description:

It appears the problem has to do something with the object IDs in the Qlik Sense Repository. Here's a workaround which works:

Before you publish the app, do these steps:

  1. reload the data model
  2. then refresh the NPrinting connection
  3. check to make sure the report runs when you click the on-demand button
  4. publish the app to the stream 

I still have to play around with these steps to make sure this works, so your results may vary. Hopefully, this will save folks time and frustration. My request is that the Nprinting team work on this issue. 

 

Nprinting Engine Error Message:

Qlik.NPrinting.Engine 19.9.5.0 Qlik.NPrinting.Engine.Consumer.ContentRequestExecutor 20190522T135055.076-04:00 WARN NPRINTSRV 0 0 5c72f31a-a68e-4e9c-8c56-a07eee657f56 0 fdcdeb03-10f4-4cee-9c35-c9e94a8f6a98 0 f0842500-6903-4e7b-8a23-b104ce6c0b16 0 Exception during content resolution while processing request {"FilterSequenceToMaterialize":{"Filters":[{"Fields":[{"Name":"F\\Start Evaluation Date","OverrideValues":false,"QvDataConnectionId":"5c72f31a-a68e-4e9c-8c56-a07eee657f56","Values":[{"Type":0,"DoubleValue":42948.0}],"IsVoid":false},{"Name":"F\\Census Year-Qtr","OverrideValues":false,"QvDataConnectionId":"5c72f31a-a68e-4e9c-8c56-a07eee657f56","Values":[{"Type":0,"DoubleValue":43466.0}],"IsVoid":false},{"Name":"F\\End Discharge Date","OverrideValues":false,"QvDataConnectionId":"5c72f31a-a68e-4e9c-8c56-a07eee657f56","Values":[{"Type":0,"DoubleValue":43585.0}],"IsVoid":false},{"Name":"F\\Census Parent","OverrideValues":false,"QvDataConnectionId":"5c72f31a-a68e-4e9c-8c56-a07eee657f56","Values":[{"Type":1,"StringValue":"Chelsea Senior Living"}],"IsVoid":false}]}]},"TransformationId":"00000000-0000-0000-0000-000000000000","EmptyStrategy":0,"RequestId":"f0842500-6903-4e7b-8a23-b104ce6c0b16","ResponseMetadata":{"TransformationId":"00000000-0000-0000-0000-000000000000","RetriesAttempt":0},"ConnectionId":"5c72f31a-a68e-4e9c-8c56-a07eee657f56","ConnectionString":"navigator=qliksense;proxyurl=https://server.com/;appid=1e1cdb0b-9003-4c39-ad5f-41061143d99d;identity=foxrehabilitati\\qlikadmin",..."}. ERROR: System.AggregateException: One or more errors occurred. ---> Qlik.Reporting.Engine.Messages.Exceptions.FailureFilterMaterializationException: Cannot apply filter Filters: [Fields: [Name: F\Start Evaluation Date, ConnectionId: 5c72f31a-a68e-4e9c-8c56-a07eee657f56, Values: [Numeric:42948], Override: False, Void: False, Name: F\Census Year-Qtr, ConnectionId: 5c72f31a-a68e-4e9c-8c56-a07eee657f56, Values: [Numeric:43466], Override: False, Void: False, Name: F\End Discharge Date, ConnectionId: 5c72f31a-a68e-4e9c-8c56-a07eee657f56, Values: [Numeric:43585], Override: False, Void: False, Name: F\Census Parent, ConnectionId: 5c72f31a-a68e-4e9c-8c56-a07eee657f56, Values: [String:Chelsea Senior Living], Override: False, Void: False], Void: False], Bookmark: , Void: False to current document data. Requested fields with evaluates are: ↓↓ at Engine.Navigator.QlikCommon.Resolvers.Contents.FilterMaterializationHelpers.MaterializeFilter(FilterMaterializationRequest request, Func`2 materializeFilter)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.FilterMaterializationRequestResolver.Resolve(SenseApp doc, FilterMaterializationRequest request, AppField appField)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseContentRequestResolver`2.Resolve(SenseApp doc, TRequest request, IQixClassBase IGenericObject)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseBaseContentRequestResolver`1.Resolve(SenseApp doc, IContentRequest request, IQixClassBase senseObject)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseContentRequestResolver`2.Resolve(SenseApp doc, IContentRequest request, IQixClassBase IGenericObject)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseBaseContentRequestResolver`1.Engine.Navigator.QlikSense.SDK.Resolvers.Contents.IContentRequestResolver.Resolve(String connectionString, SenseApp doc, IContentRequest request, IQixClassBase senseObject)↓↓ at Engine.Navigator.QlikSense.SDK.SenseNavigator.Resolve(IContentRequest request, IContentRequestResolver resolver)↓↓ at Engine.Navigator.QlikSense.SDK.SenseNavigator.CreateProcessResolverAndResponse(IContentRequest request)↓↓ at Engine.Navigator.QlikSense.SDK.SenseNavigator.<>c__DisplayClass29_0.<Process>b__2(IContentRequest req)↓↓ at System.Threading.Tasks.Parallel.<>c__DisplayClass42_0`2.<PartitionerForEachWorker>b__1()↓↓ at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)↓↓ at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object )↓↓ --- End of inner exception stack trace ---↓↓ at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)↓↓ at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)↓↓ at System.Threading.Tasks.Parallel.PartitionerForEachWorker[TSource,TLocal](Partitioner`1 source, ParallelOptions parallelOptions, Action`1 simpleBody, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)↓↓ at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)↓↓ at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, Action`1 body)↓↓ at Engine.Navigator.QlikSense.SDK.SenseNavigator.Process(IEnumerable`1 requests)↓↓ at Engine.Navigator.QlikSense.QlikSenseContentNavigator.Process(IEnumerable`1 requests)↓↓ at Qlik.NPrinting.Engine.Consumer.ContentRequestExecutor.ProcessContent(IContentRequest request) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine\Consumer\ContentRequestExecutor.cs:line 157↓↓---> (Inner Exception #0) Qlik.Reporting.Engine.Messages.Exceptions.FailureFilterMaterializationException: Cannot apply filter Filters: [Fields: [Name: F\Start Evaluation Date, ConnectionId: 5c72f31a-a68e-4e9c-8c56-a07eee657f56, Values: [Numeric:42948], Override: False, Void: False, Name: F\Census Year-Qtr, ConnectionId: 5c72f31a-a68e-4e9c-8c56-a07eee657f56, Values: [Numeric:43466], Override: False, Void: False, Name: F\End Discharge Date, ConnectionId: 5c72f31a-a68e-4e9c-8c56-a07eee657f56, Values: [Numeric:43585], Override: False, Void: False, Name: F\Census Parent, ConnectionId: 5c72f31a-a68e-4e9c-8c56-a07eee657f56, Values: [String:Chelsea Senior Living], Override: False, Void: False], Void: False], Bookmark: , Void: False to current document data. Requested fields with evaluates are: ↓↓ at Engine.Navigator.QlikCommon.Resolvers.Contents.FilterMaterializationHelpers.MaterializeFilter(FilterMaterializationRequest request, Func`2 materializeFilter)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.FilterMaterializationRequestResolver.Resolve(SenseApp doc, FilterMaterializationRequest request, AppField appField)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseContentRequestResolver`2.Resolve(SenseApp doc, TRequest request, IQixClassBase IGenericObject)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseBaseContentRequestResolver`1.Resolve(SenseApp doc, IContentRequest request, IQixClassBase senseObject)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseContentRequestResolver`2.Resolve(SenseApp doc, IContentRequest request, IQixClassBase IGenericObject)↓↓ at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseBaseContentRequestResolver`1.Engine.Navigator.QlikSense.SDK.Resolvers.Contents.IContentRequestResolver.Resolve(String connectionString, SenseApp doc, IContentRequest request, IQixClassBase senseObject)↓↓ at Engine.Navigator.QlikSense.SDK.SenseNavigator.Resolve(IContentRequest request, IContentRequestResolver resolver)↓↓ at Engine.Navigator.QlikSense.SDK.SenseNavigator.CreateProcessResolverAndResponse(IContentRequest request)↓↓ at Engine.Navigator.QlikSense.SDK.SenseNavigator.<>c__DisplayClass29_0.<Process>b__2(IContentRequest req)↓↓ at System.Threading.Tasks.Parallel.<>c__DisplayClass42_0`2.<PartitionerForEachWorker>b__1()↓↓ at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)↓↓ at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object )<---

Labels (1)
2 Replies
Employee
Employee

We had exaclty today a Support Technical Thursday explaining that:

https://event.on24.com/wcc/r/1989470/E9D04FCDBE1D162204FDF592C338DC73

Ricardo Gerhard
OEM Solution Architect
LATAM
Contributor III
Contributor III

I watched the video and didn't see this problem described. This problem occurs when you publish the app. The on-demand extension fails. The only change is that the app is published from my work stream to another public stream. I do the workaround described above to address this issue.