Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community
I have an Issue with thet triggers for the cache rebuild. I am currently running the june version (17.4). I've created a trigger (daily, once at 06:00 AM). Sometimes the rebuild works, sometimes it fails... For example, here 4 times in a row:
From the Log File: (I guess sometimes NPrinting can't lock the DB? -> ...Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [Qlik.NPrinting.Repo.Model.DataConnection#8a63d5c8-3933-4699-aead-47c0380fe1e7] occurred)
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Scheduler.EnqueueTaskQuartzJob | 20170714T060000.000+02:00 | INFO | KSL-VW2K251 | 0 | 0 | 0 | b12e9db3-ebd9-4bb2-a331-40f58dac1e21 | 0 | 0 | 0 | 0 | Triggering task b12e9db3-ebd9-4bb2-a331-40f58dac1e21 by trigger 7b9885df-099b-4cac-91c5-87802151772f | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Scheduler.Task.GenerateConnectionCacheEngineTask | 20170714T060000.022+02:00 | INFO | KSL-VW2K251 | 0 | 0 | 8a63d5c8-3933-4699-aead-47c0380fe1e7 | b12e9db3-ebd9-4bb2-a331-40f58dac1e21 | 0 | 0 | 0 | 0 | Generating cache for connection 8a63d5c8-3933-4699-aead-47c0380fe1e7 | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Common.Task.BaseEngineTask`1[[Qlik.NPrinting.Common.Task.GenerateConnectionCacheTaskConfig, Qlik.NPrinting.Common, Version=17.4.0.0, Culture=neutral, PublicKeyToken=null]] | 20170714T060000.037+02:00 | WARN | KSL-VW2K251 | 0 | 0 | 0 | 0 | 7d6099a7-4fab-4161-8260-784a05b64e41 | 0 | 0 | 0 | Cannot run Scheduler task 7d6099a7-4fab-4161-8260-784a05b64e41, exception Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [Qlik.NPrinting.Repo.Model.DataConnection#8a63d5c8-3933-4699-aead-47c0380fe1e7] occurred | |||
Qlik.NPrinting.Repo | 17.4.0.0 | Qlik.NPrinting.Repo.Plan.ReportFailurePlanNodeExecutor | 20170714T162823.181+02:00 | ERROR | KSL-VW2K251 | 0 | 0 | 0 | 00000000-0000-0000-0000-000000000000 | 0 | 865dc91e-0b80-4be1-ab16-9418f0db147b | 0 | 0 | Failed report generation for report 865dc91e-0b80-4be1-ab16-9418f0db147b user ddd17ebe-6260-4faf-91b2-f2de9ac721a0 exception Qlik.Reporting.Reports.Tree.Exceptions.FailedReportException: Report generation failed. Error in node of type Qlik.Reporting.Reports.Tree.Template.DatasetNode for request 72b28838-1b77-4f8a-af91-1a63b7834416↓unknown↓Failed object: O\Document\CH622↓Template id: CH622_Level, template level: root↓Request filter: Filters: [], Bookmark: , Void: False↓↓ bei Qlik.Reporting.Reports.Tree.Template.CycleNode`4.ApplyFailure(FailureContentNodeResponse response, TcTransformationContext transformationCtx)↓↓ bei Qlik.Printing.Trees.TcTransformation.ApplyResponse(IContentNodeResponse response)↓↓ bei Qlik.Printing.TreeTransformationService.Process(IReportRequest reportRequest, IContentNodeResponse contentNodeResponse) | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Scheduler.EnqueueTaskQuartzJob | 20170715T060000.000+02:00 | INFO | KSL-VW2K251 | 0 | 0 | 0 | b12e9db3-ebd9-4bb2-a331-40f58dac1e21 | 0 | 0 | 0 | 0 | Triggering task b12e9db3-ebd9-4bb2-a331-40f58dac1e21 by trigger 7b9885df-099b-4cac-91c5-87802151772f | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Scheduler.Task.GenerateConnectionCacheEngineTask | 20170715T060000.017+02:00 | INFO | KSL-VW2K251 | 0 | 0 | 8a63d5c8-3933-4699-aead-47c0380fe1e7 | b12e9db3-ebd9-4bb2-a331-40f58dac1e21 | 0 | 0 | 0 | 0 | Generating cache for connection 8a63d5c8-3933-4699-aead-47c0380fe1e7 | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Common.Task.BaseEngineTask`1[[Qlik.NPrinting.Common.Task.GenerateConnectionCacheTaskConfig, Qlik.NPrinting.Common, Version=17.4.0.0, Culture=neutral, PublicKeyToken=null]] | 20170715T060000.031+02:00 | WARN | KSL-VW2K251 | 0 | 0 | 0 | 0 | da228101-5ac8-4e68-9a49-ff938ebc5562 | 0 | 0 | 0 | Cannot run Scheduler task da228101-5ac8-4e68-9a49-ff938ebc5562, exception Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [Qlik.NPrinting.Repo.Model.DataConnection#8a63d5c8-3933-4699-aead-47c0380fe1e7] occurred | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Scheduler.EnqueueTaskQuartzJob | 20170716T060000.000+02:00 | INFO | KSL-VW2K251 | 0 | 0 | 0 | b12e9db3-ebd9-4bb2-a331-40f58dac1e21 | 0 | 0 | 0 | 0 | Triggering task b12e9db3-ebd9-4bb2-a331-40f58dac1e21 by trigger 7b9885df-099b-4cac-91c5-87802151772f | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Scheduler.Task.GenerateConnectionCacheEngineTask | 20170716T060000.029+02:00 | INFO | KSL-VW2K251 | 0 | 0 | 8a63d5c8-3933-4699-aead-47c0380fe1e7 | b12e9db3-ebd9-4bb2-a331-40f58dac1e21 | 0 | 0 | 0 | 0 | Generating cache for connection 8a63d5c8-3933-4699-aead-47c0380fe1e7 | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Common.Task.BaseEngineTask`1[[Qlik.NPrinting.Common.Task.GenerateConnectionCacheTaskConfig, Qlik.NPrinting.Common, Version=17.4.0.0, Culture=neutral, PublicKeyToken=null]] | 20170716T060000.041+02:00 | WARN | KSL-VW2K251 | 0 | 0 | 0 | 0 | 9134c48f-e20c-4c65-84e9-7210623df5f0 | 0 | 0 | 0 | Cannot run Scheduler task 9134c48f-e20c-4c65-84e9-7210623df5f0, exception Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [Qlik.NPrinting.Repo.Model.DataConnection#8a63d5c8-3933-4699-aead-47c0380fe1e7] occurred | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Scheduler.EnqueueTaskQuartzJob | 20170717T060000.000+02:00 | INFO | KSL-VW2K251 | 0 | 0 | 0 | b12e9db3-ebd9-4bb2-a331-40f58dac1e21 | 0 | 0 | 0 | 0 | Triggering task b12e9db3-ebd9-4bb2-a331-40f58dac1e21 by trigger 7b9885df-099b-4cac-91c5-87802151772f | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Scheduler.Task.GenerateConnectionCacheEngineTask | 20170717T060000.022+02:00 | INFO | KSL-VW2K251 | 0 | 0 | 8a63d5c8-3933-4699-aead-47c0380fe1e7 | b12e9db3-ebd9-4bb2-a331-40f58dac1e21 | 0 | 0 | 0 | 0 | Generating cache for connection 8a63d5c8-3933-4699-aead-47c0380fe1e7 | |||
Qlik.NPrinting.Scheduler | 17.4.0.0 | Qlik.NPrinting.Common.Task.BaseEngineTask`1[[Qlik.NPrinting.Common.Task.GenerateConnectionCacheTaskConfig, Qlik.NPrinting.Common, Version=17.4.0.0, Culture=neutral, PublicKeyToken=null]] | 20170717T060000.037+02:00 | WARN | KSL-VW2K251 | 0 | 0 | 0 | 0 | 01f4c6b1-46da-4a28-a04a-9ce7dd4c65cb | 0 | 0 | 0 | Cannot run Scheduler task 01f4c6b1-46da-4a28-a04a-9ce7dd4c65cb, exception Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [Qlik.NPrinting.Repo.Model.DataConnection#8a63d5c8-3933-4699-aead-47c0380fe1e7] occurred |
18.07. wokrs fine, 19.07. fails again and 20.07. it works again:
Is this a bug? Or am i doing something wrong?
Also, the run verification gives me an error:
The Qlik NPrinting Engine and the QlikView Server are both running on the same machine. I can log on to the machine with both users. Do I need to change any settings?
Thank's for any help & best Regards!
Hi, Stefan
Consider this. The User Account used to Run Qlik NPrinting Services needs to be in Administrators Group of the server thats runs QlikView Server.
I thinks thats why you got the Error : "The account used to run ......"
regards, @kirkjoserey
Hi,
on top of that - it not only needs to be a local Administrator on QlikView server, but also needs to belong to QlikView Administrators group.
all is very well described in help document:
also consider whether your tasks/triggers are not overlapping with other publish task?
cheers
Lech
Hi Lech & Rey
Thanks a lot for your inputs!
The qlik NPrinting user is part of the local administratior Group but not a member of the QlikView Administrators group. I will change that and see how the connenction rebuild works over the weekend and give another feedback.
Have a nice weekend!
best regards
Stefan
Hi - to get it all working properly you have to make sure you have ALL requirements met, else it will once work another time may not work etc...
cheers
Have a nice weekend
Lech
btw.. Is this local connection or qvp:?
If it is local maybe your NPrinting engine server does not have enough capacity to open document locally as it needs to have anough memory and CPU to do it then on NPrinting Engine box.
That is why i strongly suggest to use qvp connection as it is using power of QV box.
regards
Lech
Hi Lech,
It is a qvp Server Connection. But nPrinting and QlikView are running on the same machine:
Best Regrads
This is another not recommended configuration as NPrinting will suck up all possible resources and qlik will do the same which may have some impact on cache build process
Also - i believe NPrinting has dedicated account user (different than qv server service account user)! Right?
cheers
Lech
Hi Lech
Yes, I've read that before. But at the moment we only get one server, so it has to work (if I'm not mistaking it also says in the documentation that it's supposed to work with both installation on one machine). And we use different users for the QlikView and NPrinting services.
Another question: The above error is gone now that I've added the user to the group. But now I'm getting another one (The document exists):
Btw. if I rebuild the cache manually, everything just works fine.
Thanks for your help & best regards
Stefan
EDIT:
This Verify connection errors when setting up a connection to QlikView in Qlik NPrinting ‒ Qlik NPrinting says:
The document exists. | The document specified does not exist. Verify the document and path are entered correctly. |
But this seems to be wrong. Since i can rebuild the connection and document exists?
i am not sure.. that means are you sure you point to right location?