Abnormal termination of stage

vintipa · Post by **vintipa** » Fri Sep 25, 2009 5:43 am

Hi Experts,

We have Scheduled hundreds of Jobs to run every night. Jobs ran fine till last week. But since few days randomly some jobs get aborted with the error : Abnormal termination of stage.

There is no other warning or error message. Both sequencers and the jobs fail. these Jobs if reset and run afain then they run fine. So only scheduled jobs are getting aborted with this error.

Please suggest me how to know the reason for these aborts.

regards,
vinay.

chulett · Post by **chulett** » Fri Sep 25, 2009 7:07 am

There must be other messages logged with this. If you manually Reset the aborted jobs, is there a 'From previous run...' message logged? If so, please post it.

vintipa · Post by **vintipa** » Fri Sep 25, 2009 7:38 am

Creg,

Error: Abnormal termination of stage RRE_LoadHRP1003..Transformer_183 detected.

this is the only error that we are getting. no other warning or error.

regards,

chulett · Post by **chulett** » Fri Sep 25, 2009 7:43 am

And when you Reset the job?

vintipa · Post by **vintipa** » Fri Sep 25, 2009 7:46 am

When reset the job and run, it runs fine without any warings or errors.

vintipa · Post by **vintipa** » Fri Sep 25, 2009 7:56 am

hey But one perticular job that reads a table and writes into a hash file gave the following warning while it was reset.

error: TedEmp_LKP_TedEmpPSA..Ted_Emp_PSA_Hash.To_TGT_PSA: DSD.UVOpen Unable to open file '/dsdata/Tedweb/Lookup/Ted_Emp_PSA'.

This is the same job that gave the previous mentined error.

chulett · Post by **chulett** » Fri Sep 25, 2009 7:58 am

That's not what I asked. Find an Aborted job, Reset the job from the Director and tell us if any 'From previous run...' messages get logged.

Find out what changed last week, obviously something did. To me it sounds like a resource issue if you have the problem when "hundreds" of jobs are running but they work fine when rerun on an individual (or small number) basis.

chulett · Post by **chulett** » Fri Sep 25, 2009 7:59 am

Those errors logged during the reset are meaningless and can ignored.

vintipa · Post by **vintipa** » Fri Sep 25, 2009 8:32 am

No...

there is no other warning or error when the job is reset.

chulett · Post by **chulett** » Fri Sep 25, 2009 9:32 am

That's going to make your job difficult. I'd still pursue the resource angle and also involve your official support provider.

vintipa · Post by **vintipa** » Fri Sep 25, 2009 9:36 am

OK Craig,

I'll try in the directions mentioned by you.

thanks

vintipa · Post by **vintipa** » Wed Oct 07, 2009 5:01 am

Hi All ,

I restarted the Unix server where the datastage is installed.
this brought down the paging space utilization from 4.2 % to .5 %.
and the jobs are not geeting aborted now. so restarting to clear unreleased memory helped.

Thanks to all,
:D