Cannot create universe domain. (ADW0011)

security Supervisor (4.x - 6.x)
1

Fellow Listers:

I’ve not (yet?) had success getting this resolved via Business Objects Tech. Support:

Oracle 8
BO 5.0 (recently upgraded from 4.1.3)

I have two sets of universe and document domains, and I’m trying to create a third. All domains will connect to different Oracle instances. The domain I’m trying to create is DIFFERENT from the other 2. I’m receiving the following error message: Creating universe domain… create table UNV_JOIN(JOIN_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null, JN_X_AXIS NUMBER(10) not null, JN_Y_AXIS NUMBER(10) not null, JN_X1 NUMBER(10) null, JN_X2 NUMBER(10) null, JN_HIDDEN CHAR(2) not null, JN_POSITION NUMBER(10) not null) ORA-00955: name is already used by an existing object Cannot create universe domain. (ADW0011)

I’m not creating a new repository. I upgraded the repository from 4.1.3 to 5.0. I am now attempting to add new universe and document domains:

  1. The privileges are already correctly established on the repository
    Oracle instance. This is evidenced by the fact that I was able to create one additional set of universe and document domains.

  2. There are currently two universe and two document domains. I
    successfully created the second universe and document domains. This means, that I was able to make sure that the domains did not default to the same name as the original domains. The error was encountered when I tried to create the third universe and document domains.

  3. There are tables in existence already because I’m not creating a new
    repository.

Any other suggestions? Could there be a problem with the Business Objects script that creates the domains? Thanks for your help!

  • Leslie Cords
    Ameritech
    414-227-6820

Listserv Archives (BOB member since 2002-06-25)

2

Would you believe it’s an easy fix??

The trick is that you need to set up another USER, in whatever instance you choose… I have a user for each of my domains - EDWDEV, EDWCERT, EDWPROD…

When you make a repository, you set up 2 tables - each domain has the SAME tables, that is why it is not letting you go on… if you make a new user, the table will get created in that user’s schema, and you will not get the error any more.

Just set this user up with oracle’s security manager, do a “create like” from a user that has a domain already…

You can email me directly if you have more problems, but I have set up 3 separate installs of BO in the last month, this will work : )

Brent Douglas, EDW Tools
NCR Dayton.

Fellow Listers:

I’ve not (yet?) had success getting this resolved via Business Objects Tech.
Support:

Oracle 8
BO 5.0 (recently upgraded from 4.1.3)

I have two sets of universe and document domains, and I’m trying to create
a third. All domains will connect to different Oracle instances. The domain
I’m trying to create is DIFFERENT from the other 2. I’m receiving the
following error message: Creating universe domain… create table UNV_JOIN(JOIN_ID NUMBER(10) not null, UNIVERSE_ID NUMBER(10) not null,
JN_X_AXIS NUMBER(10) not null, JN_Y_AXIS NUMBER(10) not null, JN_X1 NUMBER(10) null, JN_X2 NUMBER(10) null, JN_HIDDEN CHAR(2) not null, JN_POSITION NUMBER(10) not null) ORA-00955: name is already used by an
existing object Cannot create universe domain. (ADW0011)

I’m not creating a new repository. I upgraded the repository from 4.1.3 to
5.0. I am now attempting to add new universe and document domains:

  1. The privileges are already correctly established on the
    repository
    Oracle instance. This is evidenced by the fact that I was able to create
    one additional set of universe and document domains.

  2. There are currently two universe and two document domains.
    I
    successfully created the second universe and document domains. This means,
    that I was able to make sure that the domains did not default to the same
    name as the original domains. The error was encountered when I tried to
    create the third universe and document domains.

  3. There are tables in existence already because I’m not
    creating a new
    repository.

Any other suggestions? Could there be a problem with the Business Objects
script that creates the domains? Thanks for your help!

  • Leslie Cords
    Ameritech
    414-227-6820

Listserv Archives (BOB member since 2002-06-25)

3

Yes, that works. I was confused as to where the domains were being created. Thanks so much!

Would you believe it’s an easy fix??

The trick is that you need to set up another USER, in whatever instance you choose… I have a user for each of my domains - EDWDEV, EDWCERT, EDWPROD…

When you make a repository, you set up 2 tables - each domain has the SAME tables, that is why it is not letting you go on… if you make a new user, the table will get created in that user’s schema, and you will not get the error any more.

Just set this user up with oracle’s security manager, do a “create like” from a user that has a domain already…

You can email me directly if you have more problems, but I have set up 3 separate installs of BO in the last month, this will work : )

Brent Douglas, EDW Tools
NCR Dayton.

Listserv Archives (BOB member since 2002-06-25)