Job aborted when no file found

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
meriem_ens
Participant
Posts: 30
Joined: Thu Jun 06, 2013 9:12 am

Job aborted when no file found

Post 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
BI-RMA
Premium Member
Premium Member
Posts: 463
Joined: Sun Nov 01, 2009 3:55 pm
Location: Hamburg

Post 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).
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
peddakkagari
Participant
Posts: 26
Joined: Thu Aug 12, 2010 12:07 am

Re: Job aborted when no file found

Post by peddakkagari »

Please set the "Missing File Mode"="OK" under File Properties->Options
meriem_ens
Participant
Posts: 30
Joined: Thu Jun 06, 2013 9:12 am

Re: Job aborted when no file found

Post 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
meriem_ens
Participant
Posts: 30
Joined: Thu Jun 06, 2013 9:12 am

Post 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
sendmkpk
Premium Member
Premium Member
Posts: 97
Joined: Mon Apr 02, 2007 2:47 am

Post by sendmkpk »

perhaps a before job routine, to create an empty file, if file not found

this would also be cumbersome..................
Praveen
Post Reply