topic Re: tMap error Nullpointerexception in Talend Studio

tMap error Nullpointerexception

Anonymous — Sat, 16 Nov 2024 04:44:01 GMT

Hello Guys,

I'm new using talend and i tried to create a job who read a excel files and create two outputs at my oracle DB, using a conditional. If the column "Tipo de requisição" is "RNC" go to output1 and if the column "Tipo de requisição" is "CR" go to output2, in the first time i execute this job works well but now stops and give this mensage error

Exception in component tMap_16 (Carga_StagingArea)
java.lang.NullPointerException
at extract_to_oracledb.carga_stagingarea_0_1.Carga_StagingArea.tFileInputExcel_16Process(Carga_StagingArea.java:5877)
at extract_to_oracledb.carga_stagingarea_0_1.Carga_StagingArea.runJobInTOS(Carga_StagingArea.java:7249)
at extract_to_oracledb.carga_stagingarea_0_1.Carga_StagingArea.main(Carga_StagingArea.java:7099)

The expresion i'm using to filter1 is......... row16.Tipo_de_Requisicao.equals("RNC")

The expresion i'm using to filter2 is ..........row16.Tipo_de_Requisicao.equals("CR")

My input and output is string and if i remove this filters the job works.

I will attach some prints.

P.S : I don't have null valeus at "Tipo_de_Requisicao" column

Re: tMap error Nullpointerexception

TRF — Mon, 09 Sep 2019 14:32:35 GMT

This error occurs when a field of the expression is null. Double check your data and reverse thé expression like this:
"RC".equals(row16.Tipo_de_Requisicao)
to avoid null pointer exception

Re: tMap error Nullpointerexception

Anonymous — Mon, 09 Sep 2019 15:23:22 GMT

I reverse the expression, the error mensage is not showing more, but 0 rows was write in my DB

"RNC".equals(row16.Tipo_de_Requisicao) i put this in my expression

Re: tMap error Nullpointerexception

TRF — Mon, 09 Sep 2019 15:33:23 GMT

Try to execute the job with Debug Traces to check if the data are as expected (maybe something wrong in previous mapping or spaces at the end of "Tipo_de_Requisicao" field, ...)