topic Re: Error tFileOutputExcel when job runs in Talend Studio

Error tFileOutputExcel when job runs

Anonymous — Tue, 07 Mar 2017 18:00:47 GMT

Hi,

I'm getting the following error periodically when a job runs every 15 minutes:

Exception in component tFileOutputExcel_1
java.lang.RuntimeException: java.io.IOException: No such file or directory

It only occurs on occasion, and i can't see any reason why - does anyone have any experience or suggestions which may be causing this?

Thanks.

Re: Error tFileOutputExcel when job runs

TRF — Wed, 08 Mar 2017 10:16:28 GMT

Hi,
Is your filename / directory constant or dynamic?

Re: Error tFileOutputExcel when job runs

Anonymous — Mon, 27 Mar 2017 14:17:02 GMT

Hi,
Completely static file name.

Re: Error tFileOutputExcel when job runs

Anonymous — Mon, 27 Mar 2017 16:03:32 GMT

monkeyb33f wrote:
Hi,
Completely static file name.

Hi,
This error can occur if program is not able to find the directory.
Can you please add tFileExist before your output subjob and check if the directory in which the tFileOutputExcel_1 output file is to be saved exists or not.

Alternatively you can mark the check box for create directory if does not exists in your tFileOutputExcel_1 component.
Hope it helps.

Re: Error tFileOutputExcel when job runs

Anonymous — Tue, 28 Mar 2017 13:58:22 GMT

Hi,

Thanks for your input. I'll add the tFileExist to have a control and prevent errors occurring.

I might be being daft - but there isn't an option to create directory on the tFileOutputExcel component is there?

Re: Error tFileOutputExcel when job runs

TRF — Tue, 28 Mar 2017 14:13:19 GMT

Hi,
tFileOutputExcel, Advanced settings and check option "Create directory if does not exist"

Re: Error tFileOutputExcel when job runs

Anonymous — Tue, 28 Mar 2017 14:17:38 GMT

Hi,

Yes, sorry, i was being daft!

It was already checked however.