0 rows transferred

kavuri · Post by **kavuri** » Mon Aug 27, 2007 2:01 pm

Hi I run a simple job Its showing that 0 rows, 0rows/sec on the link from transformer. But I got the output file showing the data. What might be the problem?

Thanks
Kavuri

ArndW · Post by **ArndW** » Mon Aug 27, 2007 3:40 pm

This can happen for a number of reasons. First of all, I've found the monitor to be unreliable (well, I sometimes use the term "Flakey") for PX jobs. If the stage you are looking at has been optimized out of the run then it will also show a 0 value. What stages are you using? Do the source stage and the the target stage show any rows processed? Have you changed your project settings for monitoring in any way?

ray.wurlod · Post by **ray.wurlod** » Mon Aug 27, 2007 4:47 pm

Don't rely on the GUI, for a whole heap of reasons.
Use the job log or monitor for a definitive row count.

Maveric · Post by **Maveric** » Mon Aug 27, 2007 10:38 pm

Is your job multi instance job? Multi instance jobs always show 0 rows as job statistics.

jwilliams · Post by **jwilliams** » Tue Aug 28, 2007 1:15 pm

It's also possible that an earlier, working version of the program wrote data to the destination file that was valid. Changing the program stages in a way that won't produce data means that the program may not work, but using the "View Data" function in the destination (I think of a seq. file at the moment) will show what data is in that file, regardless of the failure of the last run.

As is said above, don't trust the GUI, especially the View Data option. Check the data on its own.

ccatania · Post by **ccatania** » Tue Aug 28, 2007 1:41 pm

a few questions first:
How many rows are in the input files

Are there any constraints present

What is your taget file environment