Access to the cloud file is denied

[LinhNguyen]

Hi everyone,

I set up a workflow with dynamic input from OneDrive folder (synced to local folder) and my account (also ‘run as’ account) is the owner of these files (QV_ADMIN). The account I use on this computer is also the 'run as' account. There should have been no difference.

Whenever I run it manually, there will be no error but when I scheduled it using the desktop scheduler, the workflow returns access error (screenshot attached) and file reading error for xls files. Could anyone let me know why it doesn't work?

Thank you!

[BrandonB]

This is likely a permissions issue for the account. Can you please follow the following steps found here: 

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Run-As-Settings/ta-p/17830

"You may be encountering this issue if the Worker machine that is configured to run the workflows as a specified user does not have the appropriate permissions in the workspace folder where files are stored. Double-click the System Settings icon on your desktop to open the System Settings window and check the following settings:

• Identify the Workspace folder specified on the Worker > General screen.
• Open Windows Explorer and navigate to that folder.
• View the folder properties.
• On the Security tab, verify that the user specified as the Run As user exists in the list of users. If it does not, add it.
• On the same tab, highlight the specified user and ensure it has the following permissions: Modify / Read & Execute / Read / Write."

If this doesn't resolve your issue, please send an email to support@alteryx.com and we will assist you in getting this resolved. 

[LinhNguyen]

Hi @BrandonB , as I said in the question, the user specified as the Run As is the same as the account I used to open that machine (the admin account). That's why I said there should not be any difference running the workflow in the scheduler (compared to when I manually run it). 

I have sent an email to support@alteryx.com appx. 20 hours ago and received no reply. Do you think I should send another email or should I wait?

[BrandonB]

I understand that you have set your Run As account as your user account, but because this is a system process executing something AS your credentials there could be a couple of nuances in permissions. Can you take a look at this link, specifically under the batch job information and folder permissions: https://help.alteryx.com/20202/server/set-required-run-user-permissions

There may be a couple more things to confirm in addition to setting the scheduler to Run As your user account which hopefully the article addresses. As for the Alteryx Support team, they should be getting back to you soon so no need to send another email. 

[LinhNguyen]

Hi @BrandonB ,

Thanks for the clarification. I have added full access to my account to all folders and to the Log on as a batch job Properties as instructed in that link but still receiving the same errors. Is there anything else I can try?

Thanks,

Linh

[BrandonB · Accepted solution]

I think I may have figured out what is going on. I was doing some reading here: https://eazybackup.ca/knowledge-base/error-access-to-the-cloud-file-is-denied-backing-up-onedrive/ and realized that the file most likely isn't synced locally. Can you try right clicking on the file and "Always keep on this device" so that it syncs locally to see if it will resolve the issue: https://blogs.windows.com/windowsexperience/2017/06/13/onedrive-files-demand-now-available-windows-i...

[LinhNguyen · Accepted solution]

Keeping the file on my local computer solved it. Thank you so much!