Anesh: What patch level of ARS 7.0.1 is running and what's your server environment like? If the problem is happening to the same users every time, then you might check out the clients as J.T. suggested. If it happens to different users but only occasionally, then I'd suspect the server.
One thing I've seen cause intermittent crashes in the past is if arserverd can't obtain temporary storage (due to disk full, directory deleted, etc) -- perhaps you'll want to chech this. HTH, --Phil ----- Original Message ---- From: J.T. Shyman <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, December 20, 2007 5:19:59 AM Subject: Re: ARERR [565] Index for value in SQL command is greater than the number of values returned Unfortunately, this isn't an easy issue to solve. Segmentation Faults can happen for a variety of reasons from bad software to bad hardware to transient errors in RAM or on disks. Since this has been running for some time and is only happening to certain users my next question would be: Has anything changed on the profile of the users who are experiencing this issue? You may want to try clearing the client-side cache on the system of a user who is having this problem. It may help, it may not. Next, I'd try uninstalling and reinstalling the client tools for the user with this problem. Make sure the version you install matches the version and patch level of the server. Hope that helps. J.T. Shyman Column Technologies -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anesh A Kurian Sent: Thursday, December 20, 2007 6:07 AM To: [email protected] Subject: Re: ARERR [565] Index for value in SQL command is greater than the number of values returned Hi Shyman, Well the system is one which has been running fine for sometime. It's suddenly that this error started to come. There is not firewall between the DB as the DB and ARS server are on the same network. Is there any way we can stop this behaviour? I would appreciate if you could give some tips or work around. Thanks and regards, Anesh A Kurian -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Thursday, December 20, 2007 3:52 PM To: [email protected] Subject: Re: ARERR [565] Index for value in SQL command is greater than the number of values returned Anesh, The first line of the log seems to indicate the ARServer process is crashing: Tue Dec 18 13:25:45 2007 0 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) which should cause it to restart and cause a short outage while armonitor restarts it. The "11" on the second line indicates a segmentation fault (crash). Unfortunately, these can sometimes be hard to track down causes for. The "unable to thread local storage" is a symptom of ARServer crashing, not a different problem, most likely. Let me ask this: Is this a new system or one that has been running well for a while and just recently started getting these errors? Are there any firewalls or network appliances between the Oracle server and the ARS server? J.T. Shyman Column Technologies -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anesh A Kurian Sent: Thursday, December 20, 2007 4:06 AM To: [email protected] Subject: ARERR [565] Index for value in SQL command is greater than the number of values returned Hi All, I have an ARS 7.0.1 running on Oracle 10. I receive this strange error when trying to log in thru the User Tool or Admin Tool. Not every user gets this error when trying to log in. And when the server is restarted then the error goes and comes back after sometime. Has any one faced the same problem? When we went thru the arerror.log We got the below error, which takes places exactly when a user tries to log in to the system. If anyone has earlier faced this or has any solution to it kindly update me. Tue Dec 18 13:25:45 2007 0 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 18 13:25:45 2007 11 Tue Dec 18 13:25:45 2007 0 : AR System server terminated -- fatal error encountered (ARNOTE 21) Tue Dec 18 13:25:45 2007 0 : Unable to access thread local storage. (ARERR 8747) Tue Dec 18 13:25:45 2007 WriteWorkflowTraceLog() Tue Dec 18 13:25:45 2007 0 : Unable to access thread local storage. (ARERR 8747) Tue Dec 18 13:25:45 2007 WriteWorkflowTraceLog() : Thanks and regards Anesh A Kurian ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
