Abnormal termination of stage %s

ejazsalim · Post by **ejazsalim** » Mon Apr 19, 2004 2:30 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Apr 19, 2004 4:35 pm

No, the address is actually the offset in the compiled code.

You can view this compiled code in an "assembler" format using

Code: Select all

VLIST RT_BP3447 JOB.1982241586.DT.1325968284.TRANS1

The associated source statement should be nearby in the output.

ejazsalim · Post by **ejazsalim** » Tue Apr 20, 2004 6:48 am

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.

hemant · Post by **hemant** » Tue Apr 20, 2004 8:44 am

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

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.

ejazsalim · Post by **ejazsalim** » Tue Apr 20, 2004 8:57 am

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

hemant · Post by **hemant** » Tue Apr 20, 2004 11:44 pm

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

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

ray.wurlod · Post by **ray.wurlod** » Wed Apr 21, 2004 1:07 am

See new thread on capturing output of "UniVerse" commands.

hemant · Post by **hemant** » Wed Apr 21, 2004 1:42 am

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.

ejazsalim · Post by **ejazsalim** » Wed Apr 21, 2004 9:19 am

This is what Ray was talking about
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.