Error writing to named pipe

cyclogenisis · Post by **cyclogenisis** » Wed Mar 09, 2016 10:39 pm

I am getting this error message at ~ 4M rows on the target Netezza connectors stage:

TargetNetezaStage: Failed to write to named pipe /tmp/server02_49736_nzw_0_1_20160310041042104013. Error code: 32 (CC_NZPipe::write, file CC_NZUnixPipe.cpp, line 321)

The setup is

Code: Select all

Netezza (source) --> Netezza (Target)

Anyone have advice or solution? It is stopping our jobs from loading target table.

chulett · Post by **chulett** » Thu Mar 10, 2016 7:48 am

Typically that would mean that /tmp filled up.

cyclogenisis · Post by **cyclogenisis** » Thu Mar 10, 2016 9:18 am

I've tried to set it to other directories in thr named pipe location option which should have space but same error. Any other suggestions?

By the way what is the named pipe used for?

chulett · Post by **chulett** » Thu Mar 10, 2016 10:18 am

Should have enough space != does have enough space. Necessarily. Monitor the space during the load to be certain. Then we can move on to other possible causes.

The named pipe is used to transport the data through the ETL server.

cyclogenisis · Post by **cyclogenisis** » Thu Mar 10, 2016 10:45 am

What's weird is that I didn't see this file increasing in size while the job was running, so I'm wondering if data is transferred into named pipe in one large batch...

chulett · Post by **chulett** » Thu Mar 10, 2016 10:51 am

There's a number of factors since many UNIX processes can leverage the /tmp space. If you've moved it elsewhere and still have the issue you could be seeing a problem with the connector itself. Unfortunately all the "32" means is "broken pipe" which doesn't really tell us anything and several issues could cause the pipe to break. Probably best to involve support on this one.