Stored Procedure Stage Error

reddy82 · Post by **reddy82** » Thu Nov 11, 2010 3:26 am

I am using the Stored procedure stage ,while running the stage we are getting so many errors

below are error's

Warning : Could not load dsstpora.so
Fatal : Error occurred in call to ORPHCallActivePluginInitialize().

your help is much appreciated

Thanks
Sridhar

ArndW · Post by **ArndW** » Thu Nov 11, 2010 3:32 am

Analysis for this would be:

1. use UNIX "find" to locate the directory where "dsstpora.so" is located.
2. Make sure that this directory is in your PATH or LIBPATH environment variable (depends upon whic flavor of UNIX you are running)

reddy82 · Post by **reddy82** » Thu Nov 11, 2010 4:27 am

The File is located on the correct path only

ray.wurlod · Post by **ray.wurlod** » Thu Nov 11, 2010 5:01 am

What are the permissions on dsstpora.so ? Are all the Oracle environment variables correctly set for the user ID under which jobs run ?

ArndW · Post by **ArndW** » Thu Nov 11, 2010 6:03 am

The first entries in your job log will contain, among other things, the DataStage job's ENVironment settings. The odds are in favor of finding that the path to that directory in not set. It might be set for your login, but DataStage uses the settings as defined in the "dsenv" file.

reddy82 · Post by **reddy82** » Fri Nov 12, 2010 12:30 am

The environment varaiables are set in the correct path only.The file dsstpora.so is present in the PXhome/lib.still getting the error

Sreenivasulu · Post by **Sreenivasulu** » Fri Nov 12, 2010 2:36 am

Can you post the relevant part of env file and the log file ?

Regard

Sreeni