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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
