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"
