InboundNamesPip Get Overlapped Result

[morak_1449]

I have an Alteryx flow that captures data from a yxdb file, sort it and write it to Amazon Redshift: 

However, I get the following error: 

InboundNamedPiped GetOverLappedResult: The pip has been ended. 

The filed types and length are the following: 

I tried series of resolutions listed in the community discussion groups with no luck.

Can someone help with issue?

Thanks,

Morvarid 

[JoeS]

Hi @morak_1449 

This error is often memory related.

How much data are you trying to write? Will it work with a sample of the data?

[morak_1449]

I filtered data to write two records only but the same error happened. The table gets created in Amazon Redshift but data does not get populated to the table.

[fmvizcaino]

Hi @morak_1449 , 

I've experienced this error before in Redshift but honestly I dont remember.

But to check if the error is in redshift, you can check 

SELECT *

FROM stl_load_errors;

And see if there is anything related to your date columns.

Best,

Fernando V.

[JoeS]

---

@morak_1449 wrote:

I filtered data to write two records only but the same error happened. The table gets created in Amazon Redshift but data does not get populated to the table.

---

Ah OK.

Is it just this data/table? Are there any characters outside the English keyboard?

Have you tried creating a different data set and writing it to RedShift?

[morak_1449]

The table gets generated in Redshift but the flow doesn't populate it at all (I am on Amazon Workspace Environment - Can it be an issue?) 

I tried other flows but unfortunately the same error still exists. 

[morak_1449]

Thank you for your note. I'll give it a try and update you on the result.

[JoeS]

Could you try writing to an existing table rather than creating a new one?

Sorry to keep asking requests, trying to think what it might be.

[morak_1449 · Accepted solution]

The issue is resolved. The connection string on the output tool was updated by the DBA and it worked perfectly fine. So always check the connection string.