Error While Logging to DataStage from Client machine

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
harshkohli
Participant
Posts: 31
Joined: Wed Feb 04, 2004 2:04 pm
Location: Canada

Error While Logging to DataStage from Client machine

Post by harshkohli »

Last week our server support team installed DataStage XE 7.5.1A on one of our test server, which is a Unix box. I am now trying to log on to DataStage from my client machine but getting the following error :

Error calling subroutine: DSR_PROJECT (Action=17); check DataStage is set up correctly in project test
(Subroutine failed to complete successfully (30107))

I searched the forum and found few posts with same issue. I did the following before posting this post :

1. Tried logging on DataStage Designer from client machine using dsadm ID and I was successful.

2. Ran the DS.REINDEX ALL command from DS Administrator

3. Tried running the following commands :
cd `cat /.dshome`
. ./dsenv
bin/dssh
LOGTO {YourProjectName}
COUNT VOC
QUIT


The command . ./dsenv ran without any issue but the command bin/dssh
gave the following error :

$ bin/dssh
/usr/lib/dld.sl: Can't open shared library: /export/hpdev01sand0/builds/DSServer.src/server/release/uv/unix/lib/libgciudt6.sl
/usr/lib/dld.sl: No such file or directory
Abort


Please let me know what is wrong with our setup and why I cannot login to DataStage Designer and how to fix this issue.


Thanks.
Harsh Kohli
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

Check if this POST helps.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
harshkohli
Participant
Posts: 31
Joined: Wed Feb 04, 2004 2:04 pm
Location: Canada

Post by harshkohli »

I_Server_Whale wrote:Check if this POST helps.
Thanks for the reply but the last reply from Craig in the post is truncated. I only got this :
SHLIB_PATH is correct for HP/UX, it's what we run here. You need to make a small correction to your settings as you seem to have the classic problem of pointing to the 64bit Oracle libraries rather t ...


The dsenv file on our box has the following :

# PLATFORM SPECIFIC SECTION

set +u

if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
then
DSHOME=`cat /.dshome`
export DSHOME
fi
#added oracle env here.
ORACLE_HOME=/opt/oracle_9.2.0; export ORACLE_HOME

if [ -z "$DSHOME" ]
then
DSHOME=/opt/products/Ascential/DataStage/DSEngine; export DSHOME
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=; export APT_ORCHHOME
fi

if [ -z "$UDTHOME" ]
then
UDTHOME=/opt/products/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/opt/products/Ascential/DataStage/ud41/bin; export UDTBIN
fi

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME


#LD_PRELOAD must be unset on HP-UX 11.00
if [ 1111 -le `uname -r | cut -f2 -d.``uname -r | cut -f3 -d.` ]
then

SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC2.0:$DSHOM
E/java/jre/lib/PA_RISC2.0/hotspot:/opt/oracle_9.2.0/lib32:/opt/oracle_9.2.0/lib/:$SHLIB_PATH
export SHLIB_PATH

LD_PRELOAD=$DSHOME/java/jre/lib/PA_RISC2.0/hotspot/libjvm.sl
export LD_PRELOAD
else
#added oracle lib path to end of this.

SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC:$DSHOME/j
ava/jre/lib/PA_RISC/hotspot:/opt/oracle_9.2.0/lib32:/opt/oracle_9.2.0/lib/:$SHLIB_PATH
export SHLIB_PATH
fi
fi


Please let me know what the problem is and how can I fix it.
Harsh Kohli
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

harshkohli wrote:Thanks for the reply but the last reply from Craig in the post is truncated.
That means you need to get 'Premium Membership'.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
harshkohli
Participant
Posts: 31
Joined: Wed Feb 04, 2004 2:04 pm
Location: Canada

Post by harshkohli »

I_Server_Whale wrote:
harshkohli wrote:Thanks for the reply but the last reply from Craig in the post is truncated.
That means you need to get 'Premium Membership'.

'Premium Membership' - I thought this is a free Forum.

Anyway, Can someone provide me the solution to fix this issue?
Harsh Kohli
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

harshkohli wrote:
'Premium Membership' - I thought this is a free Forum.

Anyway, Can someone provide me the solution to fix this issue?
Mostly it is. But some answers from Premium posters can only be viewed by Premium members. Its less then a 50 cents a day, as good as free.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

harshkohli wrote:
I_Server_Whale wrote:
harshkohli wrote:Thanks for the reply but the last reply from Craig in the post is truncated.
That means you need to get 'Premium Membership'.

'Premium Membership' - I thought this is a free Forum.

Anyway, Can someone provide me the solution to fix this issue?
Every older post of 'ours' from before the conversion to Premium membership was automatically marked as such during the conversion. Not much I can do about that issue as a whole, but I've unmarked the one in question as it's pretty basic stuff.

Let us know if that solves your problem.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply