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.
I'll preface this an say I have a designer account and no access to our companies servers. The admin team has been in the midst of updating to the newest Alteryx Server they plan to support 2020.2, as well as migrate our servers to AWS. They have been unable to answer my problem. So I turn to this great community.
I have a several worklfows that write data to google sheets as the output but it seems this one is the only troublesome one.
It runs 4 times a day, output is small 160 columns and about 1300 rows. I get this error:
There are two Sheets outputs; one overwrites (drop) and the other appends. The Append on is what fails. It is by far the simpler of the two; essentially outputting an update log. Four columns and at most 15 rows.
When I run from my local, the workflow runs fine. But from Server, it has consistently failed.
if it runs on your own local Desktop but not on the server, you will unfortunately actually need help from the Server team to do the following:
1- RDP to the server box
2- Start Designer installed there
3- Open/download your workflow and try to run it on the Designer installed on Server. The message will be visual and more specific.
it could be that Google Sheet connector was not installed on the server or it is a different version of the tool than the one you used. Designer could also be a different version and that could in some cases explain why it behaves differently.
It could also be that the Run As user on the server (if it is used) doesn't have the required network access as well.