tmap error

Five 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


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

All Replies
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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download