Re: ORA-03127: no new operations allowed until the active operation ends ARERR - 552

[Joe DeSouza]

**

I do not recall offhand how to do this, but I remember it was pretty intuitive... Have you been able to get around to trying this as yet?
 

Joe

----- Original Message ----
From: Kieran O'Hare <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, August 30, 2006 10:04:59 AM
Subject: Re: ORA-03127: no new operations allowed until the active operation ends ARERR - 552

**

Hi Joe,

Thanks for your comments and suggestion.

I’m not strong on Oracle so any help on how to reconfigure the Oracle client connection to use MS ODBC driver for Oracle would be very much appreciated! Is it a case of creating a new User DSN called ‘AR System ODBC Data Source’ (to overwrite the one that’s there) but instead specifying to use the MS driver?

 

Thanks - Kieran

 

---

From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ] On Behalf Of Joe DeSouza
Sent: 04 August 2006 13:22
To: arslist@ARSLIST.ORG
Subject: Re: ORA-03127: no new operations allowed until the active operation ends ARERR - 552

 

 

Kieran,

 

Strange as it may sound it probably could be a limitation of the ODBC driver made by Oracle - at least thats what I got when I looked for possible causes of this error... The reccomendation is to use the MS ODBC driver for Oracle to establish the Oracle Client connections...

 

So if this is the case you need to stop your Remedy services, reconfigure the Oracle client connection to use MS ODBC driver for Oracle and then restart the Remedy server...

 

Hope this helps....

 

Cheers
 

Joe D'Souza

Remedy Developer / Consultant,

BearingPoint,

Virginia.

 

----- Original Message ----
From: Kieran O'Hare <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Friday, August 4, 2006 7:25:07 AM
Subject: ORA-03127: no new operations allowed until the active operation ends ARERR - 552

Hi list,
Just wondering if anybody has experienced the behaviour I am at present. I
have Windows Server 2003, Oracle 10GR2. I installed ARS 7, CMDB 2, Approval
Server 7, Assignment Engine 7 and Incident Management 7. Very soon after the
last install the arerror.log began filling up with thousands of errors of
type:


Thu Aug 03 17:04:10 2006  AssignEng : Failure during SQL operation to the
database (ORA-03127: no new operations allowed until the active operation
ends)  ARERR - 552

If I comment out the assignment engine in armonitor.cfg and restart the
server, the same errors will return but with this time with the Approve :
prefix.

Any ideas?

Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St .
Trinity College
Dublin 2
Phone +353 1 8962774

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

 

__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___