QlikView UI: Failed to get write permission for file

[kashyapdhar]

Hello experts,

We are facing an issue with our QlikView reload on tasks.

Issue:

UI task runs as per the schedule. When the UI finally tries to save the file in server, we get below issue for files which are bigger in size and take time to save. In case some user is accessing the report in browser or as an app then the UI fails. 

Workaround: 

We understood that once the report is opened in the browser for the day, it loads up in the cache and any further access is from cache. But this understanding is wrong at-least for larger files and we still observe failures

Is there a possible solution to this issue.? We don't have an antivirus scanning the QlikView folders

Environment:

Distributed architecture

QDS and QVS on separate servers

QDS restarts done daily at BST hours (as part of our maintenance process)

Task Log: 

Error: The task "Reload of "*** QlikView Task Name *** "" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.WritePermissionkException: Failed to get write permission for file: ..\Environments\Production\UI\"*** QlikView Task Name *** ".qvw ---> System.IO.IOException: The process cannot access the file '..\Environments\Production\UI\"*** QlikView Task Name *** ".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)

[kashyapdhar]

Hi QlikView experts,

Any one has noticed this issue with there setup and how was it rectified? Any guidance will be much appreciated

[marcus_sommer]

AFAIK an opening within the qvs won't restrict the file-access. But maybe there are multiple accesses from the qds and/or any desktop client and/or further processes (beside any security tools there are also various OS processes which might have an impact).

Beside this what do you mean with larger apps - how big are the files and how long takes an average opening and storing? How often are the tasks scheduled and how often successful and how often does they fail? Within the document-log and the event-logs from QlikView and the OS should be a pattern noticeable.

- Marcus

[kashyapdhar]

Hi @marcus_sommer 

Thank you for your reply. 

By huge file i meant, files over 2GB in size (some are even over 5GB) and take roughly time between 2 minutes to 5 minutes depending on load server has since lot of scheduled reports run. 

Checked the task logs and document logs, 

document logs usually show no error and reflects the correct refresh of the report and UI completion

task logs however how the error i have already mentioned 

We have even checked and tried to recreate the issue in our development server, and it was replicated.

Triggered a run of UI

Simultaneously opened the UI and actioned few selections, UI in parallel was getting saved and it failed with above error

However, once the UI was opened, tried again to reload the UI and it got saved 

So not sure where exactly we have the issue. we have an antivirus running, but it doesn't scan the UI folder. We even looked at the UI being used in some other application, which is not the case 

Appreciate your assistance

[marcus_sommer]

I'm not sure that I could really comprehend your description. Therefore I would try to exclude no relevant causes. This means if by smaller applications everything works - there shouldn't be any general issue in regard to access rights or default-settings. At least not if these applications are doing quite the same like your other applications - means if these applications have any loop & reduce and/or any distribution and/or prj-folders or similar stuff and the all the smaller applications not - there might be any cause.

But if all are the same unless the size it indicates that anywhere a timeout happens which breaks the task directly or indirectly for example if the user-authentication is lost. Such things could be quite hard to detect. IMO the first look should go for the OS/QlikView event-logs and then for the security-logs and then to the network/storage including proxies and load-balancers.

- Marcus