This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
community Data Science Portal alteryx .com community Data Science Portal alteryx .com community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Publish To Tableau Server Error: Access Is Denied

EricWe
Alteryx
Alteryx
Created

‎12-15-2020 02:50 AM

Environment Details


  • Alteryx Designer
    • Version 2018.1+
    • Desktop Automation license (Designer + Scheduler)
  • Publish To Tableau Server tool
    • Version 1.09
  • Tableau Server
    • Version10.5
 
Error creating the file “C:\ProgramData\Alteryx\Tools\PublishToTableauServer\TableauServer.Selection.ServerSite.yxdb”:Access is denied. 



When scheduling a workflow with a Publish To Tableau Server tool, there is an access denied error. The error does not occur when manually running the workflow. 

Cause


When Designer processes a Publish To Tableau Server tool, the tool’s macro generates a file with site selection information to complete the connection. If the workflow is scheduled with Desktop Automation, the Alteryx Service needs to write this file and it does not have permission. 

Resolution


Change the Alteryx Service log on account from the default of the Local System account to your Windows Active Directory account. 

Go to the Windows Search Bar, type in Services, and then in the Services screen, right-click on the Alteryx Service, and select Properties. 



Next, on the Log On tab, change the account to your Windows Active Directory account.

 
Comments
HelenL
8 - Asteroid
‎12-16-2020 10:52 AM

I'm getting Error: The file was not uploaded successfully.

  • I'm manually running the workflow.
  • The problem is occurring for multiple Alteryx workflows.
  • These have been in use for a long time (>12 months).
  • I've disconnected and connected the tool.
  • I have deleted the tool and configured it again.
  • I've shut down Alteryx and opened the workflow again.

 

I can publish from Tableau Desktop to Tableau Online. So Tableau Online is not down. 

 

Any thoughts welcome. 

 

Regards,

Helen

SabrinaCB
Alteryx
Alteryx
‎12-20-2020 11:27 AM

Hi @HelenL Thanks for posting. You mention that you are using Tableau Online. The error you are receiving is due to a separate issue, that started occurring after Tableau changed API responses in Tableau Online 2020.4 in some instances.


Please see the following article on how to resolve, and if you continue to encounter issues please don't hesitate to contact Alteryx Support. 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Publish-to-Tableau-Server-Error-The...

 

Hope that helps and Happy Holidays!

Sabrina

HelenL
8 - Asteroid
‎01-03-2021 11:30 AM

Thanks Sabrina. I've just been doing my month-end updates and it would have been a disaster without your timely advice above. I was pleased that I only needed to modify the connector once, not in every workflow. 

SabrinaCB
Alteryx
Alteryx
‎01-06-2021 11:37 PM

Thank you @HelenL ! Happy to help