Internal Error 39202
login 39202 Technote (troubleshooting) Problem(Abstract) Logging into DataStage results in the following error: Failed to connect to host: xxxxx, project: UV (Internal Error (39202)) Resolving the problem There are several possible causes for this error. Go to the $DSHOME directory and run: $. ./dsenv $bin/uvsh If this fails it points to a problem with the engine. If it works correctly and you get the TCL prompt you may have a hung socket. Perform the following steps to cleanup DataStage. Log into server as dsadm or root. Make sure the user has permissions to /tmp and that the partition is not full. From $DSHOME type: $. ./dsenv $bin/smat -t Check that the user has permissions to the location for UVTEMP and UVSPOOL. If you made any changes to ODBC drivers check the permissions under $DSHOME/../branded_odbc. Stop DataStage and check for orphaned processes: $ps -ef|grep phantom $ps -ef|grep dsapi $ps -ef|grep dscs Use kill -9 for any existing processes Check for existing shared memory segment: $ipcs -mop|grep ade (Linux users - use ipcs -m) As root remove any existing segments: $ipcrm -m PID Example: # ipcs -mop |grep ade m 13500432 0xadec7011 --rw-rw-rw- root dstage 0 88240 88100 #ipcrm -m 13500432 Check for hung ports: $netstat -a|grep dsrpc If you get any results in a WAIT state then you need to wait until this it disappears or reboot the server. Depending on the exact state it may clear itself or may never go away. For example a TIME_WAIT is controlled by the ndd parameter tcp_time_wait_interval, which is generally 60s. On Unix/Linux platforms, confirm that the users with login error are a member of group "dstage" or whatever default group was setup at installation time for DataStage files and directories. Use the id command, i.e. "id myuserid" to confirm that dstage is either the default group or in the group list for that user. Start DataStage and Re-connect with DataStage clients. Document information More support for: InfoSphere DataStage Software version: 7.5, 8.0, 8.1 Operating system(s): AIX, HP-UX, Linux, Solaris Reference #: 1413453 Modified date: 2013-04-25 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
trying to connect with the InfoSphere DataStage Client Technote (troubleshooting) Problem(Abstract) When trying to connect with one of the InfoSphere DataStage clients you receive the error: Failed to connect to host, Internal error 39202 Cause In order to troubleshoot what part of the connection to the project is failing, it is best to turn on Server Side Tracing for the failing project. Server Side Tracing you should where the connection code is failing. Server side tracing can be turned on in 2 places, from the InfoSphere DataStage Administrator and from an DataStage engine prompt. If you can open the DataStage administrator: Click on the Projects Tab, Click on http://www-01.ibm.com/support/docview.wss?uid=swg21413453 the project with the problem and click on Properties. Click the Tracing tab and Check Enable If you can't open the Administrator client, you will need to turn on tracing at the DataStage engine level. Telnet to the DataStage server machine and login as your DataStage admin user cd to the DSEngine directory Unix/Linux: Source the dsenv by typing: . ./dsenv Go into the engine by typing: bin/uvsh Windows: Go into the engine by http://www-01.ibm.com/support/docview.wss?uid=swg21431890 typing: bin\uvsh At the ">" prompt type: LOGTO projectname Where project name is the name of the project with the connection issue. Once in the project type: RESIZE &COMO& 19 TRACE ON Now that tracing is turned on, attempt to open the Designer Client. You should get a warning message that server side tracing has been turned on. Login so that you receive your error message Once you get the error, turn tracing off. From the Administrator, uncheck "Enable". From the Engine prompt type: TRACE OFF When it asks if you want to clear the trace files say No. You can view the trace files in the administrator on the same screen where you turned tracing on. If you cannot get into the Administrator, you can cd into the &COMO& directory in the project and see the trace files in there. The trace files/directories begin with DSRTrace and are all ASCII files Review the log files to find the full error messages corresponding to the connection issue. Document information More support for: InfoSphere DataStage Software version: 7.5.1, 7.5.2, 7.5.3, 8.0.1, 8.1 Operating system(s): AIX, HP-UX, Linux, Solaris, Windows Reference #: 1431890 Modified date: 2010-05-20 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
host:Project: UV (Internal Error(39202) View next topic View previous topic Add To Favorites This topic has been marked "Resolved." This topic is not resolved, but there is a WORKAROUND. Post new topic Reply http://www.dsxchange.com/viewtopic.php?p=220406 to topic DSXchange Forum Index » IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX) http://datawarehouse.ittoolbox.com/groups/technical-functional/ascential-l/failed-to-connect-to-datastage-server-with-39202-error-3181198 Author Message yogesh.singh@target.com Participant Joined: 22 Aug 2006 Posts: 4 Points: 53 Posted: Wed Feb 14, 2007 3:20 am Reply with quote Back to top DataStage Release: 7x Job Type: Parallel OS: Unix When i am trying to connect to dataStge I am getting the following internal error the error. Failed to connect to host:
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX I_am_the_dragon Inside-CRM maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Data Warehouse Groups Ask a New Question DataStage The DataStage group is for the discussion of technical issues that arise during the installation or daily administration of IBM InfoSphere DataStage software. Home | Invite Peers | More Data Warehouse Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Failed to connect to datastage server with 39202 ERROR Zandile Nxumalo asked Dec 14, 2009 | Replies (4) Data stage.. Version 8 Platform Windows xp Project was migrated onto the production Then they had some perf issues. DR testing ?now but can?t log on to project. Some processes were killed to try and resolve but problem persists. The client tries to connect with Designer by putting in ? domain, login and password Then Failed to connect to datastage server with 39202 ERROR Join this group Popular White Paper On This Topi