topic Re: NullPointerException in Talend Studio

NullPointerException

shalinim1 — Sat, 16 Nov 2024 01:15:57 GMT

Hi,

I have used tjavaflex to get date from global variable. when I run the job it is throwing Null pointer exception.

But all the cloumns are nullable in the schema.

It is throwing the following exception,

Exception in component tFileOutputDelimited_1 (test2)

java.lang.RuntimeException: The particular file "C:\Users\854493\OneDrive - Cognizant\Desktop\ihksddf.csv" already exist. If you want to overwrite the file, please uncheck the "Throw an error if the file already exist" option in Advanced settings.

at case_study_etl_process.test2_0_1.test2.tJavaFlex_1Process(test2.java:2170)

at case_study_etl_process.test2_0_1.test2.tDBInput_1Process(test2.java:1764)

at case_study_etl_process.test2_0_1.test2.tSetGlobalVar_1Process(test2.java:2902)

at case_study_etl_process.test2_0_1.test2.tPrejob_1Process(test2.java:2780)

at case_study_etl_process.test2_0_1.test2.runJobInTOS(test2.java:3134)

at case_study_etl_process.test2_0_1.test2.main(test2.java:2986)

How to solve this?

Re: NullPointerException

kakooo16 — Tue, 20 Oct 2020 13:47:29 GMT

Hi ,

you have to uncheck the case of the existing file if it exists in the advanced settings .

Hope this helps

Re: NullPointerException

shalinim1 — Tue, 20 Oct 2020 15:08:43 GMT

Thanks for your response @not specified not specified.. I have unchecked that, but still it is throwing the same exception.

Re: NullPointerException

kakooo16 — Tue, 20 Oct 2020 15:32:58 GMT

Could you please show your job design and the exact exception your are getting because the object of your message is that you are facing a NullPointerException but otherwise im reading an other exception in the explanation

Re: NullPointerException

shalinim1 — Tue, 20 Oct 2020 15:55:31 GMT

@not specified not specified PFA

Regards,

Shalini

Re: NullPointerException

shalinim1 — Tue, 20 Oct 2020 16:09:01 GMT

I want to write the source and target count values, table names, and start and end time of job and also the duration in '.csv' file. so I used tjavaflex to calculate the count values and start and end time