DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic is not resolved, but there is a WORKAROUND.
Author Message
suneelchallagali
Participant



Joined: 02 Dec 2008
Posts: 251

Points: 2047

Post Posted: Wed Jan 26, 2011 11:39 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

i have searched through the DS forms regarding "failed to connect to datastageserver:abc, project:xx (Internal Error (39202))" I got around 30 posts, i have gone through each of it but unable to figure out this issue. This issue happens frequently normally we will down and up the datastage server this fix the issue temporary (not able to login into designer,directorand even for admin client with dsadm user but can login into web console).

When i have gone through the post related to 39202 error, in most of the cases they mentioned that it is due to file permissions, i have checked the files permissions they access to it.

Note:
1.we have Group name as DStage and user dsadm
2./tmp has every one to access
3.set up TMPDIR in administrator to /project/tmp folder.
4 In $DSHOME/uvconfig file value for UVTEMP is pointing to /tmp.

Thank you,
suneel

_________________
thanks,
suneel
suneelchallagali
Participant



Joined: 02 Dec 2008
Posts: 251

Points: 2047

Post Posted: Fri Jan 28, 2011 3:47 pm Reply with quote    Back to top    

Please any one can help me Out!!!!

_________________
thanks,
suneel
Rate this response:  
Not yet rated
suneelchallagali
Participant



Joined: 02 Dec 2008
Posts: 251

Points: 2047

Post Posted: Mon Jan 31, 2011 4:49 pm Reply with quote    Back to top    

Hi,
we have open PMR with IBM guys. They send us few steps to follows or call them when this issue occurs again!!!!!. Rather than waiting for problem to occur,so though of posting in DSxchange so that i will get some inputs from you guys!!!!. But seems to be every one are busy, that's fine!!!!

Mean while i will mark this as work around if incase we find any solution i will post it, so that it might be helpful others.


thank you,
suneel

_________________
thanks,
suneel
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42677
Location: Denver, CO
Points: 219803

Post Posted: Mon Jan 31, 2011 6:55 pm Reply with quote    Back to top    

So... what "few steps" did IBM send you? Anything worth sharing?

I had nothing to add, not having had any personal experience with an error like that and didn't understand how any kind of 'permissions' error could be resolved (even temporarily) by recycling the DataStage services, so figured something else must be going on.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
suneelchallagali
Participant



Joined: 02 Dec 2008
Posts: 251

Points: 2047

Post Posted: Tue Feb 01, 2011 8:49 am Reply with quote    Back to top    

Finally some one has replied, thank you chulett

These are steps, they mentioned to follow:

From past dealings with such issues, this error is usually permissions related, if not /tmp then permissions on all or some of the DataStage Server, we need to check to see if the files group is set to something like system?

Example. does the ls -l |grep root on in the following directory return something similar to this:

/opt/IBM/InformationServer/IIS/Server/DSEngine/bin>ls -l |grep root

-rws--x--x 1 root system 87585 Mar 07 2007 DBsetup
-rws--x--x 1 root system 1646771 Mar 07 2007 dsdlockd
-rws--x--x 1 root system 1603427 Mar 07 2007 dslictool
lrwxrwxrwx 1 root system 55 Jan 22 16:44 dssh ->
/opt/IBM/InformationServer/IIS/Server/DSEngine/bin/uvsh
-rws--x--x 1 root system 6920 Mar 07 2007 dstskup
-rws--x--x 1 root system 1615899 Mar 07 2007 list_readu
-rws--x--x 1 root system 1607287 Mar 07 2007 load_NLS_shm
-rws--x--x 1 root system 66821 Mar 07 2007 uv

If the user id with which you are trying to login to DS Clients as, does not belong to the groups returned, you could get the above error. You may have to..

- Stop the DSEngine
- Run the following as root:

1) cd `cat /.dshome
2) . ./dsenv
3) ./scripts/DSEenableimpersonation
uvregen: reconfiguration complete, disk segment size is 6954248
4) cd ..
5) chgrp -R dstage DSEngine Projects

Once services are up and running, attempt to login via the DS Clients.


If the issue is not permission related on the /tmp location, another reason for connection failure could be that the dsrpcd process was stopped when there were active connections on the dsrpcd TCPIP
port of 31538. Therefore, can you please check the following:

1) netstat -na|grep 31538 --> Can you see a LISTENER, or connections in a TIME_WAIT state? If in doubt, send me the output.

2) Maybe there is a typo in the dsenv file. Ensure that the LIB PATH is set correctly and exported. Again, please send me the file if in doubt.

3) Finally, do the following steps:

3.1) netstat -na|grep 31538 ---> If this does not return anything, or just a LISTENER, proceed with the next steps.

3.2) cd $DSHOME

3.3) . ./dsenv

3.4) bin/uv -admin -stop

3.5) netstat -na|grep 31538 ---> This should not return anything

3.6) bin/uv -admin -start

3.7) netstat -na|grep 31538 ----> This should return a LISTENER.

If the above fails, please send me:

A) Output of 'netstat -na|grep 31538'
B) Output of 'ps -ef'
C) The dsenv file.

Thank you,
suneel

_________________
thanks,
suneel
Rate this response:  
Not yet rated
suneelchallagali
Participant



Joined: 02 Dec 2008
Posts: 251

Points: 2047

Post Posted: Wed Feb 09, 2011 7:00 pm Reply with quote    Back to top    

Still working with IBM guys, if any one had this issue earlier please can you help me out!!!


Thank you,
suneel

_________________
thanks,
suneel
Rate this response:  
Not yet rated
satish_valavala
Participant



Joined: 18 May 2005
Posts: 123
Location: USA
Points: 850

Post Posted: Thu Feb 10, 2011 2:22 pm Reply with quote    Back to top    

Did you notice any huge java and/or core dump files under WAS logs folder ( /opt/IBM/WebSphereX.0/AppServer/profiles/default/logs/server1 ) during that time.

_________________
Regards
VS
Rate this response:  
Not yet rated
suneelchallagali
Participant



Joined: 02 Dec 2008
Posts: 251

Points: 2047

Post Posted: Thu Feb 10, 2011 4:00 pm Reply with quote    Back to top    

Thank you for your replay satish!!.. we forgot to take a look the log file under WAS folder. Right now datastage is up and running fine, but not sure when again "39202 internal error" occur again. Even IBM guys also working on it..

Thank you,
suneel

_________________
thanks,
suneel
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours