Informatica vertica target connector

Hi ,

I cannot see the option USE SINGLE TARGET in the target writer properties .

The session is getting failed due to the error

Severity    Timestamp    Node    Thread    Message Code    Message
ERROR    3/7/2014 5:47:20 PM    node01_nmetldev1    WRITER_1_*_1    VERTICA_1037    [ERROR] SQL error: [Vertica][VJDBC](100176) Failed to connect to host 10.xx.xx.xxx on port 5433. Reason: Connection timed out

The IP address shown is not at all the IP address given in the connection string .

Please look into it

Thanks,
Jaison


Comments

  • It is not necessary to give IP address of all the nodes, JDBC driver needs IP of one node.
    You may test if the JDBC connection is successful by other tool.
  • I'm getting same error when I try to load record which has date column in it from Informatica version 9.6.

     

    Is there any limitation in loading the date columns?

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.