qlikview nprinting ondemand error

[FrankC]

I have created a report against the qlikview application.  The connection passes and will refresh successfully.  I am able to create a task and run the report just fine.  However when I click on the OnDemand option in the access point, the report errors out.  Looking in the log I am seeing Qlik.NPrinting.Repo.ServiceException: Missing .qvw in document path

Any thoughts?

Thanks

Frank

[Frank_S]

Hi @FrankC 

You must use QVP connections in conjunction with On Demand reporting where QlikView is concerned. Local connections will not work.

See requirements for confirmation of this point:

https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/On-Demand/Create-Report-On-Dema...

Requirements

• Qlik NPrinting On-Demand Add-on must be installed on the QlikView Server. See: Installing On-Demand Add-on on a Microsoft IIS hosted QlikView AccessPoint.
  Qlik NPrinting administrator must assign On-Demand users a security role with On-Demand Create authorization.
• Users creating On-Demand reports in QlikView must have their Windows Active Directory user account associated with their Qlik NPrinting web console user account.
• Creating users.
  Users creating On-Demand reports in QlikView must have a domain and user associated to their Qlik NPrinting web console user account that matches the domain and user of their QlikView Server Windows Active Directory user account.
• Users working on a QlikView Server or Cluster with a QV Server Extranet License must be correctly configured with an Identity, and must be logged into both Qlik NPrinting and QlikView AccessPoint. Otherwise, bookmarks will not be available.
  Applying section access and current selections present in the QlikView document is supported.
• On-Demand sessions appear in the QVS Statistics tab of the QlikView Server, but do not count against session CAL totals.
• On-Demand will not work with locally saved .qvw files. Files must be available on a QlikView Publisher (QVP) connection.
• On-Demand requests only work with reports based on a single connection. MultiDoc reports are not supported.

[FrankC]

Hey Frank... Long time

Here is the connection for the report

Creating a task in Nprinting and executing from there works fine.

[Frank_S]

Hi @FrankC 

I know right 🙂

The error you shared indicated possible that it was a local connection.

Is there any other error indicated? ie: when verifying the connection?

Try to log on as the NP service account to the NP engine/server computer. Do File>Open in Server and try to find the QVP connection. If you don't see it, then the NP service account doesn't have access to the QVW or there is section access on the QVW. If the latter, the NP service account needs to be part of the load script as ADMIN. (NTFS section access not QlikView Section Access).

Please also check for unsupported items in the QVW and ensure the NP server/engine service account is not share with any other service.

• Dedicated NPrinting Server & Engine Service Accoun... - Qlik Community - 1716056
• Qlik NPrinting: Unsupported QlikView Document item... - Qlik Community - 1714896
• Troubleshooting QlikView On Demand with NPrinting ... - Qlik Community - 1759095

Kind regards...

[FrankC]

Frank

I was able to sign into the nprinting server and open the report from the server with no issue.  Here is the line from engine log.

Qlik.NPrinting.Engine 20.19.3.0 Qlik.NPrinting.Engine.Consumer.ContentRequestExecutor 20210323T113858.178-04:00 WARN HVQLNP01 0 0 1208dc60-a6ed-4ab0-97c8-46fdd5cc94a3 0 e6346061-a838-468e-bfec-9508381fccbb 0 698c1372-b7f1-4d4a-a266-a3b1163c4961 0 Exception while processing request {"KeepSourceFormats":true,"ExportedFormatSequence":[0,1],"ExportFallbackMechanism":1,"ObjectId":"O\\Document\\CH86","PropertyValues":{},"TransformationId":"24132cae-1fce-44d9-b3bb-c02d934523e3","EmptyStrategy":0,"RequestId":"698c1372-b7f1-4d4a-a266-a3b1163c4961","ResponseMetadata":{"TransformationId":"24132cae-1fce-44d9-b3bb-c02d934523e3","RetriesAttempt":0},"ConnectionId":"1208dc60-a6ed-4ab0-97c8-46fdd5cc94a3","ConnectionString":"navigator=qlikview;documentpath=\"qvp://hcbvqt01/DevDocs/DM Dashboard.qvw\"","StatsCorrelationId":"Qlik.Reporting.Engine.Messages.Requests.TableNodeRequest.O\\Document\\CH86","Filter":{"InitialBookmarkId":"Server\\BM29-00_083474718","Filters":[]},"Priority":10,"MaxRequestDurationInMinutes":120,"AbsoluteTimeout":"2021-03-23T17:38:56.3310837Z","CanTriggerMoreRequests":false,"ExecutionId":"e6346061-a838-468e-bfec-9508381fccbb","SchedulerRestartSessionId":"9aab8d49-b650-4d1b-b1c2-d4266c6a83cf"}. ERROR: System.Collections.Generic.KeyNotFoundException: Bookmark with id Server\BM29-00_083474718 could not be found.↓↓↓↓Server stack trace: ↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.ApplyBookmarkRequestResolver.Resolve(QlikViewDocument doc, String requestBookmarkId) in C:\Jws\release-june2020-M31wMH8DB\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\ApplyBookmarkRequestResolver.cs:line 23↓↓ at Engine.Navigator.QlikView.QV.Resolvers.Filters.ApplyBookmarkRequestResolver.Resolve(QlikViewDocument doc, ApplyBookmarkRequest request) in C:\Jws\release-june2020-M31wMH8DB\server\NPrinting\src\Engine.Navigator.QlikView\QVx\Resolvers\Filters\ApplyBookmarkRequestResolver.cs:line 14↓↓ 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-june2020-M31wMH8DB\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-june2020-M31wMH8DB\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-june2020-M31wMH8DB\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-june2020-M31wMH8DB\server\NPrinting\src\Engine.Navigator.QlikView\QVx\QlikViewNavigator.cs:line 200↓↓ at Qlik.NPrinting.Engine.Consumer.ContentRequestExecutor.ApplyFilters(IContentRequest request) in C:\Jws\release-june2020-M31wMH8DB\server\NPrinting\src\Engine\Consumer\ContentRequestExecutor.cs:line 75

[Frank_S]

Hi @FrankC 

I see this important and informative known error:

"Bookmark with id Server\BM29-xx could not be found"

A known issue with NPrinting On Demand with QlikView has recently been resolved by QlikView 12.5 SR 4 that resolves this issue.

If you do upgrade your QlikView Server and Desktops, you still need to ensure that there are no duplicates of your QVW in the root or subfolders or you will experience the error again. Simply remove any duplicates from the root folder and subfolder structure. (an NPrinting specific fix is coming for duplicate QVWs found by NPrinting in the root folder structure which will ignore the duplicates. Coming later this year).

I've attached the QlikView 12.5. SR 4 release notes for your convenience. See JIRA QV-21003.

Best...fs

[Frank_S]

Article: Qlik NPrinting on demand error 'bookmark could not be found' 

https://support.qlik.com/articles/000058440