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 ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 3:54 PM To: arslist@ARSLIST.ORG 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 <john.j.rei...@lmco.com<mailto:john.j.rei...@lmco.com>> 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. Pay close attention and be illuminated by its brilliance. - paraphrased by me _Platinum Sponsor: rmisoluti...@verizon.net<mailto:rmisoluti...@verizon.net> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
