Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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, ...)