I created a job in which data is loaded into redshift tables from the files present in S3. This is working fine when I run it individually but when I place it in tRunJob, I am getting the following error:
Exception in component tDBRow_1 (EXT_CT_DATE_D) java.lang.NullPointerException at local_project.ext_ct_date_d_0_1.EXT_CT_DATE_D.tDBRow_1Process(EXT_CT_DATE_D.java:1083) at local_project.ext_ct_date_d_0_1.EXT_CT_DATE_D.tS3Put_1Process(EXT_CT_DATE_D.java:979) at local_project.ext_ct_date_d_0_1.EXT_CT_DATE_D.tS3Connection_1Process(EXT_CT_DATE_D.java:640) at local_project.ext_ct_date_d_0_1.EXT_CT_DATE_D.runJobInTOS(EXT_CT_DATE_D.java:2734) at local_project.ext_ct_date_d_0_1.EXT_CT_DATE_D.runJob(EXT_CT_DATE_D.java:2538) at local_project.stage_load_encapsulated_0_1.Stage_Load_Encapsulated.tRunJob_1Process(Stage_Load_Encapsulated.java:574) at local_project.stage_load_encapsulated_0_1.Stage_Load_Encapsulated.runJobInTOS(Stage_Load_Encapsulated.java:956) at local_project.stage_load_encapsulated_0_1.Stage_Load_Encapsulated.main(Stage_Load_Encapsulated.java:710)
The screenshots are unfortunately not having full information as you have not shared the flow of the job where you are making call using tRunJob. Based on existing details, below are my thoughts.
The null pointer issue is happening in tDBRow_1 element. Are you passing any value to this element through any variables? If the answer is yes, the passing of values to this variable is not happening properly when you can calling them from the parent job. The best way to verify it will be by printing all the variables in a tjava to console before calling tDBRow_1.
Please give more screenshots of how you are calling the job, the component screenshot of tDBRow_1 etc. so that we can provide more thoughts.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
It is running without any error if done individually. Only when placed in trunJob, it is throwing null pointer exception. Attached the screenshots of components.
Please let me know if you need any further information.
The screen shot doesn't seems to have the details of tDBRow_1 where the error is present. But I could see that the table name value in your components do not have any value.
I would recommend you to use a dummy value or a random table name so that it is not generating any unwanted null pointer error.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
