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.
abnormal termination of stored procedure stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 25
- Joined: Mon Dec 29, 2008 12:13 am
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 25
- Joined: Mon Dec 29, 2008 12:13 am
- Location: Chennai
i inferred from the following log entry that, only during stored procedure call, the STP stage is terminating abnormally.ray.wurlod wrote:How do you know that the problem is in the Stored Procedure stage? Please post any error message that verifies this.
"Abnormal termination of stage JobOraCampExtract..PR_DEALER_APPLICATION_2 detected"
Furthur , there are only two stages in the job, source being sequential stage linked to the target STP stage.
Please let me know, if am wrong here. Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's the proof I requested. Fault type 11 (in UNIX this is signal #11, or SIGSEGV, also known as access violation) which suggests that something in the stored procedure, or in the process of invoking it, has attempted to access an area of memory not accessible to the process. It's really difficult for us to determine much more than that. For example an attempt to push a 12 digit number into a 10 digit column (e.g. integer type) might raise this particular signal. But there are very many possibilities.
Can you execute the stored procedure successfully outside of DataStage?
Can you execute the stored procedure successfully outside of DataStage?
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.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
Do you have proper privilage to run the SP in QA.
Do you have proper privilage to run the SP in QA.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 25
- Joined: Mon Dec 29, 2008 12:13 am
- Location: Chennai
-
- Premium Member
- Posts: 25
- Joined: Mon Dec 29, 2008 12:13 am
- Location: Chennai
-
- Premium Member
- Posts: 25
- Joined: Mon Dec 29, 2008 12:13 am
- Location: Chennai