Connection problem!

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
milind
Participant
Posts: 18
Joined: Mon Dec 15, 2003 12:28 am

Connection problem!

Post by milind »

Hi guys,

I am getting the following error when I try to connect from Datastage client to Datastage server on Unix.This was working fine previously.Havent even done any changes to any file.

Failed to connect to host: 172.19.1.72, project: UV
(The connection is broken (81002))

I am able to start and stop the dsrpc on the server.I also started this in debug mode.It gave me the following file after i had tried connecting from a client:

RPCPID=1000 - 01:00:41 - uvrpc_debugflag=9 (Debugging level)
RPCPID=1000 - 01:00:41 - In rpc_init()
RPCPID=1000 - 01:02:15 - Accepted socket is from (IP number) 0xffbe7580
RPCPID=1000 - 01:02:15 - In read packet
RPCPID=1000 - 01:02:15 - In read message
RPCPID=1000 - 01:02:15 - Read resp: read of header ok
RPCPID=1000 - 01:02:15 - message_length=13
VERSION NUMBER SEQNO
0x6c01 0x 4
MESSAGE LENGTH
0x 13
MESSAGE Key
0x 0
HIGH VERSION COMPRESSION ENCRYPTION
0x 2 0x 0 0x 0
NW RETURN CODE
0x 0
NUM ARGS PROC NAME LEN(PROC NAME)
0x 1 0()
START OF ARG ARRAY DATA
Element 0 Length type
0x 4 0x 2
ARG DATA
RPCPID=1000 - 01:02:15 - In unpack packet
RPCPID=1000 - 01:02:15 - length of arg 0 = 4
RPCPID=1000 - 01:02:15 - type of arg 0 = 2
RPCPID=1000 - 01:02:15 - char arg(0x 2f118)=dscs
RPCPID=1000 - 01:02:15 - looking for service dscs
RPCPID=1000 - 01:02:15 - Found service=dscs
RPCPID=1000 - 01:02:15 - Checking host: *
RPCPID=1000 - 01:02:15 - accept: forking and execing /opt/dsadm/Ascential/DataStage/DSEngine/bin/dsapi_server
RPCPID=1000 - 01:02:15 - In parent child PID=1007
ld.so.1: dscs: fatal: libUtilWSClient.so: open failed: No such file or directory
RPCPID=1000 - 01:02:15 - waited on child 1007
RPCPID=1000 - 01:02:26 - Accepted socket is from (IP number) 0xffbe7580
RPCPID=1000 - 01:02:26 - In read packet
RPCPID=1000 - 01:02:26 - In read message
RPCPID=1000 - 01:02:26 - Read resp: read of header ok
RPCPID=1000 - 01:02:26 - message_length=13

the dsapi_server and the libUtilWSClient is in place.

The netstat command gave the following output after several attempts to connect from a client:
DatastagePX.32785 DatastagePX.listener 32768 0 32768 0 ESTABLISHED
DatastagePX.listener DatastagePX.32785 32768 0 32768 0 ESTABLISHED
DatastagePX.32789 DatastagePX.32773 32768 0 32768 0 ESTABLISHED
DatastagePX.32773 DatastagePX.32789 32768 0 32768 0 ESTABLISHED
localhost.32792 localhost.32787 32768 0 32768 0 ESTABLISHED
localhost.32787 localhost.32792 32768 0 32768 0 ESTABLISHED
localhost.32795 localhost.32794 32768 0 32768 0 ESTABLISHED
localhost.32794 localhost.32795 32768 0 32768 0 ESTABLISHED
localhost.32798 localhost.32787 32768 0 32768 0 ESTABLISHED
localhost.32787 localhost.32798 32768 0 32768 0 ESTABLISHED
localhost.32801 localhost.32800 32768 0 32768 0 ESTABLISHED
localhost.32800 localhost.32801 32768 0 32768 0 ESTABLISHED
localhost.32804 localhost.32787 32768 0 32768 0 ESTABLISHED
localhost.32787 localhost.32804 32768 0 32768 0 ESTABLISHED
localhost.32807 localhost.32806 32768 0 32768 0 ESTABLISHED
localhost.32806 localhost.32807 32768 0 32768 0 ESTABLISHED
localhost.32810 localhost.32787 32768 0 32768 0 ESTABLISHED
localhost.32787 localhost.32810 32768 0 32768 0 ESTABLISHED
localhost.32813 localhost.32812 32768 0 32768 0 ESTABLISHED
localhost.32812 localhost.32813 32768 0 32768 0 ESTABLISHED
localhost.32816 localhost.32787 32768 0 32768 0 TIME_WAIT
localhost.32818 localhost.32819 32768 0 32768 0 TIME_WAIT
localhost.32822 localhost.32787 32768 0 32768 0 TIME_WAIT
localhost.32825 localhost.32787 32768 0 32768 0 TIME_WAIT
localhost.32828 localhost.32787 32768 0 32768 0 TIME_WAIT
localhost.32830 localhost.32831 32768 0 32768 0 TIME_WAIT
DatastagePX.32833 DatastagePX.6000 32768 0 32768 0 ESTABLISHED
DatastagePX.6000 DatastagePX.32833 32768 0 32768 0 ESTABLISHED
localhost.32835 localhost.32787 32768 0 32768 0 ESTABLISHED
localhost.32787 localhost.32835 32768 0 32768 0 ESTABLISHED
localhost.32838 localhost.32837 32768 0 32768 0 ESTABLISHED
localhost.32837 localhost.32838 32768 0 32768 0 ESTABLISHED
localhost.32841 localhost.32787 32768 0 32768 0 TIME_WAIT
localhost.32843 localhost.32844 32768 0 32768 0 TIME_WAIT


thanks
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Not an enterprize (PX) expert,
but are you sure nothing system wise (permisions/passwords, etc'..) was changed recently?

IHTH
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
bigpoppa
Participant
Posts: 190
Joined: Fri Feb 28, 2003 11:39 am

Connection problem!

Post by bigpoppa »

ld.so.1: dscs: fatal: libUtilWSClient.so: open failed: No such file or directory

I think the above line is your main problem. If this is a DataStage library, then you might need to reinstall DataStage. The library might have been corrupted during the install, or perhaps on the install disk. If it is a UNIX standard library, then you have bigger problems.

Can anyone verify for mlind that "libUtilWSClient.so" is a DataStage lib?

Thanks,
BP
Teej
Participant
Posts: 677
Joined: Fri Aug 08, 2003 9:26 am
Location: USA

Re: Connection problem!

Post by Teej »

I have 6.x, and that file is non-existant on both client and server. I suspect this is a 7.x-only issue.

-T.J.
Developer of DataStage Parallel Engine (Orchestrate).
supportdei13
Participant
Posts: 6
Joined: Thu Apr 29, 2004 7:51 am

Connection problem!

Post by supportdei13 »

We have the same problem here today ( was working fine last week ).

trace :

RPCPID=48134 - 11:20:23 - accept: forking and execing /dsbatch0/product/datastage/Ascential/DataStage/DSEngine/bin/dsapi_server
RPCPID=48134 - 11:20:23 - In parent child PID=39856
exec(): 0509-036 Cannot load program dscs because of the following errors:
0509-150 Dependent module libUtilWSClient.so could not be loaded.
0509-022 Cannot load module libUtilWSClient.so.
0509-026 System error: A file or directory in the path name does not exist.
RPCPID=48134 - 11:20:23 - waited on child 39856

Did you manage to solve it
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

Are you using DB2? If so, there is a known issue with DB2 libraries using the same name as your DataStage's libraries.

In setting up your paths, make sure that your DataStage paths comes FIRST before anything else. Especially in "bin/dsenv".

Bounce the server, and see if this problem continues.
Post Reply