Informatica throwing the error-"Failed to create JDBC Connection:<Host_name>"

Hi,

 

We have recently upgraded Vertica to 7x after configuring at Informatica(9.5.1 HF4) end we are getting JDBC connection error.

 

I have followed all the steps provided in the Document Informatica Plugin guide(attached).

 

ERROR : (25242 | MAPPING) : (IS | AL_Integration) : AL_Node2811 : JAVA PLUGIN_1762 : [ERROR] Failed to create JDBC Connection: lxv1176.appl.ge.com.
ERROR : (25242 | MAPPING) : (IS | AL_Integration) : AL_Node2811 : JAVA PLUGIN_1762 : [ERROR] at com.vertica.informatica.powerconnect.server.common.ConnectionObj.init(Unknown Source)
ERROR : (25242 | MAPPING) : (IS | AL_Integration) : AL_Node2811 : JAVA PLUGIN_1762 : [ERROR] at com.vertica.informatica.powerconnect.server.common.VerticaJDBCConnection.create(Unknown Source)
ERROR : (25242 | MAPPING) : (IS | AL_Integration) : AL_Node2811 : JAVA PLUGIN_1762 : [ERROR] at com.vertica.informatica.powerconnect.server.reader.VerticaReaderSQDriver.init(Unknown Source)

 

I am attaching the SessionLog for your Reference.

 

Can someone help me here.

 

Thank you in Advance,

Ram

Comments

  • Moving to the Vertica forum, so you'll hopefully get a response. :)

Leave a Comment

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