topic Re: Null Pointer exception in tRunJob in Talend Studio

Null Pointer exception in tRunJob

Anonymous — Wed, 22 May 2019 10:24:43 GMT

Hi,

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)

Can anyone please help me out.

Re: Null Pointer exception in tRunJob

Anonymous — Wed, 22 May 2019 11:39:58 GMT

screenshots plz

Re: Null Pointer exception in tRunJob

akumar2301 — Wed, 22 May 2019 13:11:08 GMT

Screenshot would be needed.

Also check if your context are passed correctly to child job when you are running using tRunJob.

Re: Null Pointer exception in tRunJob

Anonymous — Wed, 22 May 2019 13:30:37 GMT

Hi,

Attached the screenshots.

Individual_Job.png
tRunJob.png

Re: Null Pointer exception in tRunJob

Anonymous — Wed, 22 May 2019 15:01:21 GMT

Hi,

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 🙂

Re: Null Pointer exception in tRunJob

Anonymous — Wed, 22 May 2019 16:27:39 GMT

Hi,

I am not passing any variables.

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.

component_Invidiual_Job.png
component_Job.png

Re: Null Pointer exception in tRunJob

Anonymous — Wed, 22 May 2019 17:10:27 GMT

Hi,

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 🙂

Re: Null Pointer exception in tRunJob

Anonymous — Wed, 22 May 2019 17:11:33 GMT

Each DB access (input/output) opens its own connection?

Re: Null Pointer exception in tRunJob

Anonymous — Thu, 23 May 2019 07:05:28 GMT

Hi Nikhil,
Even though I give a random value in table name, I am facing the same error.

Re: Null Pointer exception in tRunJob

Anonymous — Thu, 23 May 2019 07:05:48 GMT

No.

Re: Null Pointer exception in tRunJob

Anonymous — Thu, 23 May 2019 11:24:52 GMT

The problem is that, you are using a connection that is not yet created

Use tprejob to be sure you first open the connection before doing any other operation.