topic Re: Null pointer exception in tMap in Talend Studio

Null pointer exception in tMap

Rathesh — Thu, 28 Feb 2019 18:40:04 GMT

I am trying to read data from ldap and load it into sql server table. While loading IAM checking the phone(us format) and email format using code routines in tMap. In source, phone and email columns may having null or empty values. Code routines return null if the format doesn't match. In database, these two columns are nullable. Whenever null or empty comes from source, job is throwing null pointer exception in tMap

Re: Null pointer exception in tMap

Jj5 — Thu, 28 Feb 2019 18:52:43 GMT

Any field that you use code to manipulate needs to do null checks before the manipulation if null values are being passed. Try:
!Relational.ISNULL(fieldName) && fieldName.length() > 0 ? codeToDo :null

Re: Null pointer exception in tMap

Anonymous — Fri, 01 Mar 2019 05:25:54 GMT

Hi,

The NULL check and empty value verification can be done by above post. There are two specialized components in Talend which can perform Data Quality checks for email and Telephone numbers.

Please utilize them for data quality checks before inserting data to target table. The links for both components are as below.

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/8_Q4WAzPdmlNfO5mdguPVg

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/A9mfddr8XFdjPzBpQu6Izw

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂