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:
Tool #103: Tool #402: Error trying to publish spreadsheet: HTTP/1.1 400 Bad Request Vary: Origin Vary: X-Origin Vary: Referer Content-Type: application/json; charset=UTF-8 Content-Encoding: gzip Date: Fri, 24 Jul 2020 02:05:39 GMT Server: ESF Cache-Control: private X-XSS-Protection: 0 X-Frame-Options: SAMEORIGIN Alt-Svc: h3-29=":443"; ma=2592000,h3-27=":443"; ma=2592000,h3-25=":443"; ma=2592000,h3-T050=":443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43" Transfer-Encoding: chunked
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.
