Skip to Content
avatar image
Former Member

Supervisor Error ADM0015

Hi,

I tried to create a new user in Supervisor and I received error "Operation failed (ADM0015)"

I performed a Scan and Repair repository, but I still receive the error.

All rollback segment in database are online.

Software Configuration :

Business Object 6.5.1

Oracle Database 9.2.0.8.0

Supervisor 6.5.1

Best Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 11, 2008 at 12:43 PM

    Hi Lang,

    Symptom:

    You add a new user in Supervisor. After you enter the user name, you receive the error "Operation Failed (ADM0015)". A Scan and Repair of the Security Domain fails to solve the issue.

    1]

    Cause:

    The Oracle tuning parameter CURSOR_SHARING has been set to FORCE. This Oracle feature causes certain queries generated by Supervisor to fail, returning an "ORA0933" error, which is masked by the Supervisor error.

    Workaround:

    Have your database administrator (DBA) set the "Init.ora" file parameter CURSOR_SHARING to the default value EXACT.

    Note: Business Objects does not support changing this parameter value to FORCE.

    2]

    Cause:

    This is a database issue; you do not have enough rollback segments online. You have your system rollback segment online, and the other rollback segments are either offline or do not have enough space.

    A rollback segment is a structure that records data changes from the database. More precisely, a rollback segment contains all of the information necessary to reconstruct a database block as it existed prior to a change to that data block.

    Workaround:

    The database administrator (DBA) must switch some other rollback segments online, or increase the sizes of the existing segments.

    Hope above workarounds helps you.

    Regards,

    Deepti Bajpai

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 12, 2008 at 05:38 AM

    Hi, thank you for the answers

    As you advised all solutions has been checked :

    1 - The Oracle Tuning parameter is not set in init.ora file and he had the default value .

    2 - All rollback segment are online, may they do not have enough space but we have a same configuration in production environment and we never had a same error

    Have you any other propositions to solve this issue??

    Cheers, Mounir

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2008 at 04:05 AM

    Anyone has a suggestion. The is still pending.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2008 at 11:31 PM

    more information founded,

    When I trace a supervisor session in database I have a : Error encountered: ORA-00947.

    May you can suggest any othe sulotions.

    Add comment
    10|10000 characters needed characters exceeded