InboundNamedPipe::ReadFile: Not enough bytes read. ERROR - SQL query

[jnash]

Hi All..

Im getting this error and its happening intermittently (I can run the workflow and it will work fine and then ill run it again without changing anything and ill get the error). Im using an input data tool to query a DB and making some tables. When it does error out, it seems it happens not even half way through the step. Any ideas on how to trouble-shoot this? Ive looked and have seen many people talk about union tools and corrupt ymdb files - unfortunately im not using any of those. 

Thanks for any help in advance!!

[missiecyclone]

I got this error again while outputting to a Tableau hyper extract file.  The workflow processed fine outputting to a tde extract and the autofield tool did not work, so I submitted a support ticket.  Here is the response that I got:

Thank you for reaching out to support. This is likely occurring because records in the data contain extended ASCII characters (https://www.asciitable.com/ 128-255). You should be able to work around the issue by adding a select tool to change the field(s) with these characters to a V_WString or a WString field type.

This fixed my issue.  Apparently, they are working on a permanent fix.