locked
Delete Data Model RRS feed

  • Question

  • Does the Delete-ZentityDataModel function in the DataModelServices actually works? In my case it always throw an error like this one:

    Delete-ZentityDataModel: Exception calling "DeleteDataModel" with "1" argument(s): "System.Data.SqlClient.SqlException

     (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "RelationshipIsAboutResource". The conflict occurred in database "Zentity", table "Core.Relationship", column 'ObjectResourceId'. The statement has been terminated.
    If it doesn't work, is there a way to delete a data model, other than restoring the full Zentity database through the Database.sql and Zentity Services Modification Script - v2.sql scripts (taking into account that restoring the database this way never deletes the Zentity.ScholarlyWorks)?
    Thursday, June 23, 2011 3:51 AM

All replies

  •  

    Thanks for your post

    The only way to get out of this issue of conflicting relationship is to delete the relationship. This can be easily done using a SQL Query and then deleting the respective record from DataModel table.

    -Regards

     

    • Proposed as answer by Kalnemi Thursday, June 23, 2011 10:59 AM
    Thursday, June 23, 2011 10:59 AM