topic Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error in Alteryx Server Discussions

"Publish to Tableau Server" Tool on Alteryx Server App returns error

gjunhao96 — Tue, 31 May 2022 12:24:28 GMT

Hello all,

I'm trying to use the Publish to Tableau Server tool within an app on Alteryx server.

The problem is that the Publish to Tableau Server tool (in designer) will first write the data into my C drive (as seen in the image).

Resulting in error on App:

Error opening the file "Tool #227: C:\ProgramData\Alteryx\Engine\Engine_7536_4db0e047066d5040aed74227a079e4ee_\XXXXXXX.hyper": The filename, directory name, or volume label syntax is incorrect. (123) (ToolId: -1)

Is there any way to write it to the same shared folder? I tried to point temporary files to the right folder (Configuration --> Run Time --> Temporary Files) but the Publish to Tableau tool still writes to C drive.

UPDATE:

I noticed that the app actually DOES publish the data to Tableau Online and also export the file as an .xlsx as intended. However, the app returns an error.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

gjunhao96 — Tue, 31 May 2022 08:30:40 GMT

Tried to point temporary files to the right folder (Configuration --> Run Time --> Temporary Files) but the Publish to Tableau tool still writes to C drive.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

DataNath — Tue, 31 May 2022 08:32:54 GMT

@gjunhao96 are you able to show your configuration of the tool? And/or your wider workflow? Would help!

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

gjunhao96 — Tue, 31 May 2022 08:53:47 GMT

Thank you for the reply.

Here is the screenshot of the configuration tool and a small part of the workflow. The workflow is the second part of a 2 part chained app.

Basically the workflow creates rows of data that I want to publish to Tableau Online to create visualizations.

Additionally, I also notice that the app actually DOES publish the data to Tableau Online and also export the file as an .xlsx as intended. However, the app returns an error.

Hope this helps.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

DataNath — Tue, 31 May 2022 09:09:25 GMT

What is tool #227? If it's showing an error but your app is still working as intended, can you disable this? The only other thing I can think of without looking to deep into the flow is using relative filepaths instead of absolutes, as it seems like the app is still looking for things hosted locally. If you go to Options > Advanced Options > Workflow Dependencies, trying using 'All Relative'?

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

gjunhao96 — Tue, 31 May 2022 13:34:39 GMT

Tool 227 is found within the Publish to Tableau tool macro. I have tried to uncheck the "Stop with error if file not found" to disable the error but it does not work.

Error opening the file "Tool #227: C:\ProgramData\Alteryx\Engine\Engine_19940_2a01d9645a38ae40ae8f7c1e3796a32a_\XXXXX.hyper": The filename, directory name, or volume label syntax is incorrect. (123) (ToolId: -1)

I also tried using all relative as shown. But it seems the publish to tableau server tool is not affected anyways. 😣

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

gjunhao96 — Wed, 01 Jun 2022 08:12:09 GMT

Hi all, just an update. I managed to get the app to work n Alteryx server. The issue was with AMP engine. Once I disabled it, the app works as intended.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

KenL — Fri, 10 Jun 2022 05:43:41 GMT

"C:\ProgramData\Alteryx\Engine" is actually the default Temporary Directory where temporary files used in processed workflows and apps will be placed. In an Alteryx Server Worker or Alteryx Designer (Admin version), the Temporary Directory can be configured in Alteryx System Settings > Engine > General.

@gjunhao96 , in this case I don't believe the Temporary Directory file path is responsible for this issue. We are currently looking into this behavior now.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

JonathanAllenby — Thu, 30 Jun 2022 14:09:48 GMT

Hey @KenL !

Just wanted to check in and see if you've had any insights or updates on this behaviour?
We've just had this exact situation reported to us by a customer today.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

JonathanAllenby — Wed, 06 Jul 2022 08:57:22 GMT

Just to add an update of my own, we've just had the following confirmed by Alteryx Support:

Regarding this issue, the status of the issue is still in development. The Defect ID is: GENG-2763.

In the meantime, running this tool in non-AMP is the only workaround we can perform.

If anyone else would like to receive updates, please log your own case as they can add it to the defect ID so you will receive future updates on the defect.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

KenL — Wed, 06 Jul 2022 09:10:07 GMT

Hey @JonathanAllenby , sorry for the late response.

With respect to this behavior where the Publish to Tableau Server tool throws the somewhat misleading error at writing the .hyper file to temporary directory (C:\ProgramData\Alteryx\Engine) "The filename, directory name, or volume label syntax is incorrect. (123)", a defect has been filed (GENG-2763) and added to the development backlog. At this time I can't provide timeline for any potential fix, and defects are often reprioritized alongside other development efforts.

As a workaround, apart from disabling the AMP engine on the workflow, I would suggest trying our newer Tableau Output tool instead. Reason being that the Publish to Tableau Server is going to be deprecated in future, and the Tableau Output tool will be its replacement.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

m_v — Tue, 27 Dec 2022 18:11:40 GMT

I'm running into the exact same issue while using the latest version of the tool. Disabling the AMP engine does the trick, however it makes the workflow run extremely slowly. Hoping this will be fixed soon!

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

KenL — Fri, 30 Dec 2022 03:18:12 GMT

Hi @m_v , a fix for this issue is currently targeted for the 2022.3 release. I would also suggest using our newer Tableau Output tool instead, because the Publish to Tableau Server tool has been deprecated, which means that going forward, there won't be further fixes to the tool.

Thanks,

Ken

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

m_v — Fri, 06 Jan 2023 15:51:27 GMT

I was having the same problem and then found out that the version of "Tableau output" tool that I was using was different from the version that we have on the server. Once I installed the correct version, it all worked.

Re: "Publish to Tableau Server" Tool on Alteryx Server App returns error

angelo_susubrado — Fri, 19 Apr 2024 20:30:55 GMT

My Workflow is now running in BLD Server after disabling the AMP Engine on my workflow. Thank you so much!!!