topic Re: Error in QV Reload Schedule in QlikView

Error in QV Reload Schedule

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

Dear All,

Reloading failed when Rload through Publisher (Reload Schedule) please find log

(29/06/2017 6:57:21 PM) Error: The task "Reload of Inventory - Ghari\SND Inventory.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.WritePermissionkException: Failed to get write permission for file: E:\QV Dashboard\Inventory - Ghari\SND Inventory.qvw ---> System.UnauthorizedAccessException: Access to the path 'E:\QV Dashboard\Inventory - Ghari\SND Inventoryef6fee47-12f7-4700-922a-2167bd3427c4.tmp' 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, Boolean useLongPath, Boolean checkHost) || at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize, Boolean checkHost) || at System.IO.File.InternalWriteAllText(String path, String contents, Encoding encoding, Boolean checkHost) || 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.TaskExecuti

Re: Error in QV Reload Schedule

Peter_Cammaert — Thu, 29 Jun 2017 15:12:26 GMT

This big block of text says it all: "...Failed to get write permission for file: E:\QV Dashboard\Inventory - Ghari\SND Inventory.qvw...". At the end of every reload, the publisher must be able to store the new version of the document on top of the old. It seems unable to do this.

Check the file NTFS permissions of your document. Does the publisher account have Write permissions on this file?

Re: Error in QV Reload Schedule

vijayit43 — Thu, 29 Jun 2017 15:25:45 GMT

Allready Publisher Accounts provide Full permission and Services running through server admin and domain admin users.

Re: Error in QV Reload Schedule

Peter_Cammaert — Thu, 29 Jun 2017 15:33:02 GMT

That's what you may think is configured on the server. But did you effectively check it out?

The Windows Explorer Permissions dialog has a nice tab that allows you to verify for real whether a particular account has permissions to overwrite a particular file. It's called "Properties->Security->Advanced->Effective Permissions". Can you check this first, just to be sure?

Re: Error in QV Reload Schedule

vijayit43 — Fri, 30 Jun 2017 05:18:24 GMT

Hi Peter Cammaert,

Our IT Infra team Updated a security patches on the server for this access denied the tmp file on the server. IT team allowed tmp file access over the server then its working.thanks for your support.

Re: Error in QV Reload Schedule

Peter_Cammaert — Fri, 30 Jun 2017 06:27:03 GMT

You say that "IT team allowed tmp file access over the server then its working"

So I was right then?