Re: DataBase Design Wizard - Designer 2000

We had a similar problem, which turned out to be caused by bad data in the repository - there were entries without references. According to Oracle Support, the Force Delete function is sometimes too brutal. The following script (supplied by Oracle Support) will tell you if you have that problem:

select name from ci_columns c
where source_attribute_reference is not null and not exists (select 1

                from ci_attributes
                where id = c.source_attribute_reference)

If the script returns any rows, the column name displayed points to the cause of the problem. In RON, the Source attribute in the properties of the troubled column will be marked <Invalid object id>. You can fix the problem from RON, or alternatively run the following script (also supplied by Oracle Support):

update ci_columns c
set source_attribute_reference = null where source_attribute_reference is not null and not exists (select 1

                   from   ci_attributes
                   where  id = c.source_attribute_reference)

Before you do that, be sure to BACK UP the repository.

Good luck,

Niels E. Ebbesen
Danish State Railways (DSB)

>I have not used the Design Wizard since about June of last year. This
>morning I added a new Entity to my datamodel, and then invoked the Design
>Wizard to create a table based on it. However what happened instead was,
>after it made its "duplicate connection" and loaded the table and entity
>definitions from the repository, I got the message that reads:
>
>"An object has been deleted from the database in another session. PLEASE
>QUIT AND RESTART THE DATABASE DESIGN WIZARD WITHOUT SAVING THE CHANGES >YOU
>HAVE MADE. (OK)"
>
>I remember I had this happen before, but I can't find my notes on this
>particular problem. Can anyone point me in the right direction? I will be
>wanting to map several more entities to their associated tables pretty soon,
>as we will be beginning development in a new area of the system, and I
>really don't want to have to create all the table definitions from scratch
>if I can help it.
Received on Mon Jan 08 1996 - 08:19:44 CST