NullPointerException

[shalinim1]

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?

[kakooo16]

Hi ,

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

Hope this helps

[shalinim1]

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

[kakooo16]

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

[shalinim1]

​@not specified not specified​  PFA

Regards,

Shalini

[shalinim1]

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