Are you using AD for authentication? If so, it could be an AD issue. On Wed, 1 Jun 2011 10:50:45 -0700, patchsk <[email protected]> wrote:
>It is not a connection issue from arserver to the database. >Because arserver is starting up fine, I can see in the logs that it >can read all the table from db during the startup. >And the startup took 5 min which is the time it used to take when it >is working fine. >From the sql logs we can see the sqls are not slow. >We have installed user tool on the server itself and tried to login >from there, still it is timeout saying server is busy. >During the login from user tool we are seeing in the apisql log that >the user is verified. But after that the user tool is taking 2 min and >then timesout. > > > >On Jun 1, 12:04 pm, Danny Kellett ><[email protected]> wrote: >> 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 ITSMhttp://www.javasystemsolutions.com/jss/ssoplugin >> >> >> >> >> >> >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> >> [mailto:[email protected]] On Behalf Of patchsk >> Sent: 01 June 2011 17:42 >> To: [email protected] >> 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 atwww.arslist.org >> attend wwrug11www.wwrug.comARSList: "Where the Answers Are" >> >> ___________________________________________________________________________ ____ >> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org >> attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > >__________________________________________________________________________ _____ >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"
