Does it always happen on this particular ticket? Can you check the watchers list for it, are there any?

Yes it happens every time on this ticket. yes there are two watchers - myself and one other person.

Can you try removing both watchers and put the comment in? Does it work? If it does, try commenting again.

I click the delete icon and confirm each. Nothing seems to change on the screen - no error messages but no changes. I refresh the screen (re-fetch the ticket by number) both watchers are still there.

Can you please check Gemini's system log for errors (Administration -> System log)?

Lots of errors in the logs. (Lots of attempts to comment.) They are all almost exactly identical to the the first one below. There is one that is different (the second one):

-- first one ----------------------------------------------

Cannot insert duplicate key row in object 'dbo.geminiwatchissues' with unique index 'uindgeminiwatchissuesid'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Id.IdentityGenerator.InsertSelectDelegate.ExecuteAndExtract(IDbCommand insert, ISessionImplementor session) at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)

-- second one -------------------------------------------------------

could not insert: [CounterSoft.Gemini.Commons.Entity.IssueWatcherEN][SQL: INSERT INTO geminiwatchissues (projectid, userid, issueid) VALUES (?, ?, ?); select SCOPEIDENTITY()] at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) at NHibernate.Action.EntityIdentityInsertAction.Execute() at NHibernate.Engine.ActionQueue.Execute(IExecutable executable) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.Save(Object obj) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9, ISession x45b53be31e53d68b) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9) at CounterSoft.Gemini.Business.x95da312ae9372c2e.xe19f89ad8f4967c9(Int32 xa8708020b9a21a3a, Int32 x663e02d322c995c9, Int32 xe6f5e35d7ce26e93) at CounterSoft.Gemini.Business.x95da312ae9372c2e.x11dbdcad4df00d52(IssueEN x22c77d60925997e9) at CounterSoft.Gemini.Business.x95da312ae9372c2e.xe6c068ecd01330f5(IssueEN x22c77d60925997e9, Int32 xdf6548ad179b4d83, Boolean xcbecc09e33c13ebd) at CounterSoft.Gemini.Presenter.IssuePresenter.UpdateIssue(IssueEN issue) at CounterSoft.Gemini.Web.Methods.IssueUpdateHandler.UpdateIssue()

Seems to me like the delete fails for some reason, is there no error regarding that? Is the SQL user that Gemini runs under a dbo?

The attempted delete of the watcher is not logging any events. The user is indeed the DBO.

Please send an email to support at countersoft dot com, we will arrange a remote session to see if we can resolve this issue.

I am having EXACT problem, only happens to this Issue # and cannot remove the issue watcher either.

Is there a solution for this yet?

Cannot insert duplicate key row in object 'dbo.geminiwatchissues' with unique index 'uindgeminiwatchissuesid'. The statement has been terminated. 2/8/2012 10:19:41 AM at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior

Please run the following SQL:

update w
set w.projectid = i.projectid
from gemini_watchissues w join gemini_issues i on w.issueid = i.issueid where w.projectid!=i.projectid