Hi all,
When we ran a DataStage job, it aborted and encountered the following error messages when the job has extracted and loaded all the records:
-----------------------------------------------------------------------------
Attempting to Cleanup after ABORT raised in stage BGH2InvoiceExtraction1TestWilliam9..Bill_Invoice_Detail
------------------------------------------------------------------------------------------------------------------
DataStage Job 333 Phantom 21896
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 BGH2InvoiceExtraction1TestWilliam9..Bill_Invoice_Detail
DataStage Phantom Aborting with @ABORT.CODE = 3
--------------------------------------------------------------------------------------
We would like to know what could be the possible cause to the above error messages and is there any resolution to the problem?
Our job is read from text file(main stream), reference to 3 oracle tables in a transformer and load the data into a text file.
Thank you.
ttk9694
Job aborted after finish loading all records.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Does your job design include an after-stage or after-job subroutine?
If not, then you have incompatible versions of the internal DataStage routines DSP.Open and DSP.Close installed - check with your support provider.
If not, then you have incompatible versions of the internal DataStage routines DSP.Open and DSP.Close installed - check with your support provider.
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 all,
After the reset, we got the following messages:
From previous run
DataStage Job 333 Phantom 3100
jobnotify: Unknown error
DataStage Phantom Finished.
[3110] DSD.StageRun BGH2InvoiceExtraction1TestWilliam9. BGH2InvoiceExtraction1TestWilliam9.Transformation1 6 0/0/1 - core dumped.
From previous run
DataStage Job 333 Phantom 3110
Abnormal termination of DataStage.
Fault type is 10. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.StageRun at address 1
We don't have before or after subroutine for this job.
Regard
ttk9694
After the reset, we got the following messages:
From previous run
DataStage Job 333 Phantom 3100
jobnotify: Unknown error
DataStage Phantom Finished.
[3110] DSD.StageRun BGH2InvoiceExtraction1TestWilliam9. BGH2InvoiceExtraction1TestWilliam9.Transformation1 6 0/0/1 - core dumped.
From previous run
DataStage Job 333 Phantom 3110
Abnormal termination of DataStage.
Fault type is 10. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.StageRun at address 1
We don't have before or after subroutine for this job.
Regard
ttk9694
Some of the jobs also encountered the same error. I'm running on DS version 7.5A. How can we check the internal version of the DS.Open & DS.Close routine.
Could this incompatible of internal DS routines caused by inproper DS installation. We are considering re-installation of DS but it is the last option that we will do.
Could this incompatible of internal DS routines caused by inproper DS installation. We are considering re-installation of DS but it is the last option that we will do.
We have re-installed the DS Server with the latest version 7.5.2 but we still encountered the same error. Finally, we able to get rid of this error when using oracle client 9.2.0.5 or oracle client 10g instead of oracle client 9.2.0.6 on HPUX 11.11 platform. All this while, only job with reference/lookup to oracle database will encountered this problem. I think it is an incompatibility issue on the following combination: DS 7.5.2 or 7.5A + HPUX 11.11 + Oracle Client 9.2.0.6.