"java.lang.NullPointerException" showing while transforming records from staging table to target table?

[manmathpanda]

Hi Developers,

I am facing an issue in transform map and the issue is like while run transfer , error is showing as "java.lang.NullPointerException" .

For this i checked below

1> checked the mappings of source table and target table and the mapping is correct

2> in community i found that if date type of source table "basic data/time" then this error is showing but in staging table the date type is mentioned not "Basic data/time".

3> To check without date field and scripts , i removed these fields from mapping table and tried to run the transform map but still this error is showing , so could not understand what will be the issue here.

Need suggestion from you dear developers.

In transform history , shwoing as below

Regards,

Manmath

[Pratiksha Kalam]

Hi,

Null Pointer Exception occur when type of variable is different than already defined. So,kindly check type of variable that you want transform.

Please find below link will definitely help you,

https://community.talend.com/t5/Design-and-Development/resolved-NullPointerException-possible-bug-in... 

If my answer is helpful mark it as helpful and correct

Regards,

Pratiksha

[Ankur Bawiskar]

Hi Manmath,

Data type of all fields in source table would be string by default

so when you removed the date or date/time field maps still the error is coming; so it means issue is with some other fields

can you share screenshot of the field maps; which field you have set as coalesce?

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[manmathpanda]

Hi Ankur,

These are the field maps done.

Regards,

Manmath

[manmathpanda]

Hi Ankur,

Did you get anything from there?

Regards,

Manmath