Four Stars

tmap error

Hello, I get an error message in tmap since I added the calculation of a quantity by a price.

Could you help me to decode this error message please, tanks

 

Démarrage du job test3 a 15:26 06/07/2017.
[statistics] connecting to socket on port 4023
[statistics] connected
Exception in component tMap_1 (test3)
java.lang.NullPointerException
at coupe2.test3_0_1.test3.tOracleInput_1Process(test3.java:1742)
at coupe2.test3_0_1.test3.runJobInTOS(test3.java:2341)
at coupe2.test3_0_1.test3.main(test3.java:2190)
[statistics] disconnected
Job test3 terminé à 15:26 06/07/2017. [Code sortie=1]

 

1.png

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Ten Stars

Re: tmap error

In some row, either T10_PV or T10_QTE is null. You'll either need to replace the null values in the SQL of your tOracleInput component or handle them in the tMap expression.
Ex: row1.T10_PV == null || row1.T10_QTE == null ? 0 : row1.T10_PV * row1.T10_QTE
1 REPLY
Ten Stars

Re: tmap error

In some row, either T10_PV or T10_QTE is null. You'll either need to replace the null values in the SQL of your tOracleInput component or handle them in the tMap expression.
Ex: row1.T10_PV == null || row1.T10_QTE == null ? 0 : row1.T10_PV * row1.T10_QTE