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

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

JaneYu — Tue, 30 Jan 2018 21:09:51 GMT

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.

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

Anonymous — Wed, 31 Jan 2018 04:04:52 GMT

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

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

manodwhb — Wed, 31 Jan 2018 08:49:40 GMT

would you mind to post your job here?

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

Anonymous — Wed, 31 Jan 2018 10:18:27 GMT

Hello,

Screenshots of your job setting will be preferred.

Best regards

Sabrina

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

JaneYu — Wed, 31 Jan 2018 14:12:51 GMT

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.

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

JaneYu — Wed, 31 Jan 2018 20:40:02 GMT

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