topic Re: Error java.lang.NullPointerException, when tLogRow has value not null in Talend Studio

Error java.lang.NullPointerException, when tLogRow has value not null

ATernovenko — Fri, 15 Nov 2024 23:22:04 GMT

Hello, Im new in Talend and I have some error.

TOS 7.3

I have Job exceloader8 which takes data from the excel file and loads into Oracle

table,

then archives and removes excel file from directory. Command to delete a file comes from tRunJob_2 as a variable ReturnCode

If "0" then tFileArchive,

If "1" then tFileCopy.

I get the value "0" from tRunJob_2 (tLogRow_2), but tJavaFlex_1 gives an error

Error message:

Exception in component tJavaFlex_1 (exceloader8)

java.lang.NullPointerException

at investigation_new.exceloader8_0_1.exceloader8.tFileList_1Process(exceloader8.java:1272)

at investigation_new.exceloader8_0_1.exceloader8.runJobInTOS(exceloader8.java:2257)

at investigation_new.exceloader8_0_1.exceloader8.main(exceloader8.java:2081)

tJavaFlex_1 is empty, fnd If(order:1) and If(order:2) have next code:

If(order:1)

((Integer)globalMap.get("row3.ReturnCode")) != 0 If(order:2)

((Integer)globalMap.get("row3.ReturnCode")) == 0I cannot understand why I am getting

NullPointerException

errorI would be grateful for your help

Re: Error java.lang.NullPointerException, when tLogRow has value not null

ATernovenko — Tue, 28 Dec 2021 16:01:52 GMT

my screenshots:

Re: Error java.lang.NullPointerException, when tLogRow has value not null

Anonymous — Wed, 29 Dec 2021 03:04:25 GMT

I think the problem comes from (Integer)globalMap.get("row3.ReturnCode"), this expression return null value. If ReturnCode is the schema column returned from tRunJob_2, you can change the job design as below:

...tRunJob_2--main--tJavaRow--runif1--tFileCopy

--runIf2--tFileArchive

on tJavaRow:

if(input_row.ReturnCode==0){

globalMap.put("doArchive",true);

globalMap.put("doCopy",false);

}else{

globalMap.put("doArchive",false);

globalMap.put("doCopy",true);

}

set the condition of runIf1:

(boolean)globalMap.get("doCopy")

set the condition of runIf2:

(boolean)globalMap.get("doArchive")

Regards

Shong

Re: Error java.lang.NullPointerException, when tLogRow has value not null

ATernovenko — Thu, 30 Dec 2021 09:53:49 GMT

Shong, thanks for advice!

I tried to do what you advised, but nothing came of it. The error is repeated. Error in tJavaRow block.

I think the problem is in the tRunJob_2 object.

Re: Error java.lang.NullPointerException, when tLogRow has value not null

Anonymous — Thu, 30 Dec 2021 10:02:06 GMT

the error occurs on tJavaFlex component. For debugging, deactivate the runIf link and tFilexxx Components and run again to see if the problem still exists.