rdiepenbrock
-
9/3/2009 10:46:29 AM
Database error on site delete
I am receiving this error when attempting to remove the Community Site:
Error deleting site: [DataConnection.ExecuteQuery]: Query: DELETE FROM CMS_Site WHERE [SiteID] = @ID: caused exception: The DELETE statement conflicted with the REFERENCE constraint "FK_CMS_DocumentAlias_CMS_Site". The conflict occurred in database "GNWeb", table "dbo.CMS_DocumentAlias", column 'AliasSiteID'. The statement has been terminated. Stack trace: at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) at CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) at CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryText, Object[,] parameters, QueryTypeEnum queryType, Boolean transaction) at CMS.DataEngine.GeneralConnection.RunQueryObject(Query query, Object[,] parameters) at CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN, String columns) at CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters) at CMS.SiteProvider.SiteInfoProvider.DeleteSiteInternal(SiteInfo si, GeneralConnection conn) at CMS.SiteProvider.SiteInfoProvider.DeleteSite(String siteName) at SiteDeletionManager.DeleteSite(Object parameter) in c:\inetpub\wwwroot\gnweb\CMSSiteManager\Sites\Site_Delete.aspx.cs:line 727
|