Abnormal termination of stage tfmr detected
Moderators: chulett, rschirm, roy
Abnormal termination of stage tfmr detected
We are facing an issue lately for a particular job which says 'Abnormal termination of stage tfmr detected' and I don't see any vital info from the previous run messages. All it says is that, which stage is using what NLS map.
E.g:
<job_name>.<stage_name>: Using project default NLS map ISO8859-1
<job_name>.<stage_name>: Using project default NLS map ISO8859-1
<job_name>.<stage_name>: Using project default NLS map ISO8859-1
I have searched and have checked that there are many posts on this matter here and I tried few things too like setting of DS_NO_PROCESS_METADATA=1. But there is not resolution for this. any help on this will be appreciated.
E.g:
<job_name>.<stage_name>: Using project default NLS map ISO8859-1
<job_name>.<stage_name>: Using project default NLS map ISO8859-1
<job_name>.<stage_name>: Using project default NLS map ISO8859-1
I have searched and have checked that there are many posts on this matter here and I tried few things too like setting of DS_NO_PROCESS_METADATA=1. But there is not resolution for this. any help on this will be appreciated.
It looks like you will have to debug this the hard way. I would remove all columns that do a 1-1 mapping, then recompile and text. Chances are very high the error will still be there. Then start removing single columns, starting with the most complicated derivations first until the error goes away and then examine (or post to this thread) the offending derivation.
Do you think it is something related to a derivation? I doubt so. The reason is that this transformer's output is being fed into a Sort stage which eventually goes to another transformer as the primary link while we have an ODBC stage for connecting to Oracle that is used as reference for the 2nd transformer.
I replaced all the stages after the 1st transformer with a sequential file and executed the job. It ran successfully.
I replaced all the stages after the 1st transformer with a sequential file and executed the job. It ran successfully.
Do you think it is something related to a derivation? I doubt so. The reason is that this transformer's output is being fed into a Sort stage which eventually goes to another transformer as the primary link while we have an ODBC stage for connecting to Oracle that is used as reference for the 2nd transformer.
I replaced all the stages after the 1st transformer with a sequential file and executed the job. It ran successfully.
I replaced all the stages after the 1st transformer with a sequential file and executed the job. It ran successfully.
-
- Participant
- Posts: 21
- Joined: Mon Mar 16, 2009 3:59 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please elucidate how this is the same issue - how a problem whose symptom is NLS map related can be fixed by tweaking array size.
I do not know of any way that this is possible, so I seek your enlightened guidance.
I do not know of any way that this is possible, so I seek your enlightened guidance.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 21
- Joined: Mon Mar 16, 2009 3:59 am
It is possible if the target stage action is set to update then insert and the array size is greater than 1, which it should not be in this scenario to begin with, it will cause an abnormal termination error. Nobody on this topic has provided enough detail to say if that was truly the cause or not.
If it is the cause, then was the target stage actually named "tfmr?" Or was the error reportedly coming from a Transformer stage, and actually generated by the target database stage?
If it is the cause, then was the target stage actually named "tfmr?" Or was the error reportedly coming from a Transformer stage, and actually generated by the target database stage?
Choose a job you love, and you will never have to work a day in your life. - Confucius