Error in Stored procedure stage
Moderators: chulett, rschirm, roy
Hi ArndW
The Unix Server that i am using is HP-UX
Although $LD_LIBRARY_PATH is having $DSHOME/lib in both dev and prod files, i am finding another variable $SHLIB_PATH in my dev file.
SHLIB_PATH = $LD_LIBRARY_PATH
But this variable is missing in production file.
I heard that HP-UX needs SHLIB_PATH in addition to LD_LIBRARY_PATH. Is this the cause of problem?
Thank you,
Ajith
The Unix Server that i am using is HP-UX
Although $LD_LIBRARY_PATH is having $DSHOME/lib in both dev and prod files, i am finding another variable $SHLIB_PATH in my dev file.
SHLIB_PATH = $LD_LIBRARY_PATH
But this variable is missing in production file.
I heard that HP-UX needs SHLIB_PATH in addition to LD_LIBRARY_PATH. Is this the cause of problem?
Thank you,
Ajith
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
![Idea :idea:](./images/smilies/icon_idea.gif)
Code: Select all
SHLIB_PATH=$LD_LIBRARY_PATH
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.
-
- Participant
- Posts: 1
- Joined: Tue Nov 28, 2006 1:55 pm
- Location: St Louis, MO
Could not load dsstpora.so
I am trying to run an Oracle procedure in a Stored Procedure stage. I am getting the error. "Could not load dsstpora.so" It is running on AIX, DataStage version 7.5.1. Server version 7.5.2.
I have tried the things mentioned in the two posts. It is still getting the same message. Can anyone help me?
Here is my environment settings.
Environment variable settings:
_=/bin/nohup
LANG=C
LOGIN=dsadm
APT_ORCHHOME=/DSadm/Ascential/DataStage/PXEngine
PATH=/bin:/etc:/oracle/product/v10201/bin:/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java/jre/bin:/usr/java/bin:/usr/vac/bin:/oracle/product/v10201/bin:/oracle/product/v10201/bin:/oracle/product/v10201/bin:/DSadm/Ascential/DataStage/branded_odbc/bin:/usr:/usr/vacpp:/usr/vacpp/bin
LC__FASTMSG=true
WINDOWID=4194317
DSSAPHOME=/DSadm/Ascential/DataStage
CPIC_MAX_CONV=1000
LOGNAME=i99260
MAIL=/usr/spool/mail/dsadm
LOCPATH=/usr/lib/nls/loc
LIB_PATH=/oracle/product/v10201/lib32
USER=dsadm
AUTHSTATE=compat
SAPINST_JRE_HOME=/usr/java/jre
TNS_ADMIN=/oracle/product/v10201/network/admin
DISPLAY=localhost:10.0
SHELL=/usr/bin/ksh
DSHOME=/DSadm/Ascential/DataStage/DSEngine
ODMDIR=/etc/objrepos
JAVA_HOME=/usr/java
ODBCINI=/DSadm/Ascential/DataStage/DSEngine/.odbc.ini
HOME=/home/dsadm
SSH_CLIENT=192.227.75.132 1742 22
SSH_CONNECTION=192.227.75.132 1742 192.227.110.159 22
TERM=
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/oracle/product/v10201
PWD=/DSadm/Ascential/DataStage/DSEngine
TZ=CST6CDT
A__z=! LOGNAME
UDTHOME=/DSadm/Ascential/DataStage/ud41
UDTBIN=/DSadm/Ascential/DataStage/ud41/bin
DS_USERNO=-8298
WHO=BruceTest1
BELL=^G
FLAVOR=-1
LIBPATH=/DSadm/Ascential/DataStage/branded_odbc/lib:/DSadm/Ascential/DataStage/DSEngine/lib:/DSadm/Ascential/DataStage/DSEngine/uvdlls:/DSadm/Ascential/DataStage/DSEngine/java/jre/bin/classic:/DSadm/Ascential/DataStage/DSEngine/java/jre/bin:/oracle/product/v10201/lib32::/usr/lib
APT_ORACLE_NO_OPS=false
LD_LIBRARY_PATH=/DSadm/Ascential/DataStage/DSEngine/lib
SHLIB_PATH=/DSadm/Ascential/DataStage/DSEngine/lib
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
Thanks,
I have tried the things mentioned in the two posts. It is still getting the same message. Can anyone help me?
Here is my environment settings.
Environment variable settings:
_=/bin/nohup
LANG=C
LOGIN=dsadm
APT_ORCHHOME=/DSadm/Ascential/DataStage/PXEngine
PATH=/bin:/etc:/oracle/product/v10201/bin:/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java/jre/bin:/usr/java/bin:/usr/vac/bin:/oracle/product/v10201/bin:/oracle/product/v10201/bin:/oracle/product/v10201/bin:/DSadm/Ascential/DataStage/branded_odbc/bin:/usr:/usr/vacpp:/usr/vacpp/bin
LC__FASTMSG=true
WINDOWID=4194317
DSSAPHOME=/DSadm/Ascential/DataStage
CPIC_MAX_CONV=1000
LOGNAME=i99260
MAIL=/usr/spool/mail/dsadm
LOCPATH=/usr/lib/nls/loc
LIB_PATH=/oracle/product/v10201/lib32
USER=dsadm
AUTHSTATE=compat
SAPINST_JRE_HOME=/usr/java/jre
TNS_ADMIN=/oracle/product/v10201/network/admin
DISPLAY=localhost:10.0
SHELL=/usr/bin/ksh
DSHOME=/DSadm/Ascential/DataStage/DSEngine
ODMDIR=/etc/objrepos
JAVA_HOME=/usr/java
ODBCINI=/DSadm/Ascential/DataStage/DSEngine/.odbc.ini
HOME=/home/dsadm
SSH_CLIENT=192.227.75.132 1742 22
SSH_CONNECTION=192.227.75.132 1742 192.227.110.159 22
TERM=
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/oracle/product/v10201
PWD=/DSadm/Ascential/DataStage/DSEngine
TZ=CST6CDT
A__z=! LOGNAME
UDTHOME=/DSadm/Ascential/DataStage/ud41
UDTBIN=/DSadm/Ascential/DataStage/ud41/bin
DS_USERNO=-8298
WHO=BruceTest1
BELL=^G
FLAVOR=-1
LIBPATH=/DSadm/Ascential/DataStage/branded_odbc/lib:/DSadm/Ascential/DataStage/DSEngine/lib:/DSadm/Ascential/DataStage/DSEngine/uvdlls:/DSadm/Ascential/DataStage/DSEngine/java/jre/bin/classic:/DSadm/Ascential/DataStage/DSEngine/java/jre/bin:/oracle/product/v10201/lib32::/usr/lib
APT_ORACLE_NO_OPS=false
LD_LIBRARY_PATH=/DSadm/Ascential/DataStage/DSEngine/lib
SHLIB_PATH=/DSadm/Ascential/DataStage/DSEngine/lib
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
Thanks,
Sue
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You shared library paths are inconsistently named (LIB_PATH vs LIBPATH) and do not seem to have the usual range of entries. When adding entries, you need to preserve the prior entries. For example
Code: Select all
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/DSadm/Ascential/DataStage/DSEngine/lib
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.