Navigator Stuck or died on connection

[nargesbrz]

Hi everyone,

The issue I am referring in below,  I used to have with NP Apr 2019 and now after upgrade to Apr 2020 it appears, and I was wondering if that bad developing the app or NP bug.

When I reload metadata connection, a big bunch of below error messages appears and sometimes reload metadata finish successfully, afterward NP engines won't be responsive, even all services are running, and NP engine status is online.

Usually, I restart all services or restarting the entire server, and then when I next reload metadata will work 

Does anyone have any idea how I can prevent this sort of issues?

the error causes NP not being responsive :

Navigator error while processing request {"ColumnId":"O\\Document\\05_PP_AE.ltcl1.PP_AEWORSEN","KeepSourceFormats":false,"Format":null,"TablePropertyValues":{"excelcolumntag.showheader":false},"ObjectId":"O\\Document\\05_PP_AE","PropertyValues":{"excelcolumntag.showheader":false},"TransformationId":"05d0869a-29a2-4095-bb70-38aba2852cae","EmptyStrategy":0,"RequestId":"bb5f4788-90af-4f54-a970-251b749c3f7e","ResponseMetadata":{"TransformationId":"05d0869a-29a2-4095-bb70-38aba2852cae","RetriesAttempt":0},"ConnectionId":"b006f648-5f12-4808-8244-1aba39d8e70d","ConnectionString":"navigator=qlikview;documentpath=\\\\***************","StatsCorrelationId":"Qlik.Reporting.Engine.Messages.Requests.ColumnNodeRequest.O\\Document\\05_PP_AE","Filter":{"InitialBookmarkId":null,"Filters":[{"Fields":[{"Name":"F\\SUBJID","OverrideValues":false,"SelectExcluded":false,"QvDataConnectionId":"b006f648-5f12-4808-8244-1aba39d8e70d","Values":[{"Type":1,"StringValue":"1204002"}],"IsVoid":false},{"Name":"F\\PP_Filter","OverrideValues":false,"SelectExcluded":false,"QvDataConnectionId":"b006f648-5f12-4808-8244-1aba39d8e70d","Values":[{"Type":0,"DoubleValue":5.0}],"IsVoid":false},{"Name":"F\\AE_RECORD_ID_PP","OverrideValues":false,"SelectExcluded":false,"QvDataConnectionId":"b006f648-5f12-4808-8244-1aba39d8e70d","Values":[{"Type":0,"DoubleValue":3.0}],"IsVoid":false}],"Variables":[]}]},"Priority":5,"MaxRequestDurationInMinutes":720,"AbsoluteTimeout":"2020-05-12T03:20:50.2246374Z","CanTriggerMoreRequests":false,"LastDocumentReloadTimestamp":null,"LastMetadataReloadTimestamp":null,"ExecutionId":"5949cd6e-0f05-4310-84fe-9cb84a8c64d5"}. ERROR: Qlik.Reporting.Engine.Messages.Exceptions.NavigatorDiedException: Navigator navigator=qlikview;documentpath=\\********;qlikviewversion=12.40.20000 process died or has been terminated and can't be used anymore to resolve requests ---> System.Runtime.InteropServices.COMException: The remote procedure call failed. (Exception from HRESULT: 0x800706BE)↓↓ at Qlik.QlikView.Interfaces.Field.ToggleSelect(String _Match, Boolean _SoftLock, Int32 _ExcludedValuesMode)↓↓ at Engine.Navigator.QlikView.QV.Subsystems.QlikViewSelectionsManager.BackupSelectionState.Apply() in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Subsystems\QlikViewSelectionsManager.cs:line 160↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.ApplyFilterRequestResolver.<>c__DisplayClass4_0.<Resolve>g__CurrentResolve|1() in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\ApplyFilterRequestResolver.cs:line 392↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.ApplyFilterRequestResolver.Resolve(QlikViewDocument doc, ApplyFilterRequest request) in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\ApplyFilterRequestResolver.cs:line 52↓↓ 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-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\BaseFilterResolver.cs:line 43↓↓ --- End of inner exception stack trace ---↓↓ 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-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\BaseFilterResolver.cs:line 58↓↓ at Engine.Navigator.QlikView.QV.QlikViewNavigator.Qlik.Printing.IContentNavigator.Filter(IFilterRequest request) in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\QlikViewNavigator.cs:line 200↓↓ at Qlik.NPrinting.Engine.Consumer.ContentRequestExecutor.ApplyFilters(IContentRequest request) in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine\Consumer\ContentRequestExecutor.cs:line 75

Navigator stuck or died on connection navigator=qlikview;documentpath=\\..........., forcing close of resolver. 4 unprocessed request(s) will be reenqueued. ERROR: Qlik.Reporting.Engine.Messages.Exceptions.NavigatorDiedException: Navigator navigator=qlikview;documentpath=\\;qlikviewversion=12.40.20000 process died or has been terminated and can't be used anymore to resolve requests ---> System.Runtime.InteropServices.COMException: The remote procedure call failed. (Exception from HRESULT: 0x800706BE)↓↓ at Qlik.QlikView.Interfaces.Field.ToggleSelect(String _Match, Boolean _SoftLock, Int32 _ExcludedValuesMode)↓↓ at Engine.Navigator.QlikView.QV.Subsystems.QlikViewSelectionsManager.BackupSelectionState.Apply() in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Subsystems\QlikViewSelectionsManager.cs:line 160↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.ApplyFilterRequestResolver.<>c__DisplayClass4_0.<Resolve>g__CurrentResolve|1() in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\ApplyFilterRequestResolver.cs:line 392↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.ApplyFilterRequestResolver.Resolve(QlikViewDocument doc, ApplyFilterRequest request) in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\ApplyFilterRequestResolver.cs:line 52↓↓ 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-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\BaseFilterResolver.cs:line 43↓↓ --- End of inner exception stack trace ---↓↓ 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-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\BaseFilterResolver.cs:line 58↓↓ at Engine.Navigator.QlikView.QV.QlikViewNavigator.Qlik.Printing.IContentNavigator.Filter(IFilterRequest request) in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine.Navigator.QlikView\QVx\QlikViewNavigator.cs:line 200↓↓ at Qlik.NPrinting.Engine.Consumer.ContentRequestExecutor.ApplyFilters(IContentRequest request) in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine\Consumer\ContentRequestExecutor.cs:line 111↓↓ at Qlik.NPrinting.Engine.Consumer.ContentResolver.Consume(CancellationToken cancToken) in C:\Jws\release-april2020-k7285I5rF\server\NPrinting\src\Engine\Consumer\ContentResolver.cs:line 318

[Lech_Miszkiewicz]

seems to be seasonal issue - happens only in April releases 🙂

but seriously - have you thought about contacting support?

@Ruggero_Piccoli - is this support case? what do you think..

cheers

Lech

[nargesbrz]

Hi Lech,

Thanks for feedback. I will try to contact them. thanks

[Ruggero_Piccoli · Accepted solution]

Hi,

Based on the logs it seems that QlikView crashed during filters application. So, as first step, please check that the .QVW has not usupported stuffs like "always one selected" or triggers.

Best Regards,

Ruggero

[Fran_by · Accepted solution]

I had same problem  in  .qvw with  configurated "Alert" on open!

After deleted alert, nprinting connected perfect.