Page 1 of 1
Abnormal termination of stage Jobname.transfermerstahename d
Posted: Wed Oct 14, 2009 9:21 am
by MURALI123
Hi,
Anybody suggest me how can we slove the below error :
Abnormal termination of stage Jobname.transfermerstahename detected
Posted: Wed Oct 14, 2009 9:59 am
by chulett
No, as that just means the job blew up. Got any more details? Also try Resetting the job and post the 'From previous run...' information that adds to the log, if any.
Posted: Wed Oct 14, 2009 10:40 am
by MURALI123
Hi,
Again i ran the job after reseting the job which shows the same warning.
chulett wrote:No, as that just means the job blew up. Got any more details? Also try Resetting the job and post the 'From previous run...' information that adds to the log, if any. ...
Posted: Wed Oct 14, 2009 10:48 am
by chulett
Didn't ask you to run the job again, just Reset it and see if the log entry I mentioned gets added to the log.
Posted: Wed Oct 14, 2009 10:57 am
by MURALI123
Ya i reset the job again run the job it shows the below warning:
Abnormal termination of stage JobName.TRFNeedProcessing1 detected
Here TRFNeedprocessing1 Is Transformer stage Name
Thanks,
Malli
chulett wrote:Didn't ask you to run the job again, just Reset it and see if the log entry I mentioned gets added to the log. ...
Posted: Wed Oct 14, 2009 12:41 pm
by chulett
[sigh] So... after resetting, you do not have a log entry that says "From previous run..."?
Abnormal termination.
Posted: Thu Oct 15, 2009 5:57 am
by vikibemech
yes chulet, You are right. We are not ableto rest the job. When we are trying to do so, job is runnign and getting abort. Even I am facing this issue from yesterday. Please advice.
Posted: Thu Oct 15, 2009 7:35 am
by chulett
Not sure what you mean... you can't
reset a job
after it aborts? Why not, what happens when you try?
Re: Abnormal termination of stage Jobname.transfermerstahena
Posted: Thu Oct 15, 2009 8:38 am
by vivekgadwal
MURALI123 wrote:Hi,
Anybody suggest me how can we slove the below error :
Abnormal termination of stage Jobname.transfermerstahename detected
Murali,
After any such errors happen, if you simply re-set the job, not run it again, you might get a log of what that error is. If you are having any such error log being documented by the tool, please go ahead and post it so that we can provide an effective solution. If there is no such log generated after re-setting, then it means that some external systems (like Database) is not liking some parameters being passed.
This example is from my experience. A few months ago, I developed a set of jobs that were vigorously tested in Dev and Test environments. One of the jobs was very simple, it was unloading some data into a flat file from an Oracle table. I have given the Transaction size as '10000' and, believe me, there were no issues in Dev and Test. But, as soon as this was moved to Production, the code abended saying this "ABNORMAL TERMINATION OF TRANSFORMER STAGE" error.
We struggled to find out what was causing that error and as part of the testing, I reduced that Transaction size value to 1024. It worked!!!
May be you can try this and see if you have any DB stages in the job and try playing with the parameters within it. It might help you eliminate the problem once and for all!