error while running the job

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
harshada
Premium Member
Premium Member
Posts: 92
Joined: Tue May 29, 2007 8:40 am

error while running the job

Post by harshada »

I am getting the following error while running the jobs through a sequence.
main_program: ORCHESTRATE step execution terminating due to SIGINT.
Earlier also I have faced the problem.But simply re-running the job has worked out. But now I am geeting this problem everytime.
dsdeveloper13
Participant
Posts: 10
Joined: Thu Aug 28, 2008 12:40 am

Re: error while running the job

Post by dsdeveloper13 »

Any more information about the job? Like what stages are being used.
Are there any other warnings and errors in the log that might help in understanding what might be going on?
harshada
Premium Member
Premium Member
Posts: 92
Joined: Tue May 29, 2007 8:40 am

Re: error while running the job

Post by harshada »

other warining messages are

APT_CombinedOperatorController(2),2: Field 'DESCR' from input dataset '0' is NULL. Record dropped.
APT_CombinedOperatorController(2),2: Warning, all other rejected records will be silent.

Even if the jobs runs successfully it gives the above two warnings.
This is basically production job and in production for ages.But for only from last few days it has started giving problems. We have not done any code changes to the job.

The stages that are being used are
oracle.transformer,datasets,funnel,sort,de-duplication.
DSDexter
Participant
Posts: 94
Joined: Wed Jul 11, 2007 9:36 pm
Location: Pune,India

Post by DSDexter »

Can you provide what all activities are being done on the particular field?

May be that is where the problem might be. Also please specify the nullability of that field.
Thanks
DSDexter
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

You have not handled the null value for the fields DESCR
probably in the transformer stage.

to know at which stage, disable the combination
harshada
Premium Member
Premium Member
Posts: 92
Joined: Tue May 29, 2007 8:40 am

Post by harshada »

Thanks for the suggestions.
But the jobs have always throws the warnings and worked. This time also after trying 3 times the job worked without any code or data modofication.
Is it that SIGINT is some kind of interruption from unix server or the server is over loaded.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

may be you have some restricted warning limit and when the limit cross the job will fail this error.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Disable operator combination to learn which stage is throwing the error. This may provide more accurately-targeted diagnosis.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply