Re: Approvals hanging up
How many records do you have for approval & changes, etc? 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 Terry Bootsma Sent: Tuesday, January 25, 2011 12:02 PM To: arslist@ARSLIST.ORG Subject: Re: Approvals hanging up ** Anne: we have the exact configuration (on Windows 2003) and do not experience the issue below.. Terry On Jan 25, 2011, Ramey, Anne wrote: ** 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<mailto: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 : ). The SQL/API/Filter log for the client looks like this at the end: --1-- Stop active link processing - On Table Content Change /* Fri Jan 21 2011 12:33:19.2790 */+API call /* Fri Jan 21 2011 12:33:19.2766 */+VFCARValidateFormCache -- form AP:PreviewInfo from Remedy User (protocol 14) at IP address /* Fri Jan 21 2011 12:33:19.3093 */SELECT charMenuId,name,version,smObjProp FROM char_menu WHERE timestamp > 2147483640 ORDER BY 1 ASC /* Fri Jan 21 2011 12:33:19.3106 */OK /* Fri Jan 21 2011 12:33:19.3137 */-VFC OK /* Fri Jan 21 2011 12:33:19.3880 */-API call /* 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<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: Approvals hanging up
** Anne:we have the exact configuration (on Windows 2003) and do not experience the issue below..Terry On Jan 25, 2011, Ramey, Anne wrote: ** 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, AnneSent: Friday, January 21, 2011 12:41 PMTo: arslist@ARSLIST.ORGSubject: 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 : ). The SQL/API/Filter log for the client looks like this at the end: --1-- Stop active link processing - On Table Content Change /* Fri Jan 21 2011 12:33:19.2790 */+API call /* Fri Jan 21 2011 12:33:19.2766 */+VFC ARValidateFormCache -- form AP:PreviewInfo from Remedy User (protocol 14) at IP address /* Fri Jan 21 2011 12:33:19.3093 */SELECT charMenuId,name,version,smObjProp FROM char_menu WHERE timestamp > 2147483640 ORDER BY 1 ASC /* Fri Jan 21 2011 12:33:19.3106 */OK /* Fri Jan 21 2011 12:33:19.3137 */-VFC OK /* Fri Jan 21 2011 12:33:19.3880 */-API call /* 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"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: Approvals hanging up
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 : ). The SQL/API/Filter log for the client looks like this at the end: --1-- Stop active link processing - On Table Content Change /* Fri Jan 21 2011 12:33:19.2790 */+API call /* Fri Jan 21 2011 12:33:19.2766 */+VFCARValidateFormCache -- form AP:PreviewInfo from Remedy User (protocol 14) at IP address /* Fri Jan 21 2011 12:33:19.3093 */SELECT charMenuId,name,version,smObjProp FROM char_menu WHERE timestamp > 2147483640 ORDER BY 1 ASC /* Fri Jan 21 2011 12:33:19.3106 */OK /* Fri Jan 21 2011 12:33:19.3137 */-VFC OK /* Fri Jan 21 2011 12:33:19.3880 */-API call /* 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"
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 : ). The SQL/API/Filter log for the client looks like this at the end: --1-- Stop active link processing - On Table Content Change /* Fri Jan 21 2011 12:33:19.2790 */+API call /* Fri Jan 21 2011 12:33:19.2766 */+VFCARValidateFormCache -- form AP:PreviewInfo from Remedy User (protocol 14) at IP address /* Fri Jan 21 2011 12:33:19.3093 */SELECT charMenuId,name,version,smObjProp FROM char_menu WHERE timestamp > 2147483640 ORDER BY 1 ASC /* Fri Jan 21 2011 12:33:19.3106 */OK /* Fri Jan 21 2011 12:33:19.3137 */-VFC OK /* Fri Jan 21 2011 12:33:19.3880 */-API call /* 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"