topic Re: Error on tOracleInput on Lookup --> tMap in Talend Studio

Error on tOracleInput on Lookup --> tMap

Anonymous — Tue, 31 May 2016 15:53:23 GMT

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.

Re: Error on tOracleInput on Lookup --> tMap

Anonymous — Tue, 31 May 2016 17:04:05 GMT

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.

Re: Error on tOracleInput on Lookup --> tMap

Anonymous — Wed, 01 Jun 2016 08:15:35 GMT

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

Re: Error on tOracleInput on Lookup --> tMap

Anonymous — Wed, 01 Jun 2016 08:48:53 GMT

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

Re: Error on tOracleInput on Lookup --> tMap

Anonymous — Wed, 01 Jun 2016 18:15:02 GMT

@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.