Constraint error on project delete
I've upgrade from v4.2 to v 5.1.2 and am getting the following error when I try to delete projects or issues no longer wanted:
Unhandled exception: The DELETE statement conflicted with the REFERENCE constraint "geminiissuehistoryissueidfk". The conflict occurred in database "Gemini", table "dbo.geminiissuehistory", column 'issueid'.
The statement has been terminated.[SQL: delete from gemini_issues where projectid=?]. Stack trace: at NHibernate.Hql.Ast.ANTLR.Exec.BasicExecutor.Execute(QueryParameters parameters, ISessionImplementor session)
at NHibernate.Engine.Query.HQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
at NHibernate.Impl.SessionImpl.ExecuteUpdate(String query, QueryParameters queryParameters)
at NHibernate.Impl.QueryImpl.ExecuteUpdate()
at Countersoft.Gemini.Data.Projects.ProjectRepository.Delete(Int32 id)
at Countersoft.Gemini.Infrastructure.Managers.BaseManager4.Delete(Int32 id)
at Countersoft.Gemini.Models.Admin.ProjectsProjectsModelBuilder.DeleteAction(Int32 id)
at Countersoft.Gemini.Controllers.Ajax.AjaxAdminController.DeleteAction(String tab, String subTab, Int32 id)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary
2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.<>cDisplayClass39.b33()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.b36(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass25.<>cDisplayClass2a.b20()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass25.b22(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.<>cDisplayClass1d.b18(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar)
at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar)
at System.Web.Mvc.MvcHandler.<>cDisplayClass8.b3(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Andrew Dorfman
· 1 |
|
Wednesday, October 24, 2012, 6:46:09 PM |