error calling sybase stored proc from stored procedure stage

nsm · Post by **nsm** » Wed Nov 19, 2008 10:20 am

Hi ,

I tried calling a Sybase stored procedure through a stored procedure stage and below are the errors I get:

Stored_Procedure_3,0: Error: Could not load dsstpsyb.so
Stored_Procedure_3,0: Error occurred in call to ORPHCallActivePluginInitialize().

Please suggest on what causing this..My guess is "dsstpsyb.so" is a driver specific to Sybase that's missing, as when others run a db2 stored procedure through stored procedure stage its working fine.

thanks.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2008 1:04 pm

Any time you have problems with a *.so file suspect your shared library search list (the LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH environment variable).

nsm · Post by **nsm** » Wed Nov 19, 2008 3:35 pm

when tried connecting to Sybase as a source or lkup(Via ODBC Connector) I get no issues. Is it still to do with Env variables?

nsm.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2008 4:59 pm

Probably. Do you use the same operating system user ID and password as the one that the DataStage process uses? Maybe your environment variable setting (from .profile) is different to DataStage's (from dsenv).