Publish to Tableau Server- Issues with Alteryx 11.3 (UNION tool)

Hi all,

We use "Publish To Tableau Server" macro to publish Data Extracts to Tableau Server and when tried to connect to the Data Extracts from Tableau Desktop, we receive the following error. This has happened after the Alteryx Desktop & Server is upgraded to 11.3. After exploring the Alteryx workflow module by module, I came to a conclusion that this error is caused when the UNION tool checkbox "Set a Specific Output Order" is not checked. The error reproduces in case if the checkbox is not checked. May be an issue with Macro or UNION tool

TDE Eror.PNG

Please share if anyone have insights about this issue.

Thank you!!!

Publish

Datasets

Error Message

Macros

Tableau

Accepted answers

PeterS

Hi @mtakka1,

I wanted to reply with our findings for other Community users.

The error was occurring when using the Publish to Tableau Server macro. When Opening the data on Tableau Server the error came up as :

An error occurred while communicating with Tableau Server.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

Tableau data engine error: 40460: SimpleDatabase::SelectMetadataName: expected found=1, actual found=0 (fk=18446744073709551615 name="Extract" nameTable="SCHEMAS")
The table "[Extract].[Extract]" does not exist.

We also tested writing the data to a local .tde file using the Output tool and got the same error noted in the link in point 2 below.

Ultimately the issue came down to a non-visible character in the data that wan't allowing the .tde file to be created correctly. A couple ways that this can be resolved.

The non-visible characters could be removed using this method
Or change the trouble column to a V_WString, as explained in this article.

Hope this helps.

All comments

PeterS

Hi @mtakka1,

After checking the box to enable 'Set a Specific Output order' is the macro working correctly for you?

Was this happening for all .tde files you were publishing?

Could you please describe which Union tool you are referring to in the Publish to Tableau Server (PTS) macro? If you have a tool number for the Union tool you found and the Macro that it is part of that would help greatly in investigating the issue.

Could you please include screen shots of the Configuration windows in Alteryx for the PTS macro?

Thanks!

mtakka1

Hi PeterS,

Sorry if the question isn't clear enough. I was talking about the regular UNION tool in Alteryx. In the screen shot below, the UNION tool before the Publish to Tableau Server (PTS) macro is making the TDE corrupt if "Set a Specific Output order" is not checked and works fine if it checked. I am not sure if the error is being caused by other things, but I was able to reproduce this error with the UNION tool.

Thank you!!!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703