Page 1 of 1

error while running the job

Posted: Thu Aug 28, 2008 4:04 am
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.

Re: error while running the job

Posted: Thu Aug 28, 2008 4:24 am
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?

Re: error while running the job

Posted: Thu Aug 28, 2008 5:20 am
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.

Posted: Thu Aug 28, 2008 5:51 am
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.

Posted: Thu Aug 28, 2008 6:45 am
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

Posted: Thu Aug 28, 2008 8:27 am
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.

Posted: Thu Aug 28, 2008 6:21 pm
by keshav0307
may be you have some restricted warning limit and when the limit cross the job will fail this error.

Posted: Thu Aug 28, 2008 6:59 pm
by ray.wurlod
Disable operator combination to learn which stage is throwing the error. This may provide more accurately-targeted diagnosis.