Abnormal termination of stage %s
Moderators: chulett, rschirm, roy
Abnormal termination of stage %s
When I run a job it Aborts with the following warning
xGDW00MPRMatBillCost..AgGDWStandMatUsgVar: %s
Abnormal termination of stage xGDW00MPRMatBillCost..XFmGDWValidateMatlPlant detected
-------------------------------------------------------------------------------------------------------------------------------------------------------
When I reset the job it says
From previous run
DataStage Job 3447 Phantom 24801
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.1982241586.DT.1325968284.TRANS1 at address 20
-------------------------------------------------------------------------------------------------------------------------------------------------------
My diskspace is about 83% full.
I have already rebooted my DataStage server once
What does the message "Abnormal Termination" translates to in simple english ?
The Directory listing of RT_BP3447 is
tetd40:/export/interface/etldata/CMIS/project/RT_BP3447[47]$ ls -otr
total 80
-rw-rw-r-- 1 v920069 5919 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS4
-rw-rw-r-- 1 v920069 5699 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS2
-rw-rw-r-- 1 v920069 5999 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS5
-rw-rw-r-- 1 v920069 5603 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS3
-rw-rw-r-- 1 v920069 15365 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS1
Does address 20 means line 20 of file "JOB.1982241586.DT.1325968284.TRANS1" ?
I have also made sure that I am not doing any calculation with null values.
Thanks in advance
Ejaz
xGDW00MPRMatBillCost..AgGDWStandMatUsgVar: %s
Abnormal termination of stage xGDW00MPRMatBillCost..XFmGDWValidateMatlPlant detected
-------------------------------------------------------------------------------------------------------------------------------------------------------
When I reset the job it says
From previous run
DataStage Job 3447 Phantom 24801
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.1982241586.DT.1325968284.TRANS1 at address 20
-------------------------------------------------------------------------------------------------------------------------------------------------------
My diskspace is about 83% full.
I have already rebooted my DataStage server once
What does the message "Abnormal Termination" translates to in simple english ?
The Directory listing of RT_BP3447 is
tetd40:/export/interface/etldata/CMIS/project/RT_BP3447[47]$ ls -otr
total 80
-rw-rw-r-- 1 v920069 5919 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS4
-rw-rw-r-- 1 v920069 5699 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS2
-rw-rw-r-- 1 v920069 5999 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS5
-rw-rw-r-- 1 v920069 5603 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS3
-rw-rw-r-- 1 v920069 15365 Apr 19 19:15 JOB.1982241586.DT.1325968284.TRANS1
Does address 20 means line 20 of file "JOB.1982241586.DT.1325968284.TRANS1" ?
I have also made sure that I am not doing any calculation with null values.
Thanks in advance
Ejaz
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, the address is actually the offset in the compiled code.
You can view this compiled code in an "assembler" format using The associated source statement should be nearby in the output.
You can view this compiled code in an "assembler" format using
Code: Select all
VLIST RT_BP3447 JOB.1982241586.DT.1325968284.TRANS1
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 ejazsalim and to all how r in the sink .
This problem i have faced last time,you must be doing aggregation or sorting with the plug in,
one of the alternative method is use cosort -sortcl .
its a problem of temp space only which it uses during aggregation or sorting of data so this temp space is to be increased for the completion of activity.
i hope this will work.
Regards
Hemant
This problem i have faced last time,you must be doing aggregation or sorting with the plug in,
one of the alternative method is use cosort -sortcl .
its a problem of temp space only which it uses during aggregation or sorting of data so this temp space is to be increased for the completion of activity.
i hope this will work.
Regards
Hemant
ejazsalim wrote:That worked great Ray. Thanks
I used the VLIST command on the DataStage Administrator Command Output Window is there any way to spool the output to a file or cut and paste.
That's what I assumed to Hemant but I was wrong with my past experiences I was thinking this to be a diskspace/memory issue but what it turned out to be was that one of the derivation was turned to not null while the value going in was a NULL changing that fixed my problem and thanks to Ray for the VLIST due to which I could pinpoint to the particular column that was giving me this problem.
I wish they had more meaningfull messages![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
I wish they had more meaningfull messages
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
hi! ejazsalim
That means that for two different problem yu can get same message cause "Abnormal Termination" i felt use for space related problem and now yu are saying something related "Null"value,this is also a very generic problem we face .thanxs yu clear it up .
-hemant
That means that for two different problem yu can get same message cause "Abnormal Termination" i felt use for space related problem and now yu are saying something related "Null"value,this is also a very generic problem we face .thanxs yu clear it up .
-hemant
ejazsalim wrote:That's what I assumed to Hemant but I was wrong with my past experiences I was thinking this to be a diskspace/memory issue but what it turned out to be was that one of the derivation was turned to not null while the value going in was a NULL changing that fixed my problem and thanks to Ray for the VLIST due to which I could pinpoint to the particular column that was giving me this problem.
I wish they had more meaningfull messages
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is what Ray was talking about
viewtopic.php?t=87389
Thanks once again Ray
viewtopic.php?t=87389
Thanks once again Ray
hemant wrote:Hi!Ray
i didn't get - how can we see the "See new thread on capturing output of "UniVerse" commands".can yu be elaborate explicitly .
Thanks and Regards
Hemant
ray.wurlod wrote:See new thread on capturing output of "UniVerse" commands.