Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm looking for some help on an NPrinting Task Execution error that is as follows.
WARN: error during report generation: Exception during content resolution while processing request with id d5ce1328-588b-491b-bbcd-df19aadcb5a7. Check Engine logs for details. ERROR: Object reference not set to an instance of an object.
When looking into the Engine log the error is different:
<log4net.Error>Exception during StringFormat: Input string was not in a correct format. <format>Qlik.NPrinting.Engine 19.9.5.0 Qlik.NPrinting.Engine.Consumer.ContentRequestExecutor 20190930T084501.483+02:00 WARN SRVITAQLI04 0 0 0 0 0 0 0 0 Exception while processing request {"ColumnId":"O\\Document\\TB04.ltcl1.D_BP","KeepSourceFormats":false,"TablePropertyValues":{"exceltabletag.wraptext":false},"ObjectId":"O\\Document\\TB04","PropertyValues":{},"TransformationId":"03e6c411-3b53-4cf8-804e-6ab5376b521b","EmptyStrategy":0,"RequestId":"d5ce1328-588b-491b-bbcd-df19aadcb5a7","ResponseMetadata":{"TransformationId":"03e6c411-3b53-4cf8-804e-6ab5376b521b","RetriesAttempt":0},"ConnectionId":"920b1f62-76c2-4d3a-88fc-bc634c58acbb","ConnectionString":"navigator=qlikview;documentpath=\\\\srvitaqli01\\e$\\DAB_NPrinting\\Models\\LG\\LG_DAB_PEGGING.qvw","StatsCorrelationId":"Qlik.Reporting.Engine.Messages.Requests.ColumnNodeRequest.O\\Document\\TB04","Filter":{"Filters":[{"Fields":[{"Name":"F\\CD_ORDER_STATE","OverrideValues":false,"QvDataConnectionId":"920b1f62-76c2-4d3a-88fc-bc634c58acbb","Values":[{"Type":1,"StringValue":"5-Open"}],"IsVoid":false},{"Name":"F\\FLAG_C_WAREHOUSE","OverrideValues":false,"QvDataConnectionId":"920b1f62-76c2-4d3a-88fc-bc634c58acbb","Values":[{"Type":1,"StringValue":"0"}],"IsVoid":false},{"Name":"F\\CD_LEVEL_MASTER","OverrideValues":false,"QvDataConnectionId":"920b1f62-76c2-4d3a-88fc-bc634c58acbb","Values":[{"Type":1,"StringValue":"26-Spare Parts"}],"IsVoid":false}]}]},"Priority":5,"MaxRequestDurationInMinutes":720,"AbsoluteTimeout":"2019-09-30T18:45:00.7338747Z","CanTriggerMoreRequests":false,"ExecutionId":"9e59138b-3a42-4ad8-99cf-79ad3338630d"}. ERROR: System.NullReferenceException: Object reference not set to an instance of an object.↓↓↓↓Server stack trace: ↓↓ at Engine.Navigator.QlikView.Services.QlikViewBookmarkFileManager.QlikViewBookmarkFileWrapper.Engine.Navigator.QlikView.Services.IQlikViewBookmarkFile.CreateBookmark(String name, Boolean layoutState, Boolean additive, String infoMessage, Boolean excludeSelections) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\Services\QlikViewBookmarkFileManager.cs:line 2483↓↓ at Engine.Navigator.QlikView.QV.QlikViewDocument.<>c__DisplayClass11_1.<CreateBookmark>b__2() in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QV11\QlikViewDocument.Bookmarks.cs:line 254↓↓ at Engine.Navigator.QlikView.QV.QlikViewDocument.GetObject[T](ConcurrentDictionary`2 objects, String objectId, Func`2 getObject) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QVx\QlikViewDocument.cs:line 1135↓↓ at Engine.Navigator.QlikView.QV.QlikViewDocument.<>c__DisplayClass11_0.<CreateBookmark>b__0() in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QV11\QlikViewDocument.Bookmarks.cs:line 249↓↓ at Engine.Navigator.QlikView.QV.QlikViewDocument.<>c__DisplayClass11_0.<CreateBookmark>b__1() in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QV11\QlikViewDocument.Bookmarks.cs:line 276↓↓ at Engine.Navigator.QlikCommon.Cache.QlikBookmarkCache`1.GetOrAdd(FilterSequence filterSequence, Boolean permanent, Func`1 createBookmarkFn)↓↓ at Engine.Navigator.QlikView.QV.QlikViewDocument.CreateBookmark(String bookmarkId, Boolean includeFilters, Boolean permanent) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QV11\QlikViewDocument.Bookmarks.cs:line 272↓↓ at Engine.Navigator.QlikView.QV.QlikViewDocument.CreateBackupBookmark(Boolean includeFilters) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QV11\QlikViewDocument.Bookmarks.cs:line 282↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.ApplyFilterRequestResolver.Resolve(QlikViewDocument doc, ApplyFilterRequest request, Filter filter, Filter& filterMaterialized) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\ApplyFilterRequestResolver.cs:line 72↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.ApplyFilterRequestResolver.Resolve(QlikViewDocument doc, ApplyFilterRequest request) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\ApplyFilterRequestResolver.cs:line 48↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.BaseFilterRequestResolver`1.Engine.Navigator.QlikView.QV.Resolvers.Filters.IFilterRequestResolver.Resolve(QlikViewDocument doc, IFilterRequest request) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\BaseFilterResolver.cs:line 43↓↓↓↓Exception rethrown at [0]: ↓↓ at System.ExceptionExtensions.Rethrow(Exception this) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Qlik\Qlik.Reporting.Common\System\ExceptionExtensions.cs:line 231↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.BaseFilterRequestResolver`1.Engine.Navigator.QlikView.QV.Resolvers.Filters.IFilterRequestResolver.Resolve(QlikViewDocument doc, IFilterRequest request) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\BaseFilterResolver.cs:line 55↓↓ at Engine.Navigator.QlikView.QV.QlikViewNavigator.Qlik.Printing.IContentNavigator.Filter(IFilterRequest request) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine.Navigator.QlikView\QVx\QlikViewNavigator.cs:line 200↓↓ at Qlik.NPrinting.Engine.Consumer.ContentRequestExecutor.ApplyFilters(IContentRequest request) in C:\Jws\release-19.9.x-GsL0YuxYW\server\NPrinting\src\Engine\Consumer\ContentRequestExecutor.cs:line 78 </format><args>{Qlik.NPrinting.Common.Utils.NPLoggingContext}</args></log4net.Error>
This error looks like a filter issue but all the filters' values are existent, present and correct in format.
The only change that we had is in the QlikView script and not related to this report and/or filters.
How can we prevent this from happening again?
Thanks
Ciao Francesco,
Please start by updating to September 2019 that has improved logs that let us to better understand the issue.
Best Regards,
Ruggero
Ciao Ruggero,
it looks like we solved the issue by regenerating the Connection metadata cache.
Hopefully, this won't happen again before we start upgrading.
Thanks
Francesco