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.




When I attempt to delete a type, it doesn't delete.

admin
templates

I receive the following error in the system log. I checked the project defaultsw to make sure that the type I was deleting wasn't set as a default, and ti was not.

The DELETE statement conflicted with the REFERENCE constraint "geminiprojectdefaultvaluestypeidfk". The conflict occurred in database "Gemini", table "dbo.geminiprojectdefaultvalues", column 'typeid'. The statement has been terminated.[SQL: SQL not available] NHibernate at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps) at NHibernate.AdoNet.AbstractBatcher.ExecuteBatch() at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) at NHibernate.Impl.SessionImpl.Flush() at Countersoft.Foundation.Data.Repository2.Evict(T entity) at Countersoft.Foundation.Data.Repository2.Delete(Int32 id) at Countersoft.Gemini.Infrastructure.Managers.MetaManager.TypeDelete(Int32 id) at Countersoft.Gemini.Models.Admin.TemplatesProcessModelBuilder.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, IDictionary2 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)
Greg Schneider
· 1 		Greg Schneider
Thursday, September 27, 2012, 3:55:57 PM
Replies (2)
helpful
0
not helpful

Please run the following SQL in you Gemini database: 

alter table gemini_projectdefaultvalues drop constraint gemini_projectdefaultvalues_typeid_fk

Mark Wing
· 9108 		Mark Wing
Thursday, September 27, 2012, 6:18:39 PM
helpful
0
not helpful

This has fixed the problem.
Greg Schneider
· 1 		Greg Schneider
Friday, September 28, 2012, 4:39:24 PM