job aborting in merging of two files
Moderators: chulett, rschirm, roy
job aborting in merging of two files
Hi Everyone,
i am merging two files (inner join) , with 2 key columns in both files.
i am not doing any tranformation in transformer.
i am just loading to sequential file .
when i execute the job it is giving following error.
Abnormal termination of stage nsar_merge..Transformer_1 detected
i could not solve this one. any suggestions.
Thanks
i am merging two files (inner join) , with 2 key columns in both files.
i am not doing any tranformation in transformer.
i am just loading to sequential file .
when i execute the job it is giving following error.
Abnormal termination of stage nsar_merge..Transformer_1 detected
i could not solve this one. any suggestions.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What did searching on this forum for "abnormal termination" reveal to you about how and where to look for diagnostic information and/or likely causes of this particular message?
Is it correct to discern from the error message that the job name is nsar_merge and that there is a Transformer stage called Transformer_1 in the job design? Can you post your job design, which I infer is something like
Does the problem occur in row #1 or later? Can you use the Debugger to step through the job?
Is it correct to discern from the error message that the job name is nsar_merge and that there is a Transformer stage called Transformer_1 in the job design? Can you post your job design, which I infer is something like
Code: Select all
Merge stage ---> Transformer stage ---> Sequential File stage
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: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi ,
thanks for ur reply
i am doing in the same way as you mentioned and the problem is occuring in first row (#1).
0 records are going to transformer.
this is the only warning i am getting .
'Abnormal termination of stage nsar_merge..Transformer_1 detected '
thanks .
thanks for ur reply
i am doing in the same way as you mentioned and the problem is occuring in first row (#1).
0 records are going to transformer.
this is the only warning i am getting .
'Abnormal termination of stage nsar_merge..Transformer_1 detected '
thanks .
ray.wurlod wrote:What did searching on this forum for "abnormal termination" reveal to you about how and where to look for diagnostic information and/or likely causes of this particular message?
Is it correct to discern from the error message that the job name is nsar_merge and that there is a Transformer stage called Transformer_1 in the job design? Can you post your job design, which I infer is something likeDoes the problem occur in row #1 or later? Can you use the Debugger to step through the job?Code: Select all
Merge stage ---> Transformer stage ---> Sequential File stage
Hi,
i did not get any additional information.
if i reset and again run it , i got same message
Abnormal termination of stage nsar_merge..Merge_transformer detected
i did not get any additional information.
if i reset and again run it , i got same message
Abnormal termination of stage nsar_merge..Merge_transformer detected
chulett wrote:But what about his second question? Did you reset (not recompile) the job and get any additional messages in the log labelled 'From previous run...'? More clues there if it shows up.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The error may actually raise on the Merge stage. However, being a passive stage, it has not reported the error but its caller, the active (Transformer) stage, has reported it.
Please post exact details of the join you have attempted including the definitions of key columns in both source files.
Do these files have column headings in the first line? Do these files have null or empty values in any of the key columns?
Please post exact details of the join you have attempted including the definitions of key columns in both source files.
Do these files have column headings in the first line? Do these files have null or empty values in any of the key columns?
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.
Hi ,
Thanks for reply.
i am merging(pure inner join) two files. both files are in same format. the key columns both of them are fund_name, cik .
there are no nulls in the key column (in this case i am dealing with test data first file with 15 records and second file with 24 records ). i need to merge based on key columns(if it matches)
both fiels have column headings
these files don't have any null or empty spaces in key columns.
Thanks for reply.
i am merging(pure inner join) two files. both files are in same format. the key columns both of them are fund_name, cik .
there are no nulls in the key column (in this case i am dealing with test data first file with 15 records and second file with 24 records ). i need to merge based on key columns(if it matches)
both fiels have column headings
these files don't have any null or empty spaces in key columns.
Thanksray.wurlod wrote:The error may actually raise on the Merge stage. However, being a passive stage, it has not reported the error but its caller, the active (Transformer) stage, has reported it.
Please post exact details of the join you have attempted including the definitions of key columns in both source files.
Do these files have column headings in the first line? Do these files have null or empty values in any of the key columns?
Hi,
Most likely your problem will be resolved if you rebuild (not copy paste) your mege stage a new (I've been this way before
).
I've had my share of this behaviour.
Be aware performing merges of huge files might proove to be:
1. slow
2. fail if you don't have enough resorces.
IHTH,
Most likely your problem will be resolved if you rebuild (not copy paste) your mege stage a new (I've been this way before
![Sad :(](./images/smilies/icon_sad.gif)
I've had my share of this behaviour.
Be aware performing merges of huge files might proove to be:
1. slow
2. fail if you don't have enough resorces.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Hi ,
Thanks for reply
i did redesign of job (rebuliding merge stage) but same problem.
i am designing like this
merger- ----> transformer- - ----- -> sequentail file.
i am not doing any transformatios in tarnformer ( just merging in the first stage).
even after redesigning (reduilding merge stage) i am getting same error.
Thanks for reply
i did redesign of job (rebuliding merge stage) but same problem.
i am designing like this
merger- ----> transformer- - ----- -> sequentail file.
i am not doing any transformatios in tarnformer ( just merging in the first stage).
even after redesigning (reduilding merge stage) i am getting same error.
Code: Select all
Abnormal termination of stage Merge_Testing..Transformer_1 detected
roy wrote:Hi,
Most likely your problem will be resolved if you rebuild (not copy paste) your mege stage a new (I've been this way before).
I've had my share of this behaviour.
Be aware performing merges of huge files might proove to be:
1. slow
2. fail if you don't have enough resorces.
IHTH,
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom