I have job defined in this way
ORAOCI9 Stage
|
File Stage -> Transformer -> file
where ORAOCI9 is reference link. This job is processing around 2 million records. It runs upto the last record and then it aborts. In the abort message I only get "Attempting to Cleanup after ABORT raised in stage JOBNAME..ORAOCI9"
and the next message states
DataStage Job 217 Phantom 18033
Program "DSD.StageRun": Line 617, COMMON size mismatch in subroutine "DSP.Close".
Program "DSD.StageRun": Line 617, Unable to load file "DSP.Close".
Program "DSD.StageRun": Line 617, Unable to load subroutine.
Attempting to Cleanup after ABORT raised in stage JOBNAME..ORAOCI9
DataStage Phantom Aborting with @ABORT.CODE = 3
Any thuoghts on how to avoid aborts. This job completes it processing and then aborts. I am running Oracle 9i as back end database.
As always, I really appreciate all the help from experts on this forum.
Dinesh
Job aborts becuase of Oracle reference
Moderators: chulett, rschirm, roy
Hi,
what do you have implemented inside? anything special? (do you use COMMON? - the error message implies yes)
we'll need more info !
if nothing special usually a quick rebuild solves things like this, which are rare to my knowladge.
IHTH,
what do you have implemented inside? anything special? (do you use COMMON? - the error message implies yes)
we'll need more info !
if nothing special usually a quick rebuild solves things like this, which are rare to my knowladge.
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
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