Exception in component tFileOutputDelimited_1 java.lang.NullPointerException error (partial output)

Highlighted
Six Stars

Exception in component tFileOutputDelimited_1 java.lang.NullPointerException error (partial output)

My output file has 385 fields and 125,151 records. (Pipe delimited text file, tFileOutputDelimited use append because there is a template file for the column headers)

I built the talend job and run in jams,and got error:

Exception in component tFileOutputDelimited_1  java.lang.NullPointerException error

 

I checked the output folder and the output file is there, but only has 18,000 records.

 

In talend job, I set the tMap: Store temp data on disk=true and Max buffer size=5000

in the advanced setting of Run job: check the "Use specific JVM arguments and set Xms1024M and Xmx4096M; 

It runs well before when there is only 350 fields. After adding 35 more fields, it got problem.

Please help. Thank you.

 


Accepted Solutions
Employee

Re: Exception in component tFileOutputDelimited_1 java.lang.NullPointerException error (partial output)

Can you share the sample job please.. it is nothing to do with additional fields. There could be multiple reasons:

1) Some field name is matching with Talend keywords

2) Some field expecting values (not nullable fields) but got NULL values in that

View solution in original post


All Replies
Employee

Re: Exception in component tFileOutputDelimited_1 java.lang.NullPointerException error (partial output)

Can you share the sample job please.. it is nothing to do with additional fields. There could be multiple reasons:

1) Some field name is matching with Talend keywords

2) Some field expecting values (not nullable fields) but got NULL values in that

View solution in original post

Forteen Stars

Re: Exception in component tFileOutputDelimited_1 java.lang.NullPointerException error (partial output)

would you mind to post your job here?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Moderator

Re: Exception in component tFileOutputDelimited_1 java.lang.NullPointerException error (partial output)

Hello,

Screenshots of your job setting will be preferred.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Exception in component tFileOutputDelimited_1 java.lang.NullPointerException error (partial output)

sjain: you are right. I run the job again with a filter branchID=1 (2000 records only) in talend studio and got the same error. I will double check the expression of the addition fields.

Thank you all for kind help.

Six Stars

Re: Exception in component tFileOutputDelimited_1 java.lang.NullPointerException error (partial output)

Finally I figured out the problem. One field has null value and length() function got error in Talend when it is null

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog