All my workflows with Publish to Tableau tools are not working!! Error Code 401001

[wale_ilori]

Hi everyone,

I'm not sure why this is happening and have searched widely for an explanation but nothin yet. All of a sudden, my workflows with the publish to tableau tool all stopped working. Could this be driven by a change in the environment or is there something else at play. I have 2 different configurations and they both stopped working.

The setup is Alteryx 11.7 publishing to Tableau Server 10.1 and also Alteryx 11.3 publishing to Tableau Server 9.3.

Now before you conclude that it may be something in the environment, a colleague mentioned the same occurred to him at another company (not sure of their setup) at the end of March or so.

I initially uninstalled all versions of the publish to tableau tool I had and reinstalled but the same error message.

[wale_ilori]

Just wanted to add in my case that I changed my windows log in creds recently and I can publish directly from Tableau desktop to the Tableau Server using the updated credentials.

[KaneG]

Hi @wale_ilori,

This message will be thrown when an error code comes back from the authentication request. So, I take from your post that you updated the Publish to Tableau Server tools with your new credentials. Are you then experiencing the error when running those workflows from Alteryx Designer, or only when you publish to Alteryx Server?

[wale_ilori]

When I publish from Designer. I have been told that it could be the presence of special characters in the password which is close to when the issues started but I'm sure I was able to run workflows with the new password before this occurred. If you have other thoughts, I'm all ears because changing the password will be a bit of a hassle if I can avoid it.

[KaneG]

I just had a look and if the password contains "<,>,&,%" or either of the 2 quotes then they will be escaped before the auth is attempted. This is because the API takes an XML payload and those characters have to be escaped in XML. Hence, any of those characters in the Username, password or SiteName will throw an auth error. I can't see a way around that...

[wale_ilori]

Does that include + and ! as well? I'm not using any of the ones you specified.

[KaneG · Accepted solution]

There is nothing in the PtTS tool that will replace those characters, however there is no control about what happens when the call gets to Tableau. I had a quick look and found that the error may simply be because the Tableau API doesn't like 2 special characters... I can't be certain though.

Kane

[wale_ilori]

Fair enough. Really appreciate the help. I'll look into changing it and let you know.

[wale_ilori]

@KaneG Apologies for the late confirmation. I tested with a different user id with just one special character and worked as before. Thanks a lot for your help