Re: QMC Reload job fails - I have provided full wr... - Qlik Community

rarora12 · ‎2018-12-03

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)

hopkinsc · ‎2018-12-03

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.

rarora12 · ‎2018-12-03

Hi Hopkinsc I have the log option selected but no log is generated. I am attaching the log i found in the directoryC :\ProgramData\QlikTech\DistributionService\1\Log\20181203\144843 - PreProd_DPP_Dashboard The interesting thing is if I remame the qvw with another name - it runs fine - but I cannot change the name of the qvw as it is used in an interface with another application THanks Rick 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

rarora12 · ‎2018-12-03

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

rarora12 · ‎2018-12-03

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

rarora12 · ‎2018-12-03

I have the option checked but no log gets created the log I have attached is all I can find in the folder
C:\ProgramData\QlikTech\DistributionService\1\Log\20181203\144843 - PreProd_DPP_Dashboard
If I change the name of the qvw then it runs just fine in the QMC scheduler
Thanks
R

hopkinsc · ‎2018-12-03

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?

rarora12 · ‎2018-12-03

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

hopkinsc · ‎2018-12-03

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'

rarora12 · ‎2018-12-03

I dont know how the qvw can be opened else where
I will give the suggestions above a try, i have restarted all the services already
Appreciate your assistance
Rick

QMC Reload job fails - I have provided full write access to the login