Null pointer exception in tFileOutputDelimited component

nivedhitha — Wed, 19 Dec 2018 20:47:25 GMT

Hi,

I'm trying to use the output stream feature of the tFileOutputDelimited component and send the output to tDropboxPut without saving the file to a local directory. my job works fine if I disable 'use output stream' and save the output to my local directory. If I enable 'use output stream',then I get the following error.

Exception in component tFileOutputDelimited_1 (job_Extract_000_db2ToSilverpop)

java.lang.NullPointerException

at java.io.Writer.<init>(Writer.java:88)

at java.io.OutputStreamWriter.<init>(OutputStreamWriter.java:97)

at marketing_campaignextract.job_extract_000_db2tosilverpop_0_1.job_Extract_000_db2ToSilverpop.tDBInput_1Process(job_Extract_000_db2ToSilverpop.java:1686)

at marketing_campaignextract.job_extract_000_db2tosilverpop_0_1.job_Extract_000_db2ToSilverpop.tDropboxConnection_1Process(job_Extract_000_db2ToSilverpop.java:893)

at marketing_campaignextract.job_extract_000_db2tosilverpop_0_1.job_Extract_000_db2ToSilverpop.tDBConnection_1Process(job_Extract_000_db2ToSilverpop.java:753)

at marketing_campaignextract.job_extract_000_db2tosilverpop_0_1.job_Extract_000_db2ToSilverpop.tPrejob_1Process(job_Extract_000_db2ToSilverpop.java:518)

at marketing_campaignextract.job_extract_000_db2tosilverpop_0_1.job_Extract_000_db2ToSilverpop.runJobInTOS(job_Extract_000_db2ToSilverpop.java:3432)

at marketing_campaignextract.job_extract_000_db2tosilverpop_0_1.job_Extract_000_db2ToSilverpop.main(job_Extract_000_db2ToSilverpop.java:3260)

[FATAL]: marketing_campaignextract.job_extract_000_db2tosilverpop_0_1.job_Extract_000_db2ToSilverpop - tFileOutputDelimited_1 null

some background about the job:

I get data from db2 database (2 columns of type graphic and vargraphic) and converting it into string in the tMap.
I have a user defined routine for email validation and filter in records that have the proper email format in the tFilterrow component.

My input data doesn't have any null values.In the tDropboxPut I've checked 'Upload incoming content as File'

Attaching the screenshots of my job.

Please let me know what is wrong here

Thanks in advance for your help !!

Re: Null pointer exception in tFileOutputDelimited component

nivedhitha — Wed, 19 Dec 2018 20:50:43 GMT

Hi @xdshi / @vapukov,

Can you please help me out with my situation? Let me know if have to provide you with additional details.

Appreciate any inputs from you.

Thank you

Re: Null pointer exception in tFileOutputDelimited component

manodwhb — Thu, 20 Dec 2018 05:05:35 GMT

@nivedhitha,where are you setting the ((java.io.OutputStream)globalMap.get("excel_output_stream")) ?

since you have not set that value for the able variable,because of that you were getting null pointer exception. please check the below link how to use output stream.

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/orwGOyJ72nAubGeMxRyZ8w

Re: Null pointer exception in tFileOutputDelimited component

nivedhitha — Thu, 20 Dec 2018 23:39:46 GMT

Hi @manodwhb,

Thanks for your reply. Yeah I realized and got it to work

topic Re: Null pointer exception in tFileOutputDelimited component in Talend Studio

Null pointer exception in tFileOutputDelimited component

Re: Null pointer exception in tFileOutputDelimited component

Re: Null pointer exception in tFileOutputDelimited component

Re: Null pointer exception in tFileOutputDelimited component