Netezza connector - Failed to write to named pipe

[Maximus_Jack]

Hi
I'm having a job, where i'm extracting data from Netezza table using Netezza Connector stage and inserting into another Netezza table ( Netezza connector stage). the job works perfectly when i load around 100,000 records, It aborts with the below error message if the load count exceeds beyond 100,000.

Error Message

Code: Select all

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

Job structure

Code: Select all

Netezza_Connector---->Transformer------>Netezza_Connector

I did some search, found the below link, IBM is asking to send logs and design, nothing useful.

https://www-01.ibm.com/support/knowledg ... 1010E.html

Really appreciate your response on this

thanks
MJ

[chulett]

There's also this, allegedly patched in an earlier release:

http://www-01.ibm.com/support/docview.w ... wg1JR41831

Still, in your shoes I'd contact support.

[Maximus_Jack]

Thanks for your response, I saw that and tried writing the named pipe files to a different directory, even then I'm facing the same issue.

As it is working for 100k records, It seems something is blowing up when number of records beyond a certain point.. not sure what is happening

[chulett]

Hence the suggestion to contact support.

Any chance the partition you are writing to is filling up?

[Maximus_Jack]

I don't think so, there is a lot of space and I tried writing the named pipe file to other directories as well, but facing the same issue.

Is there anyway to track what the netezza connector stage is doing, like enabling 'tracing' for the data, anything for specific stages?

[chulett]

I have no clue never having used the stage but perhaps someone else does. Or ask support.