We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Informatica Vertica Plug In Broken Pipe — Vertica Forum

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