tVerticaOutput java.lang.NullPointerException

[michaelliew]

Hi,

I am new to Talend and I am trying to load a csv file in MapR-FS to Vertica. Following is the error message that I encounter :-

Exception in component tVerticaOutput_1 (Bulk_Load_No_File_Generation)
java.lang.NullPointerException
 at local_project.bulk_load_no_file_generation_0_1.Bulk_Load_No_File_Generation.tHDFSInput_1Process(Bulk_Load_No_File_Generation.java:911)
 at local_project.bulk_load_no_file_generation_0_1.Bulk_Load_No_File_Generation.tHDFSConnection_1Process(Bulk_Load_No_File_Generation.java:430)
 at local_project.bulk_load_no_file_generation_0_1.Bulk_Load_No_File_Generation.runJobInTOS(Bulk_Load_No_File_Generation.java:1741)
 at local_project.bulk_load_no_file_generation_0_1.Bulk_Load_No_File_Generation.main(Bulk_Load_No_File_Generation.java:1590)

Any help or suggestioin to solve this error?

Thanks.

[Anonymous]

Hi,

The vertica DB connection is Ok with you?

Is your data in csv file successfully loaded into Vertica DB? Can you set up DB connection in  tverticaoutput component directly without using tverticaConnection to see if it works?

Best regards

Sabrina