Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMap error Nullpointerexception

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" column0683p000009M6wl.png0683p000009M6wq.png0683p000009M6oy.png

 

 

Labels (3)
3 Replies
TRF
Champion II
Champion II

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
Anonymous
Not applicable
Author

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
TRF
Champion II
Champion II

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, ...)