Error When Exporting to Tableau Hyper File Type

[rjain]

Hello.  I am using Designer 2018.1 and have a legacy workflow that successfully exports to a .tde (Tableau Data Extract). 

I have converted my Tableau workbook to use a .hyper extract instead and would therefore like to export directly to .hyper file with the output tool. 

However, my legacy Alteryx workflow experiences the following error when exporting (output tool to .hyper file type).

Error: Designer x64: The Designer x64 reported: InboundNamedPipe::ReadFile: Not enough bytes read. The pipe has been ended.

I am still able to export with a .tde in the workflow below and can also export to .hyper for other 'from scratch' Alteryx workflows.  This appears to be an issue only with my legacy Alteryx workflow.

[jroot]

I'm seeing the same behavior in several of my workflows as well. All I changed was the Publish to Tableau tool and set to Hyper. If I change the publish to tableau tool back to TDE from Hyper it runs without error.

[MarshallG]

We are also seeing this error using the Publish to Tableau Server Macro when trying to publish to .HYPER file type. Works fine when publishing to .TDE

[thedr9wningman]

I'm having the same issue. 

https://community.alteryx.com/t5/Data-Preparation-Blending/Hyper-write-issue/m-p/144943#M22515 

[JessicaS]

Hi All,

If you aren't able to resolve, I would recommend shooting us an email at support@alteryx.com so that we can work with you to troubleshoot on these issues. 

Thanks,

[rjain]

Thanks.

I have now submitted this to Alteryx Support.


Runjan Jain, Data Analyst

[HossC]

Hey Everyone,

Just to give an update on this issue. We are aware of this behavior and are currently working on fixing it. We do hope to have this resolved in a future release. In the meantime, here is the workaround:

This issue appears to occur when users try to output a hyper file that contains extended ASCII characters (https://www.asciitable.com/) 128-255 as a standard string (v_string or string). This can be resolved by stripping these characters. This can be done using a Data Cleansing tool or by field type to "vw_string" or "w_string".

Thanks!

[lepome]

I had a customer insert a Select tool and just recast all the strings as VW_String.   (@HossC suggested that above but didn't specify the Select tool by name.)  That worked too.

[thedr9wningman]

I've been recasting my variables, and now I'm still having the issue.

The use case is that the create new extract file version of the output file tool works, but if I try the overwrite mode, it doesn't work. 

I have made a habit of doing the data cleansing and changing all the string fields to VW fields, which is onerous. Now I still can't write to hyper, which saddens me. 

Also: As far as I know, there aren't any extended ASCII characters in my data set. Just regular, stupid characters A-z. 

[archit14]

Hi All,

I found the solution. Just removing ASCII characters does not help. You need to do the below steps:

1. Convert all "string" or "v_string" to "V_WString". (Use Select Tool and convert them)

2. Use Output Tool and select .hyper as data type. Save the .hyper output file locally on your machine. (Do not use Publish To Tableau Tool, yet)

3. Open 10.5 Tableau dashboard, connect to local .hyper file. Replace data source to use this local .hyper file.

4. Publish the Data Source from your 10.5 Tableau Workbook, you can overwrite an existing data source on your Tableau server.

5. Go back to your workflow, replace the output tool with the v2018.1 Publish to Tableau tool. Select overwrite .hyper and to overwrite on Tableau server.