Ron, A restart of the ARServer closes out all current connections to the DB, and the startup re-establishes them. So, if one of your connections was causing blocking of some sort at the DB level and other threads couldn't continue, then you restarted.you would have cleared up the blocking with the shutdown..so while not a 'db' issue per se..still possibly related to db connectivity/performance.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Peters, Ron Sent: Friday, February 10, 2012 8:34 AM To: [email protected] Subject: AR Server or DB issue ** Hello all, Having some AR server issues. Something has been happening in the mornings about 6am in that our service desk can't access Remedy. This started in Decemeber but only once. Then twice in January and now a couple times this week. The first few times it resolved itself after about 30 minutes but this week we had to restart the AR service on the server to get it back. The following is the arerror log from this morning. I've contacted our DBA's to see if they notice anything but since an AR restart resolves it, I'm not convinced it's a DB issue. Any thoughts? Thanks. Fri Feb 10 06:25:30 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:25:30 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:25:31 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:25:31 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:27:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:27:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:27:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:27:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:29:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:29:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:29:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:29:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:30:05 2012 BRIE : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (OUR_AR_SERVER) ARERR - 94 Fri Feb 10 06:31:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:31:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:31:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:31:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:33:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:33:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:33:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:33:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:35:02 2012 CMDB Dispatcher : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (OUR_AR_SERVER) ARERR - 94 Fri Feb 10 06:35:05 2012 BRIE : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (OUR_AR_SERVER) ARERR - 94 Fri Feb 10 06:35:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:35:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:35:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:35:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:37:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:37:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:37:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:37:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
