abnormal termination of stored procedure stage

sabarinirmal · Post by **sabarinirmal** » 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.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 26, 2013 4:47 pm

How do you know that the problem is in the Stored Procedure stage? Please post any error message that verifies this.

sabarinirmal · Post by **sabarinirmal** » Tue Aug 27, 2013 2:42 am

ray.wurlod wrote:How do you know that the problem is in the Stored Procedure stage? Please post any error message that verifies this.

i inferred from the following log entry that, only during stored procedure call, the STP stage is terminating abnormally.

"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

ray.wurlod · Post by **ray.wurlod** » Tue Aug 27, 2013 2:56 am

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?

prasson_ibm · Post by **prasson_ibm** » Tue Aug 27, 2013 3:41 am

Hi,
Do you have proper privilage to run the SP in QA.

sabarinirmal · Post by **sabarinirmal** » Tue Aug 27, 2013 6:37 am

we are able to successfully execute the stored procedure at the backend in the database

sabarinirmal · Post by **sabarinirmal** » Thu Aug 29, 2013 12:31 am

Can the experts please assist me with this issue. Thanks

sabarinirmal · Post by **sabarinirmal** » Thu Aug 29, 2013 5:00 am

it seems that the job exe, we are executing in QA, got corrupted. we reimported the exe, and the job ran successfully. closing this issue. Thanks