Exeception error in application [message #515453] |
Mon, 11 July 2011 11:28 |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
|
|
Hi,
While performing regression testing , developers encounters following errors.
I am not sure if this is an database or application error.
Exception Description :ORA-20115: ORA-20110: Role READONLY cannot contain those contain special roles as following:
AQ_ADMINISTRATOR_ROLE,DBA,APPLICATION_DBA,SELECT_CATALOG_ROLE,EXECUTE_CATALOG_ROLE,
DELETE_CATALOG_ROLE,EXP_FULL_DATABASE,
IMP_FULL_DATABASE,LOGSTDBY_ADMINISTRATOR,RECOVERY_CATALOG_OWNER,OEM_MONITOR
ORA-06512: at "P10", line 140 ORA-06512: at line 1"
Please advice.
Thanks
CM: fixed [code] tags
[Updated on: Mon, 11 July 2011 13:56] by Moderator Report message to a moderator
|
|
|
|
|
|
|
Re: Exeception error in application [message #515461 is a reply to message #515457] |
Mon, 11 July 2011 12:28 |
|
Michel Cadot
Messages: 68645 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
balaji14 wrote on Mon, 11 July 2011 18:44
Thank you Michel.
Can you give more details on this Ora-error?
This is NOT an Oracle error but an application one, I don't know the application, I don't know the error but the message, if it matches with what it is intended to say, is quite clear.
What I can say is that it is raise by a call to raise_application_error function.
Another thing I can say is that the application is badly written.
Regards
Michel
[Updated on: Mon, 11 July 2011 12:29] Report message to a moderator
|
|
|
|
|
Re: Exeception error in application [message #515585 is a reply to message #515581] |
Tue, 12 July 2011 05:03 |
cookiemonster
Messages: 13920 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
@balaji14 - It's an application error. There is code in your application that specifically raises it.
If it's giving you problems you need to find the bit of code that raises that error and see what it does.
If it raises errors in the wrong circumstances then you need to fix it.
|
|
|
Re: Exeception error in application [message #516014 is a reply to message #515585] |
Thu, 14 July 2011 09:19 |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
|
|
Different error this time.
I revoke READONLY role from userid 'meer12' and set the default_role to none. This change encounters the error.
I revoke all the privs assigned to DEVELOPER role and assigned readonly role to meer12 user after this error.
But still the same result.
"An Exception occured while creating account in BALA database for User, Moin kahn (MK002).
Exception Description :ORA-20115: ORA-20109: Role DEVELOPER cannot contain violated privileges. ORA-06512: at "BALA.ELP", line 140 ORA-06512: at line1"
Pls advice.
[Updated on: Thu, 14 July 2011 09:22] Report message to a moderator
|
|
|
|
Re: Exeception error in application [message #516017 is a reply to message #516014] |
Thu, 14 July 2011 09:37 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
balaji14 wrote on Thu, 14 July 2011 16:19Pls advice.
What about have a look at all places mentioned in description, especially the bold part?
Quote:Exception Description :ORA-20115: ORA-20109: Role DEVELOPER cannot contain violated privileges. ORA-06512: at "BALA.ELP", line 140 ORA-06512: at line1"
If it is an EXCEPTION block, inspect all statements in its block. Its removal could lead to more meaningful message.
|
|
|
|
Re: Exeception error in application [message #516145 is a reply to message #516140] |
Fri, 15 July 2011 04:02 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
Do you really read replies posted to you? This is application error, you should inspect the application (whatever it is).
Without looking into Quote:"BALA.ELP", line 140 nobody is able to say. Do you think any member of this forum has access to it? Did you try to inspect it? If it is application specific package, did you contact its developers (or consult 3rd party, if it was developed by it)? Does it have any usage documentation?
|
|
|
|
|
|
Re: Exeception error in application [message #516160 is a reply to message #516156] |
Fri, 15 July 2011 04:45 |
cookiemonster
Messages: 13920 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You look for a piece of code like this:
raise_application_error(-20110, 'Role READONLY cannot contain those contain special roles as following.....');
The 2nd parameter may well be constructed programatically.
Then having found it, look at the surrounding code and see what circumstances cause that line of code to be run.
EDIT: typo
[Updated on: Fri, 15 July 2011 04:46] Report message to a moderator
|
|
|
|
Re: Exeception error in application [message #516169 is a reply to message #516165] |
Fri, 15 July 2011 05:47 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
If you have access to it, just inspect it as suggested by cookiemonster.
If not, report this behaviour to people responsible for the application.
By the way, the procedure/function/package name from the error message is ELP (not EMP); BALA is most probably name of the schema/user which contains it.
|
|
|
|