tableau server api request (publish file) error code 400011: bad request

[deendrjophmc]

I have an appended hyper tableau as my output. The output now has 24k + data and I was supposed to update/append 700+ more but this error shows up tableau server api request (publish file) error code 400011: bad request append.

Tried testing the same flow with fewer data but the same 700+ to append and no error.

Is there a way to troubleshoot this issue?  

[Felipe_Ribeir0]

Maybe it is the same problem: Solved: Publish to Tableau Server Error 400011 on Schedule... - Alteryx Community

[Ariharan]

Hi @deendrjophmc , 

Would it be possible for you to answer the following questions in order to better understand the issue.?

1. When publishing a fewer amount of data to the server, does it succeed or not?
2. How long will it take the Alteryx server to throw an error after publishing the 24k+ row? 

Please note that by default Tableau API authentication token is valid for 240 Mins only(4 Hours). After 4 Hours when the token is expired, the tableau Server requires the new token for authentication. I assumed this might be the problem in your case.  

Regards, 

Ariharan.R

[priyaarisetti]

my workflow needed to run more than 4 hrs and failing after 4 hrs everytime. How to resolve this issue?

[Ariharan]

Hi @priyaarisetti , 

When you get the response, you parse the token out of the response and store it in your application. By default, the token is good for 240 minutes. (You can specify a different timeout value for the token by calling the tsm configuration set command to change the wgserver.session.idle_limit setting.) If your application needs to be able to make additional calls after the token has expired, you can call Sign In again and get a new authentication token.

https://help.tableau.com/current/server/en-us/cli_configuration-set_tsm.htm

Regards, 

Ariharan R

[priyaarisetti]

Thanks for the reply, server settings set to wgserver.session.idle_limit -v 300. 

"If your application needs to be able to make additional calls after the token has expired, you can call Sign In again and get a new authentication token."

Can you please help to understand how to achieve this. Should i add another too before "Publish to Tableau Server" Tool.

[Ariharan]

Hi @priyaarisetti, 

No. You don't need to do anything in the workflow. Just change the Tableau TSM setting to increase the timeout. The authentication token will be valid based on the timeout you configured in the tableau.

Note:  Make sure your Alteryx system has a timeout value of not less than 4 hours.

Regards, 

Ariharan R

[priyaarisetti]

Hi Arihara, Thank You for your prompt reply.

TSM setting increased timeout to : 300 minutes (5 hours) and Alteryx i had the below settings.

workflow is failing after 6.30 hrs. and getting the below error.  Not sure if i am missing something.

The job The job OA_Transactions_HIST_2022_FX_Baseline did not complete successfully and resulted in the following errors:

• TableauServer.UploadChunks (238): Iteration #1: Tool #19: Tool #4: Tableau Server API Request (Upload file) Error Code 401002: Unauthorized Access -- Invalid authentication credentials were provided. (Tool Id: 4)
• Tool #252: Tool #4: Tableau Server API Request (Publish file) Error Code 401002: Unauthorized Access -- Invalid authentication credentials were provided. (Tool Id: 4)

 did not complete successfully and resulted in the following errors:

• TableauServer.UploadChunks (238): Iteration #1: Tool #19: Tool #4: Tableau Server API Request (Upload file) Error Code 401002: Unauthorized Access -- Invalid authentication credentials were provided. (Tool Id: 4)
• Tool #252: Tool #4: Tableau Server API Request (Publish file) Error Code 401002: Unauthorized Access -- Invalid authentication credentials were provided. (Tool Id: 4)

[priyaarisetti]

Attached is my workflow snip