Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Informatica Vertica Plug In Broken Pipe

I have been using the Informatica Plug-In for Vertica for about 6 months without issue. We recently moved our informatica host to the cloud. Now on occasion i get a broken pipe error.  I wait a while then rerun the job and it completes successfully. I'm assuming there is network trafic and some timeout/keep alive setting needs to be increased.  Any help appreciated. 

 

 

 

node01_xx : VERTICA_1037 : [ERROR] SQL error: [Vertica][VJDBC](100024) IOException while communicating with server: java.net.SocketException: Broken pipe. Refer to the inner exception for more detail.

 

node01_xx: JAVA PLUGIN_1762 : [ERROR] The Source Qualifier encountered a connection error. The error is [Vertica][VJDBC](100024) IOException while communicating with server: java.net.SocketException: Broken pipe. Refer to the inner exception for more detail..


node01_xx : JAVA PLUGIN_1762 : [ERROR] at com.vertica.informatica.powerconnect.server.reader.VerticaReaderPartitionDriver.run(Unknown Source)
node01_xx : SDKS_38200 : Partition-level [xxxx]: Plug-in #445050 failed in run().

 

 

Thank you,

 

Manny

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.