Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rarora12
Creator
Creator

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

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)

16 Replies
hopkinsc
Partner
Partner

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

hopkinsc
Partner
Partner

Something else to note is that any antivirus on the server needs to ignore all Qlik extensions 

i.e.

QVW

QVD

PGO

SHARED

META

INI

CONFIG 

and anything else from the Qlik folder structure. 

hopkinsc
Partner
Partner

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?

rarora12
Creator
Creator
Author

It fails instantly
It has been running successfully until about a few days ago
All other tasks are successful but they dont reside in this specific folder
If I move this qvw out of this folder and set up a new job in qvc then it runs fine
I believe it has some thing to do with access for this specific folder - but its puzzling
I will keep trying different options
Thanks for your time
Rick
rwunderlich

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.

-Rob

rarora12
Creator
Creator
Author

Hi Rob
If I use QlikView and open the qvw and file, save as Name_2 then run the newly named qvw it works fine in the QMC Scheduler.
The other application is a web application that opens the specific qvw via the access point. It is not being loaded by another qvw.
Thanks
Rick
vvvwvvvw
Contributor
Contributor

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?