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"

Reply via email to