Error on tOracleInput on Lookup --> tMap

[Anonymous]

Hello,
My program is taking a delimited file and an oracleDB. They're linked at a tMap. But when the tOracleInput have the row as Lookup and not Main, I have this :

Exception in component tOracleInput_1

java.lang.NullPointerException

at glpi.titres_repas_astre_3_0_1.TITRES_REPAS_ASTRE_3.tOracleInput_1Process(TITRES_REPAS_ASTRE_3.java:3876)

at glpi.titres_repas_astre_3_0_1.TITRES_REPAS_ASTRE_3.tFileInputDelimited_3Process(TITRES_REPAS_ASTRE_3.java:1907)

at glpi.titres_repas_astre_3_0_1.TITRES_REPAS_ASTRE_3.runJobInTOS(TITRES_REPAS_ASTRE_3.java:5071)

at glpi.titres_repas_astre_3_0_1.TITRES_REPAS_ASTRE_3.main(TITRES_REPAS_ASTRE_3.java:4845)



Here a picture of the job :


 
Hope you can help me.

[Anonymous]

Hii,
   I have tested the scenario. It works fine in my Job. Now, We need to test join key you have used in tMap component. Please share the screenshot of tMap join condition for better understanding.

  

[Anonymous]

Ok, i may be stupid but my job is exactly the same that your second one. And that doesn't work...

                            
                    


                                                                         
 

[Anonymous]

... Well I just try in a new job and it's working. I'm sorry to have taken your time for nothing ...

[Anonymous]

@staginfo: you should always test the SQL of your db component in a SQL-Editor like squirrel or toad or ... !
Reason : if it is selecting some non existing column or table (or whatever) or has a Syntax error , you will get a nullpointerexception because no recordset is created.