NPrinting Catch error

[alvin_chien]

Hi All,

I have an Qlik Sense App that is working by many user, they will create their own sheet base on that App.

When I try to load the metadata for the App in NPrinting, I got the below error.  I believe it is due to some user's own sheet.

If I duplicate the App, it has no issue to load the catch and work properly as all the user sheet will not be duplicate.

How can I identify which user sheet cause the issue by the log?  Then, I can find this object in QMC and change or modify for the user to fix the issue.

Engine.Navigator.QlikSense.SDK 1.0.0.0 Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseBaseContentRequestResolver`1[[Qlik.Reporting.Engine.Messages.Requests.QlikViewDocumentMetadataRequest, Qlik.Reporting.Engine.Messages, Version=2.7.1.17285, Culture=neutral, PublicKeyToken=0f12475411058ae5]] 20180227T171342.412+08:00 ERROR HCDBI03 0 0 0 0 0 0 0 0 ERROR : Object reference not set to an instance of an object. STACK :    at Engine.Navigator.QlikSense.SDK.Extensions.SdkExtensionMethods.CreateMeasureEntity(String sheetObjectId, SenseApp app, INxMeasure measure)??   at Engine.Navigator.QlikSense.SDK.Extensions.SdkExtensionMethods.<>c__DisplayClass2d.<ToEntities>b__2a(NxMeasure measure)??   at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()??   at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)??   at Engine.Navigator.QlikSense.SDK.Extensions.SdkExtensionMethods.ToEntities(IGenericObject sheetObject, SenseApp app, Boolean onlyFilterable)??   at Engine.Navigator.QlikSense.SDK.Extensions.SdkExtensionMethods.<ToEntitiesWithColumnSettings>d__36.MoveNext()??   at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)??   at System.Linq.GroupedEnumerable`3.GetEnumerator()??   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()??   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)??   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.QlikSenseMetadataRequestResolver.CreateEntityFromObject(SenseApp senseApp, IGenericObject genericObject)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.QlikSenseMetadataRequestResolver.GenerateCache(SenseApp senseApp, QlikViewDocumentMetadataRequest request)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.QlikSenseMetadataRequestResolver.Resolve(SenseApp senseApp, QlikViewDocumentMetadataRequest request)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseContentRequestResolver`1.Resolve(SenseApp doc, TRequest request, IQixClassBase senseObject)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseBaseContentRequestResolver`1.Resolve(SenseApp doc, IContentRequest request, IQixClassBase senseObject) in CONNECTIONSTRING : navigator=qliksense;proxyurl=https://hcdbi02.haloasia.local/;appid=d220181d-cd2c-49a3-b308-6617a25a4d68;identity=haloasia\alvin.c...

Qlik.NPrinting.Engine 17.6.0.0 Qlik.NPrinting.Engine.Consumer.ContentResolver 20180227T171427.874+08:00 INFO HCDBI03 0 0 0 0 0 0 0 0 Forced to close a resolver for connection navigator=qliksense;proxyurl=https://hcdbi02.haloasia.local/;appid=d220181d-cd2c-49a3-b308-6617a25a4d68;identity=haloasia\alvin.c....

Engine.Navigator.QlikSense.SDK 1.0.0.0 Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseBaseContentRequestResolver`1[[Qlik.Reporting.Engine.Messages.Requests.QlikViewDocumentMetadataRequest, Qlik.Reporting.Engine.Messages, Version=2.7.1.17285, Culture=neutral, PublicKeyToken=0f12475411058ae5]] 20180227T171437.497+08:00 ERROR HCDBI03 0 0 0 0 0 0 0 0 ERROR : Object reference not set to an instance of an object. STACK :    at Engine.Navigator.QlikSense.SDK.Extensions.SdkExtensionMethods.CreateMeasureEntity(String sheetObjectId, SenseApp app, INxMeasure measure)??   at Engine.Navigator.QlikSense.SDK.Extensions.SdkExtensionMethods.<>c__DisplayClass2d.<ToEntities>b__2a(NxMeasure measure)??   at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()??   at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)??   at Engine.Navigator.QlikSense.SDK.Extensions.SdkExtensionMethods.ToEntities(IGenericObject sheetObject, SenseApp app, Boolean onlyFilterable)??   at Engine.Navigator.QlikSense.SDK.Extensions.SdkExtensionMethods.<ToEntitiesWithColumnSettings>d__36.MoveNext()??   at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)??   at System.Linq.GroupedEnumerable`3.GetEnumerator()??   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()??   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)??   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.QlikSenseMetadataRequestResolver.CreateEntityFromObject(SenseApp senseApp, IGenericObject genericObject)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.QlikSenseMetadataRequestResolver.GenerateCache(SenseApp senseApp, QlikViewDocumentMetadataRequest request)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.QlikSenseMetadataRequestResolver.Resolve(SenseApp senseApp, QlikViewDocumentMetadataRequest request)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseContentRequestResolver`1.Resolve(SenseApp doc, TRequest request, IQixClassBase senseObject)??   at Engine.Navigator.QlikSense.SDK.Resolvers.Contents.BaseBaseContentRequestResolver`1.Resolve(SenseApp doc, IContentRequest request, IQixClassBase senseObject) in CONNECTIONSTRING : navigator=qliksense;proxyurl=https://hcdbi02.haloasia.local/;appid=d220181d-cd2c-49a3-b308-6617a25a4d68;identity=haloasia\alvin.c...

Session: 7a5b97f0-962b-4a78-9dab-c9ebc0fe8b05/127.0.0.1:57811

[Ruggero_Piccoli]

Hi,

In this case you need an investigation on the specific app so I would to suggest you to open a support ticket.

In my opinion in a scenario like your it will be better to create a clone of the app and use the clone for reporting. In the clone you can keep only the objects and data that are necessary to create the reports you need to optimize performances and to avoid breaking risks.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[alvin_chien]

Thanks a lot for the reply, so in order to figure out the root cause of the error.  I can only open the support ticket then.  Thanks!

[Ruggero_Piccoli]

Yes, open a support ticket, but in your scenario I strongly suggest to create a version of the app only for reporting and one for the users.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.