Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

RoundTable 9.1x

SYMPTOM(s):

RoundTable. "An object with this name already exists" during schema update

FIX:

This message means that this object already exists in Roundtable. Schema load is only used to add new objects or load in changes to existing objects. If it finds a new object, but then finds that the object already exists in RTB, it assumes you are trying to load a different object that "happens" to share the same physical name. By allowing you to add a prefix, you can create a new object with a different logical name for the object that shares the same physical name. For example "sports.customer" for the customer table in the sports DB, and "challenge.customer" for the customer table in the challenge DB.

Notice that schema load automatically prefixes fields with the table name for uniqueness across tables. If you add the DB name as a prefix, tables can share the same physical name in two different databases.

In some cases, the object may have existed at one time but has since been deleted from the workspace. Even though you cannot see it in the workspace, the object still exists in the repository. To add the object back, you would assign the object back to the workspace, assign the field to the table or table to the DB, perform a schema update (skip the table so that the physical db is not touched) to make the change current, then do your load to sync up Roundtable with the physical DB. NOTE: If you assign back a version of a PFILE, all PFIELDS that it references must also be in the workspace.