Access to the cloud file is denied

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!

cap.jpg

Scheduler

Accepted answers

BrandonB

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-insiders/

LinhNguyen

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

All comments

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703