Null Pointer exception in tRunJob

[Anonymous]

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.

[Anonymous]

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.