Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Thanks
Rick
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)
Hi.
Do you have the document log enabled? It would be in the same directory as the QVW with the same name but appended with .log.
if not could you enable that and reload then attach the log? or at least the error in the log.
I found the log in the following folder
The log options are checked for the qvw but there is no log in the same folder as the qvw
C:\ProgramData\QlikTech\DistributionService\1\Log\20181203\144843 - PreProd_DPP_Dashboard-
The interesting thing - 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
Thanks
20181203T144843.444-0500 Information DistributeTask[16200fb0-7f32-49cc-8f61-2af2f66a38df] ("PreProd_DPP_Dashboard"): TryStart - Starting task. Triggered by 'RetryStartTrigger'. Id:0000000c-000b-000a-0908-070605040302. ExecID:b46d2c91-e65c-42a1-b6e9-5b0cf9d1d3ee
20181203T144843.444-0500 Information Entering Task Execution.
20181203T144843.444-0500 Information ClusterID=1
20181203T144843.444-0500 Information QDSID=639f8e1f-e473-7bfb-3207-584b8db39b00
20181203T144843.444-0500 Information TaskID=16200fb0-7f32-49cc-8f61-2af2f66a38df
20181203T144843.444-0500 Information ExecID=b46d2c91-e65c-42a1-b6e9-5b0cf9d1d3ee
20181203T144843.444-0500 Information MaxRunTime=1.00:00:00
20181203T144843.444-0500 Information MachineName=SVROCMDCDPPBI01
20181203T144843.444-0500 Information Task execution max attempts=5
20181203T144843.444-0500 Information Task execution current attempt=5
20181203T144843.444-0500 Information Task Dependencies are OK
20181203T144843.459-0500 Information The task "PreProd_DPP_Dashboard" is starting
20181203T144843.459-0500 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
20181203T144843.475-0500 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)
20181203T144843.475-0500 Information Task Execute Duration=00:00:00.0312000
20181203T144843.475-0500 Information Sending Alert mail
20181203T144843.506-0500 Information TaskResult.status=Finished
20181203T144843.522-0500 Information Notifying all triggers of new state: "FinishedWithErrors"...
20181203T144843.522-0500 Information Notifying all triggers of new state: "FinishedWithErrors" - Completed
I found the log in the following folder
C:\ProgramData\QlikTech\DistributionService\1\Log\20181203\144843 - PreProd_DPP_Dashboard-
The log options are checked for the qvw but there is no log in the same folder as the qvw
The interesting thing - 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
Thanks
20181203T144843.444-0500 Information DistributeTask[16200fb0-7f32-49cc-8f61-2af2f66a38df] ("PreProd_DPP_Dashboard"): TryStart - Starting task. Triggered by 'RetryStartTrigger'. Id:0000000c-000b-000a-0908-070605040302. ExecID:b46d2c91-e65c-42a1-b6e9-5b0cf9d1d3ee
20181203T144843.444-0500 Information Entering Task Execution.
20181203T144843.444-0500 Information ClusterID=1
20181203T144843.444-0500 Information QDSID=639f8e1f-e473-7bfb-3207-584b8db39b00
20181203T144843.444-0500 Information TaskID=16200fb0-7f32-49cc-8f61-2af2f66a38df
20181203T144843.444-0500 Information ExecID=b46d2c91-e65c-42a1-b6e9-5b0cf9d1d3ee
20181203T144843.444-0500 Information MaxRunTime=1.00:00:00
20181203T144843.444-0500 Information MachineName=SVROCMDCDPPBI01
20181203T144843.444-0500 Information Task execution max attempts=5
20181203T144843.444-0500 Information Task execution current attempt=5
20181203T144843.444-0500 Information Task Dependencies are OK
20181203T144843.459-0500 Information The task "PreProd_DPP_Dashboard" is starting
20181203T144843.459-0500 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
20181203T144843.475-0500 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)
20181203T144843.475-0500 Information Task Execute Duration=00:00:00.0312000
20181203T144843.475-0500 Information Sending Alert mail
20181203T144843.506-0500 Information TaskResult.status=Finished
20181203T144843.522-0500 Information Notifying all triggers of new state: "FinishedWithErrors"...
20181203T144843.522-0500 Information Notifying all triggers of new state: "FinishedWithErrors" - Completed
it sounds like permissions, like it can't overwrite the QVW.
Can you run a manual reload from the QV client and save when finished?
if yes, then it must be permissions.
Are you able to confirm that the service account has full read/write access to the folder where the QVW is located?
I can run it manually and it works just fine - created a log also
Here is the folder and the userid I am trying that is a specific login that needs to be used instead of my personal id
Provided 2 screen prints
Thanks
It must be permissions related as the log in your original post states 'Access to the path 'D:\Qlik\AP_DEV\DPP_PREPROD_Final_AM.qvw' is denied.'
The QVW isnt open anywhere is it?
maybe try and kill any QVB process from task manager and even restart the Qlik server service just in case the QVW is 'locked'