Abnormal termination of stage Jobname.transfermerstahename d
Moderators: chulett, rschirm, roy
Abnormal termination of stage Jobname.transfermerstahename d
Hi,
Anybody suggest me how can we slove the below error :
Abnormal termination of stage Jobname.transfermerstahename detected
Anybody suggest me how can we slove the below error :
Abnormal termination of stage Jobname.transfermerstahename detected
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
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. ...
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Abnormal termination.
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.
Vignesh Kumar N
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: Abnormal termination of stage Jobname.transfermerstahena
Murali,MURALI123 wrote:Hi,
Anybody suggest me how can we slove the below error :
Abnormal termination of stage Jobname.transfermerstahename detected
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!
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted