Page 1 of 1

Job aborted when no file found

Posted: Mon Jun 10, 2013 2:16 am
by meriem_ens
Hi,

I have a parallel job consisting of a sequentiel file stage reading from a unix filesystem.


The sequentiel file stage uses the file pattern read method and a wildcard in the file pattern. The job runs perfectly as long as there are files that matches this pattern on the unix box. The problem I'm having is when there is no file that matches this pattern the job gets aborted when it should only gives a warning and continue with the etl process.

I wonder if there is a way to change this behavior (from aborted to finished with warnings).

Thanks.

Data Stage version 7.5.3
HP-UX 11.23

Posted: Mon Jun 10, 2013 6:03 am
by BI-RMA
No. You have to check for files matching the pattern outside the actual job in a sequence (WaitForFile-activity or Unix-command).

Re: Job aborted when no file found

Posted: Mon Jun 10, 2013 6:03 am
by peddakkagari
Please set the "Missing File Mode"="OK" under File Properties->Options

Re: Job aborted when no file found

Posted: Mon Jun 10, 2013 11:26 am
by meriem_ens
peddakkagari wrote:Please set the "Missing File Mode"="OK" under File Properties->Options

Hi,

I can't find this option when I'm using the file pattern option

Posted: Mon Jun 10, 2013 11:27 am
by meriem_ens
BI-RMA wrote:No. You have to check for files matching the pattern outside the actual job in a sequence (WaitForFile-activity or Unix-command).
Hi, I had hoped of a less cumbersome way :cry:

thank you

Posted: Wed Jun 12, 2013 12:21 am
by sendmkpk
perhaps a before job routine, to create an empty file, if file not found

this would also be cumbersome..................