topic Re: OnComponent Error in Talend Studio

OnComponent Error

Jennifer_siders — Sat, 16 Nov 2024 01:26:12 GMT

Hello All,

I have a scenario where tSalesforceInput component query is expecting a value based on a variable which is part of the query. However, if it doesn't get a value through this variable, the component fails throwing a null pointer exception and job doesn't continue. We would like to have the job continue with next record.

tFileinput -> tmap -> tFlowiterate ->tSalesforceInput

Thanks

Re: OnComponent Error

Anonymous — Fri, 18 Sep 2020 08:27:22 GMT

Hello,

Could you please post your job design screenshot here? Which will be helpful for us to address your issue.

Best regards

Sabrina

Re: OnComponent Error

vikramk — Fri, 18 Sep 2020 11:21:08 GMT

Hi Jennifer_siders ,

Could you try with a if-else condition for the column which you are getting null pointer exception, like this: if (column1!=null?column1:null) modify as per you requirement, if it doesn't work please post your job design

Re: OnComponent Error

Jennifer_siders — Fri, 18 Sep 2020 12:02:48 GMT

Hi @Xiaodi Shi @Vikram Kumar Thank you for the response.

The job flow is

tSalesforceinput component has a query which uses a variable from f4

The query inside the tSalesforceInput is :

select id, Name from Customer__c where Account__c = '"+globalMap.get("f4.AccountId" ).toString() , and as f4.AccountId is null, there is a null pointer exception once the tSalesforceinput executes.

Thank you very much.

Re: OnComponent Error

Jennifer_siders — Fri, 18 Sep 2020 12:29:20 GMT

Hi @Vikram Kumar

if (column1!=null?column1:null) if use this, are we not again sending null whenever column1 is null? and when the value is null, the system is throwing null pointer exception.

Re: OnComponent Error

vikramk — Sat, 19 Sep 2020 07:57:20 GMT

Hi Jennifer_siders,

As per your job, you would be getting nulls from tmap if you are getting f4.AccountId global variable from tmap. if you don't need them you can filter in tmap itself or you should filtering nulls from your global variable for : globalMap.get("f4.AccountId" ).toString() !=null

Let me know if it helps.

Re: OnComponent Error

Jennifer_siders — Sat, 19 Sep 2020 10:00:53 GMT

Hi @Vikram Kumar

Thank you for taking time. I think i am close to fix this. I am very new to Talend designing..so..

So in my job if tMap1->AccountId == null, then i dont want to continue to tMap3 and thus go to next record coming from tFileinputDelimited.

As you suggested to filter it in tMap1 or tMape_3, how do we actually do it? Could you advise?

Thanks

Re: OnComponent Error

Jennifer_siders — Sat, 19 Sep 2020 10:16:21 GMT

Hey i believe i have fixed it by using

in my tmap filter ! Relational.ISNULL(row2.Account__c)

Re: OnComponent Error

vikramk — Sat, 19 Sep 2020 14:51:19 GMT

Glad to hear that you were able to fix. Thanks