DSXchange

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

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)

The File is located on the correct path only

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

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.

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

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

Regard

Sreeni