When you restarted portmapper it actually stopped and restarted the AR System Server service as well. I don't think it was portmapper that was the problem.
It looks like your problem is that the AR Server is losing connection to the SQL Server. How about trying something like an Escalation that runs every x minutes and does a SQL query to the database. Something like: Select COUNT(*) from ARSCHEMA. This would make a call to the database and keep that connection alive. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Reiser, John J Sent: Wednesday, January 06, 2010 3:43 PM To: [email protected] Subject: Re: ARServer Status monitor ** Jason, The Service looked like it was running but there were entries in the error.log file that pointed to a dropped network connection or DB unavailable. General network error. Check your network documentation. (SQL Server 11) SQL Server does not exist or access denied. (SQL Server 17) Cannot open database "ARSystem" requested by the login. The login failed. (SQL Server 4060) Then all night long the error.log was filled with Dispatch : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (<servername removed>) ARERR - 94 Distrib : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (ARERR 94) This happened every 6 minutes until they called me at 6 AM and I kick started the Portmapper. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 3:54 PM To: [email protected] Subject: Re: ARServer Status monitor ** Hi John, Is ARS actually down on production or is just not allowing connections because Portmapper unhappy? Jason On Wed, Jan 6, 2010 at 10:10 AM, Reiser, John J <[email protected]> wrote: ** Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I'd like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don't like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
