tVerticaOutput java.lang.NullPointerException

Four Stars

tVerticaOutput java.lang.NullPointerException

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)

 

Capture.PNG

 

Any help or suggestioin to solve this error?

 

Thanks.

 

Moderator

Re: tVerticaOutput java.lang.NullPointerException

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch