Hi
After having installed Datastage 7.5.1A, we were not able to configure the plugin for the Oracle Enterprise Stage fro which we changed entries in the dsenv file and shutdown n restarted the engine a couple of times
Subsequently(after having restarted the engine a couple of time) we have not been able to connect to the Server and have been receiving the follow error msg
Failed to connect to host: XYZ,project: TEST
(The connection is broken (81002))
We have bounced the server too to no effect.
Have searched the forum without much success
Any ideas?
Unable to connect to Server
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 68
- Joined: Sat Feb 05, 2005 4:59 am
- Location: India
Unable to connect to Server
Last edited by adarsh shrinagesh on Fri Nov 11, 2005 4:20 pm, edited 1 time in total.
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Re: Unable to connect to Server
Can you do a netstat -a | grep -i fin
Do you see any connections out there with a finwait2 status? If so, you will have to wait for the no -a | grep tcp_finwait2 value divided by 2 seconds to expire before these connections die and you can restart the service. I set this value to 60 for 30 seconds.
You can verify that the service is running successfully by running
$ ps -ef | grep dsrpc
root 28014 1 0 Nov 07 - 0:00 /Ascential/Ascential/DataStage/DSEngine/bin/dsrpcd
$ netstat -a | grep dsrpc
tcp4 0 0 *.dsrpc *.* LISTEN
Does all that look good?
Do you see any connections out there with a finwait2 status? If so, you will have to wait for the no -a | grep tcp_finwait2 value divided by 2 seconds to expire before these connections die and you can restart the service. I set this value to 60 for 30 seconds.
You can verify that the service is running successfully by running
$ ps -ef | grep dsrpc
root 28014 1 0 Nov 07 - 0:00 /Ascential/Ascential/DataStage/DSEngine/bin/dsrpcd
$ netstat -a | grep dsrpc
tcp4 0 0 *.dsrpc *.* LISTEN
Does all that look good?
-
- Premium Member
- Posts: 68
- Joined: Sat Feb 05, 2005 4:59 am
- Location: India
Re: Unable to connect to Server
Ultramundane wrote:Can you do a netstat -a | grep -i fin
Do you see any connections out there with a finwait2 status? If so, you will have to wait for the no -a | grep tcp_finwait2 value divided by 2 seconds to expire before these connections die and you can restart the service. I set this value to 60 for 30 seconds.
You can verify that the service is running successfully by running
$ ps -ef | grep dsrpc
root 28014 1 0 Nov 07 - 0:00 /Ascential/Ascential/DataStage/DSEngine/bin/dsrpcd
$ netstat -a | grep dsrpc
tcp4 0 0 *.dsrpc *.* LISTEN
Does all that look good?
yup it does
dsadm /home/dsadm > netstat -s|grep -i fin
0 delayed ACKs for FIN
and the checks on the dsrpc service succeed
but i still cant get thru
-
- Premium Member
- Posts: 68
- Joined: Sat Feb 05, 2005 4:59 am
- Location: India
Re: Unable to connect to Server
Hi
It seems as though the dsenv we were using was corrupt - we replaced the existing one with a backup copy that we had created and presto - things worked fine
Will have to check the actual cause corruption in the dsenv file.
It seems as though the dsenv we were using was corrupt - we replaced the existing one with a backup copy that we had created and presto - things worked fine
Will have to check the actual cause corruption in the dsenv file.