Error in itself reference (tree structure)

Jun 14, 2011 at 1:49 PM

1.    I'm getting an error when i'm trying to install SQL script -

I have message  " Could not drop object 'crs_S1_GeoItem'    because it is referenced by a FOREIGN KEY constraint"   where crs_S1_GeoItem is a table that  has 'Id_item' and Id_ParentItem fields.

2.    And  another qusetion  when i'm starting installing DB infrastructure script,      WHAT does it mean : " The database being updated was created against a different model.  This may cause database versioning issues if you continue."   -   what does it mean   " against different Model" .

Coordinator
Jun 14, 2011 at 9:36 PM

When there are changes to the model the installer corrects for this. It controls all keys, indexes, etc. If you have added some manually or had another model installer do this then there might be some dependencies that the new installer does not know about. You can manually remove that constraint to get the installer working. Just remember, the model does not know what you (or another script) has changed in the database.