Hi,
What are two type of input sources you have?
What type of targe(s) you have?
What are you doing in tranform state.
Ketfos
Abnormal termination of stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
After the job aborts, reset it. There may then be an entry in your log with the title "From previous run..." containing additional information.
There are many possible causes of abnormal termination, as a search on this Forum will reveal. Usually it's because you've tried to do something illegal, like use NULL as the second argument of a conversion function, or force too much data into a space where they won't fit, or attempt to use a variable as a file variable when the file is not open.
Without knowing exactly what your stage is doing it's not possible to provide any more accurate diagnosis. You could search the Forum looking for ideas. You could post your design here in the quest for additional help. We would need:
Finally, you might like to run your job and select stage tracing to collect the properties and subroutine calls associated with your Transformer stage. This might also indicate where the problem occurs. Is it in row 1, a known row (if so, what's different about this row?) or an arbitrary row?
There are many possible causes of abnormal termination, as a search on this Forum will reveal. Usually it's because you've tried to do something illegal, like use NULL as the second argument of a conversion function, or force too much data into a space where they won't fit, or attempt to use a variable as a file variable when the file is not open.
Without knowing exactly what your stage is doing it's not possible to provide any more accurate diagnosis. You could search the Forum looking for ideas. You could post your design here in the quest for additional help. We would need:
- reference key expression
constraint expressions
stage variable derivation expressions (if any)
output column derivation expressions
Finally, you might like to run your job and select stage tracing to collect the properties and subroutine calls associated with your Transformer stage. This might also indicate where the problem occurs. Is it in row 1, a known row (if so, what's different about this row?) or an arbitrary row?
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.