Has no one else with ITSM 7.6 p1 seen this issue in change? I'm not sure why we would see it in one system and not another. I tried re-installing the approval server to no effect.
Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ramey, Anne Sent: Friday, January 21, 2011 12:41 PM To: arslist@ARSLIST.ORG Subject: Approvals hanging up ** When I (or anyone else) approves a change (ARS 7.5 p6 ITSM 7.6 p1) the change actually does get approved quickly, but the screen (web or client) doesn't return for the user doing the approvals. They eventually get a message about a timeout performing an operation to the DB (ARERR [94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation : <server>). The SQL/API/Filter log for the client looks like this at the end: <ACTL> --1-- Stop active link processing - On Table Content Change <CLAT> /* Fri Jan 21 2011 12:33:19.2790 */+API call <API > <TID: 1110919488> <RPC ID: 0000358401> <Queue: Fast > <Client-RPC: 390620 > <USER: arramey > /* Fri Jan 21 2011 12:33:19.2766 */+VFC ARValidateFormCache -- form AP:PreviewInfo from Remedy User (protocol 14) at IP address <server ip> <SQL > <TID: 1110919488> <RPC ID: 0000358401> <Queue: Fast > <Client-RPC: 390620 > <USER: arramey > /* Fri Jan 21 2011 12:33:19.3093 */SELECT charMenuId,name,version,smObjProp FROM char_menu WHERE timestamp > 2147483640 ORDER BY 1 ASC <SQL > <TID: 1110919488> <RPC ID: 0000358401> <Queue: Fast > <Client-RPC: 390620 > <USER: arramey > /* Fri Jan 21 2011 12:33:19.3106 */OK <API > <TID: 1110919488> <RPC ID: 0000358401> <Queue: Fast > <Client-RPC: 390620 > <USER: arramey > /* Fri Jan 21 2011 12:33:19.3137 */-VFC OK <CLAT> /* Fri Jan 21 2011 12:33:19.3880 */-API call <CLAT> /* Fri Jan 21 2011 12:33:19.4980 */+API call While it is "stuck". Has anyone else run across this? It doesn't happen in my development environment, just my UAT. The primary difference are the UAT DB is much bigger with more changes and more approval rules. Could that be it? Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _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"
