topic Re: QMC task in QlikView

QMC task

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

Hello Community, For only one document I am getting the below QMC error and for rest of them no failures.

Error: The task "Dashboard" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.WritePermissionkException: Failed to get write permission for file: \Dashboard.qvw ---> System.IO.IOException: The process cannot access the file '\Dashboard.qvw' because it is being used by another process. || at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) || at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) || at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) || at QDSMain.AbstractReloadTask.CheckWritePermissionForFile(String fileName) || --- End of inner exception stack trace --- || at QDSMain.AbstractReloadTask.CheckWritePermissionForFile(String fileName) || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)

Can you please over here.

_Priya

Re: QMC task

hopkinsc — Wed, 06 Mar 2019 21:17:41 GMT

Does the reload work when running from the QV client?

Re: QMC task

Brett_Bleess — Wed, 06 Mar 2019 21:25:04 GMT

It appears the QVW associated with that task could not be opened with the file lock, so we would be able to write the updated info back out post reload, which means some other task or process on the server had the file lock. These can be tricky to figure out, but the obvious thing we ask folks to check is if Anti-virus or any other 'active scanning' tools are running on the servers, and if so, we recommend excluding our directories from those tools to avoid these situations from occurring. Scans can be done during maintenance windows when the Qlik services are offline etc. at that point.

To Chris' point though, if you have the Script logs enabled on this app, I expect you got no script/document log in this case, which would confirm we could not open the QVW to do the reload, and the trick is figuring out why the file was in a locked state such that we were not able to open for reload. Sorry, I have not stated things very clearly here, but hopefully this makes a little sense.

Microsoft SysInternals Process Monitor can be used in these cases if you catch things to try to see what process has the lock etc.

Oh, just thought of a workaround as well, you could bump up the 'Retries' setting on the Task to more than 1 in this case, that way if this file is sometimes locked, having things retry a few times, hopefully we may be able to always get the lock on a subsequent try and successfully complete things.

Cheers,
Brett

Re: QMC task

priyarane — Wed, 06 Mar 2019 21:24:16 GMT

Reload is not happening, failed

Re: QMC task

priyarane — Wed, 06 Mar 2019 21:27:28 GMT

thanks for the reply, Doc log is not creating for this document. We have many documents over there in the same folder and those are running fine without an issue.

Re: QMC task

hopkinsc — Wed, 06 Mar 2019 21:31:04 GMT

if you make sure the doc logs are enabled for the QVW in question, then try running a manual reload. If no log is created then this confirms the answer that Brett provided. Is there section access on the QVW?

Re: QMC task

hopkinsc — Wed, 06 Mar 2019 21:37:08 GMT

What if you copy and paste the QVW, the copied version shouldn't have a lock on it (if that's the cause) , you can then test the reload on that one.

Are all of the QVWs in the same folder? i.e. are working QVWs in the same folder as the non working QVW? if they are in different folders then you could also try and move it to a folder that has a working QVW (if it doesn't mess up any data locations) and try and reload from there. That will rule out any issues with folder permissions.

Has the reload EVER worked from the QMC?

Re: QMC task

priyarane — Wed, 06 Mar 2019 22:04:43 GMT

It comes sometimes only for ex if this job runs 10 times then we may get 2 to 3 times

Re: QMC task

hopkinsc — Wed, 06 Mar 2019 22:07:41 GMT

That sounds like its being 'locked' by something if its not every time., as Brett suggested. i would check things like anti virus like he said, make sure the Qlik directories are excluded. it might be that something is happening to that file at the same times the reloads are failing.

Re: QMC task

priyarane — Wed, 06 Mar 2019 22:11:16 GMT

IT support guys don't agree on it 🙂 as other jobs are not failing from the same folder. Only difference on this dashboard is we have bookmarks on Document and webpage as well.

Re: QMC task

hopkinsc — Wed, 06 Mar 2019 22:24:27 GMT

I don't see how any bookmarks could cause a reload failure.

Did you say that it works in the client or not, sorry i can't see a reply for that.

If it does, does it work all the time or is it the same as the QMC and fails a handful of times?

Because reloads from the QMC do actually work and just fails sometimes, it does suggest the file is being locked by something. I am not good enough on this subject to know what logs you could check at the time of a failure but I'm sure whoever your Qlik support agreement is with (Whether its Qlik them selves or a partner) would be able to help you if it comes to it escalate the problem if not resolved efficiently.

I work for a partner and my experience with Qlik Support has always been very good.

Sorry i couldn't help anymore, maybe someone else can chip in.

Re: QMC task

hopkinsc — Wed, 06 Mar 2019 22:29:20 GMT

Also, Brett's suggestion on bumping up the reload tries could be a work around whilst investigating the issue.

I did have this issue with one of my clients in the past and we bumped it up to 5 (if i remember correctly) and we very rarely seen the issue occur again. obviously the issue was still there, it was just being hidden. as long as the reloads work within those 5 times then thats all that matters for the users.

Investigation could carry on between you/IT/Qlik support in the mean time.