Page 1 of 1

External Source Stage problem

Posted: Fri Dec 31, 2010 12:43 am
by caola
Hi all

There's a weird problem of External Source Stage. Pls help..

My job is like:

External Source---->XML Input----->Transformer--->Sequential File
|
|rej link to Peek Stage
|
Peek


In External Source:
Source Method=Specific Program
Source Program = ls "#FileName#"

Most of the time this job works fine. But randomly there's no record output from External Source. In the log, the job is in finished status but has below line:
External_Source_0,0: Import complete; 0 records imported successfully, 0 rejected.

When I re-run the same job it finished with:
External_Source_0,0: Import complete; 1 records imported successfully, 0 rejected.

Posted: Fri Dec 31, 2010 3:33 am
by ray.wurlod
If the ls command reports no filenames, then the External Source stage will report 0 records imported. The whole thing depends on the value of the job parameter.