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 am getting the below error while uploading the data to Tableau in the schedule job for last two days. This is running successfully earlier but it is failing now since I am pretty new to Alteryx so I am not sure what is causing it. The connection, credentials everything is good.
designer x64 Tool #226: TableauServer.PublishTDE.yxmc (592): Record #1: Tool #18: Tool #4: Tableau Server API Request (Publish file) Error Code 400011: Bad Request -- There was a problem publishing the file '5766:66F6E7B8DF9347A98D3993B85364BF9A-0:0'.
Thank you for posting to the Community. The error you are getting is a generic publishing error (https://onlinehelp.tableau.com/current/api/rest_api/en-us/REST/rest_api_concepts_errors.htm) coming from Tableau. One thing to try at first is to change any string type field in you data in Alteryx to V_WString. That includes any fields of type String, WString or V_String. Try to publish the data after making those changes. You also may want to try deleting the TDE file (please backup first) that you are likely overwriting.
I've had intermittent errors with the tool as well but in many cases I am finding that there are characters in the data that Tableau Server doesn't like. Most recently, the error was being rendered due to some Spanish punctuation characters such as ¿ in my SQL database.
If nothing has changed in your scheduled workflow and an error just started appearing, it's another place to look.
SELECT*FROM mbrnotes WHERE PATINDEX('%['+ CHAR(1)+'-'+CHAR(31)+']%',LINE_TEXT)>0
Bumping this thread since me and my team are having similar issue since we upgraded from 11.7 to 2018.4 last week.
We also upgrade to Publish tool 2.0, we now have intermittant error 400011, sometimes it works, sometimes tool wil error. Our companies current Tableau Server is 10.5.2, I believe they are upgrading to Tableau Server 2018.3 in a couple of months.
My data is very small/summarize, no weird characters, and all string fields are set to VW_String.
I ran into the same and tried what others above had suggested to no avail. Do you by chance have the instance of Tableau desktop open while you're running the workflow? I've been able to do this previously, but this time I closed out of both, opened only Alteryx, and had no issues running the workflow successfully.
Any chance you have a non alphanumeric character in your filename? That was my problem, while did generate the same error message... I was using the ampersand, and it appears the server doesn't like that. I removed the ampersand and the workflow completed fine with no errors. Hope this helps!