topic Re: Null Pointer Exception after tAggregateRow in Talend Studio

Null Pointer Exception after tAggregateRow

HJlassi1619437866 — Mon, 21 Jun 2021 08:33:33 GMT

Hello, hope you're doing well,

I have a job to read data, transform it, aggregate two columns and then load data in informix database

tdbinput ---> Tmap ---> TaggregateRow ---> Tmap ---> tdboutput

columns are :

Client_Id

First_Name

Last_Name

Sexe

Age

Salary

Annual balance

tAggregateRow are working on salary and annual balance groupby id client

I get null pointer exception between tAggregateRow and Tmap

Please your answers will truly help me, thank you

manodwhb — Mon, 21 Jun 2021 10:43:11 GMT

@Houssem Jlassi ,you are getting null pointer exception in tMap, where you trying some expression without handling nulls.

example:-

row1.col1==null || row1.col2==null?0:(row1.col1*row1.col2)

Thanks,

Manohar

HJlassi1619437866 — Mon, 21 Jun 2021 12:40:57 GMT

Thank you for your reply, but i added a condition to test if my flow is null then replace it by -1

but i still get this error

manodwhb — Mon, 21 Jun 2021 14:07:49 GMT

@Houssem Jlassi , in tMap4, how many column are creating expressions other than direct fields you need to app for all.

Thanks,

Manohar

kakooo16 — Mon, 21 Jun 2021 15:53:40 GMT

Try using this :;

Relational.ISNULL(row6.column) ? -1 : row6.column if it is integer

Relational.ISNULL(row6.column) ? '-1' : row6.column if it is string .

Regards .

Amine