Error tFileOutputExcel when job runs

[Anonymous]

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.

[TRF]

Hi,
Is your filename / directory constant or dynamic?

[Anonymous]

Hi,
Completely static file name.

[Anonymous]

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.

[Anonymous]

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?

[TRF]

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

[Anonymous]

Hi,

Yes, sorry, i was being daft!

It was already checked however.