topic Re: Null pointer error with SCD component before data arrives in Talend Studio

Null pointer error with SCD component before data arrives

mobmsc2 — Thu, 06 Jul 2017 15:59:48 GMT

Using Talend Open Studio 6.4.0 I am trying to make use of the tMysqlSCD component. When I run the job I immediately get a null pointer error, even when no rows have been ingested or processed through the job.

My input doesn't have null values for the primary key and the surrogate key is generated by talend based on the settings of the SCD component

The job has 2 sql connections to read main and lookup flows from a staging database and then write to a data mart using SCD

Exception in component tMysqlSCD_1 (jobname) 
java.lang.NullPointerException at projectworkspace.jobname_version.jobname.tMysqlInput_1Process(jobname.java:2288) 
at projectworkspace.jobname_version.jobname.tMysqlConnection_1Process(Researcher_Dimension.java:687) 
at projectworkspace.jobname_version.jobname..runJobInTOS(Researcher_Dimension.java:5741) 
at projectworkspace.jobname_version.jobname..main(Researcher_Dimension.java:5502)

Is there something obvious I am missing

Re: Null pointer error with SCD component before data arrives

cterenzi — Thu, 06 Jul 2017 19:35:29 GMT

Just guessing since I can't see your job layout, but does your tMysqlSCD component rely on a tMysqlConnection component for its connection? If so, you have to ensure that the connection component executes before subsequent components. You can do this with a trigger link (OnSubjobOK) or by attaching the connection component to a tPrejob component.

Re: Null pointer error with SCD component before data arrives

Anonymous — Fri, 07 Jul 2017 02:35:14 GMT

Hi,

Could you please post your job setting screenshots on forum? Which will be helpful for us to address your issue.

Best regards

Sabrina

Re: Null pointer error with SCD component before data arrives

mobmsc2 — Fri, 07 Jul 2017 09:16:36 GMT

thanks @cterenzi and @xdshi

The before picture, I had the connections set on Component Ok because I assumed it would validate the connection (never really considered it a subjob)

The After Picture

Job runs without null pointer on SCD

Re: Null pointer error with SCD component before data arrives

cterenzi — Fri, 07 Jul 2017 14:01:50 GMT

Glad your problem was fixed