abnormal termination of stored procedure stage
Posted: Mon Aug 26, 2013 10:31 am
abnormal termination of STP stage in happening in our server job. Job design is a source sequential file, which has the values to be passed as parameter inputs to the stored procedure, being called in the STP stage. the sequential file is directly linked to the STP stage.
Following is the extended log entry after re-setting the job:
From previous run
DataStage Job 274 Phantom 28505
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.ActiveRun at address 7a.
This process worked perfectly in our DEV environment, but is failing in our QA setup, both the environments being configured identically.
I did a search in this forum, but couldnt tag this issue to any post. Hence creating a new post here. Kindly advise.
Following is the extended log entry after re-setting the job:
From previous run
DataStage Job 274 Phantom 28505
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.ActiveRun at address 7a.
This process worked perfectly in our DEV environment, but is failing in our QA setup, both the environments being configured identically.
I did a search in this forum, but couldnt tag this issue to any post. Hence creating a new post here. Kindly advise.