Home Home
  login

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Constraint error on project delete

admin
web-app
database

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, IDictionary2 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 		Andrew Dorfman
Wednesday, October 24, 2012, 6:46:09 PM
Replies (2)
helpful
0
not helpful

Did you run the Upgrade_v5-0-PostMigration.sql script?
Mark Wing
· 9108 		Mark Wing
Wednesday, October 24, 2012, 6:49:14 PM
helpful
0
not helpful

I did run it but I just reran and it seems to work now. I can delete without error.
Andrew Dorfman
· 1 		Andrew Dorfman
Wednesday, October 24, 2012, 6:57:02 PM