Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Error: Designer x64: InboundNamedPipe::ReadFile: Not enough bytes read

ChrisWisselo
5 - Atom

Hello everyone. 

 

I know, many, many posts exist with the same error message, but I wasn't able to find one that matches my situation.

 

If I query the database with a 'standard' data-input tool (table & column names hard coded), it works beautifully. 

However, the problem arises when I use a formula tool to create a query more dynamically (table & column name) and parse it into a dynamic input tool (replace string). 

 

When I test the generated query directly in the database, it works. 

When I test the hard coded query in data-input, it works. 

 

Checking with other threads, we verified the server memory (44GB of ram) and the query string that is generated is cut down to a bare 512 bytes.

When my co-worker runs the same data-input (static version), he gets the same error... 

 

Any suggestions?

 

1 REPLY 1
ChrisWisselo
5 - Atom

The error was triggered by table names in the (dynamic) query and the database.

Labels
Top Solution Authors