The reload job fails with the write access error - I have not been able to resolve this issue
I have recreated the reload job and checked all access but nothing yet!!
See log below:
Time: 12/3/2018 2:48:43 PM 12/3/2018 2:48:43 PM Error The task "PreProd_DPP_Dashboard" failed. Exception: QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.WritePermissionkException: Failed to get write permission for file: D:\Qlik\AP_DEV\DPP_PREPROD_Final_AM.qvw ---> System.UnauthorizedAccessException: Access to the path 'D:\Qlik\AP_DEV\DPP_PREPROD_Final_AM.qvw' is denied. 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, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) 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 anyone else access the location?
Its a strange one as it looks like the service account doesn't have access to the location and/or write access to the file.
you mentioned it works when you rename the file, did you create a new reload task to test that?
Maybe one of the previous QVBs are still active for some reason, check that in task manager and kill any that are running.
I don't really know what else you could try.
Have you also checked for the document log in %ProgramData%\QlikTech\QlikViewBatch? maybe that will give some more detail
Something else to note is that any antivirus on the server needs to ignore all Qlik extensions
and anything else from the Qlik folder structure.
Something else that i didn't ask. Does it fail instantly or does it run the script but fail at the end?
Has it ever run successfully from the QMC?
Do you have other tasks that are successful?
Can you clarify what you mean by " if i change the name of the qvw and run the reload via qmc it works - cant change the name as it is used as an interface with another application".
What is the "other application"? Do you mean it's loaded by another qvw? Or something else? Because your statement suggests that maybe the file is in use by something else.
Having mostly same type of event(s).
Happens after user logs in then selects the QVW - when coincident with a refresh.
No logged event, no indicator of user that "caused" the failed refresh, even though "logged in." Three different users, on three different days, and me within 5 mins
The suggestion is that the QMC failed to get write access to the QVW file.
Permissions seem right, but getting second opinions.
Did you discover a solution or cause?