Hi, Not sure if I read this correctly but are you saying the below tests of connecting actually on the local machine, either through User tool or driver?
If so then its a network issue from your client to the AR Server. If it doesn't connect from running on the local server then you have to debug why the AR Server is taking too long connecting to the DB. Get the DBA to look at the logs to see if there are SQL statements connecting under the user ARADMIN and if they are then ask him/her why are they slow all of a sudden. If not then again its a connection issue from your AR Server to the database. As its windows, check no patch has been applied etc. If its remote from the AR server then use the native client tools, e.g. Oracle-sqlplus or MSSQL-ODBC using Jet or something similar. Regards Danny Single Sign On (SSO) for the BMC Remedy AR System and ITSM http://www.javasystemsolutions.com/jss/ssoplugin -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: 01 June 2011 17:42 To: arslist@ARSLIST.ORG Subject: urgent -- clients can not establish connection with server. Hoping someone can provide pointers to fix the issue. Windows 2008,itsm 7.6.03, oracl 11g. All of a sudden we are seeing clients can not able to connect to arserver, after ars restart. All the clients are giving the same error that server is busy. I am suspecting some thing changed on the environment(security/os etc), but I have no way to prove that as all the connections at the network/os level are working fine. We are seeing the same issue with other servers in the servergroup also. >From our internal diagnosis: The server was never busy, by looking at the logs,cpu,memory When tried to login through client, we can see on the server side api,sql logs that arserver is authenticating the user successfully. After the authentication we did not see anything else happening which is causing the client to timeout. So it seems like that the client is able to communicate with the server, where as the server is unable to respond back to the client. We tested with remote, as well as local client installed on the server. 1. Disabled all McAfee processes 2. Disabled windows firewall 3. Connecting through a user tool installed on the server itself. 4. Tested with the driver utility under C:\Program Files\BMC Software \ARSystem\Arserver\api\driver folder 5. Tested with the client side api logs turned on for developer studio. 6. Tested with user tool both local and remote 7. Tested with midtier 8. Disabled preference server option. 9. Disabled Assignment Engine,Approval server, dispatcher, servergroup option, escalation, sla,full text, email engine. 10.Disabled port mapper and using the direct tcp port number. 11. Verified with netstat and server is listening to the correct port numbers. 12. We tried connecting the ars to a different db(development), we are still seeing the same issue, where as the the development ars server has no issues. So it is telling me is not an issue with the db. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
