JOB FAILING BECAUSE OF ZERO ROWS IN SOURCE

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
arjun_004
Participant
Posts: 12
Joined: Wed Feb 07, 2007 2:10 am
Location: Mumbai
Contact:

JOB FAILING BECAUSE OF ZERO ROWS IN SOURCE

Post by arjun_004 »

We are inserting data into a Teradata table using the Teradata Enterprise stage.
We observed that whenever there are zero rows in the dataset ( that is the input to this stage), the job fails with the following error:" The runlocally() of the operator failed"
Is this a shortcoming in the Enterprise stage? Is there anyway by which we can ensure that whenever files with zero rows are used, the job is run successfully without errors?
Thanks & Regards
Arjun Kumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Search the forum. This is known behaviour. The workaround is to check the number of rows before invoking the job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: JOB FAILING BECAUSE OF ZERO ROWS IN SOURCE

Post by chulett »

arjun_004 wrote:Is there anyway by which we can ensure that whenever files with zero rows are used, the job is run successfully without errors?
Use a Server job. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply