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.




Can't Delete Issue Resolution

web-app

I have an issue resolution in Gemini that I no longer wish to use. I've batch updated all issues with this resolution to a different resolution, and have attempted to delete the unwanted entry.

When I click the red 'x' next to the issue resolution, it asks "Are you sure you want to delete?" When I reply "OK", nothing happens. I have waited 10 minutes and the resolution has not disappeared.

This is the first time I've attempted to delete an issue resolution; what should I be seeing?

edit: this Gemini 3.5.4 (Build 2428)

SimonSupport
· 1
SimonSupport
Replies (7)
helpful
0
not helpful

Did you check that closed issues do not use this resultion?

Please check Gemini's error log for errors


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I did ensure that no issues, including closed issues had that resolution. Originally it had stated that 770 issues were using it, but since I did the batch update I no longer get this message.

When I click "System Log" on the administration page, I get a SQL timeout error.


SimonSupport
· 1
SimonSupport
helpful
0
not helpful

Can you please check the contents of the gemini_errorlog table in SQL?

It might be that there are many records in there, if so I suggest deleting previous ones (say more than a month old).


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Looks like there are over 9 million rows. SQL guy is going to archive old entries, and I will hopefully have an error message for you tomorrow. Thanks for your help thus far.


SimonSupport
· 1
SimonSupport
helpful
0
not helpful

I get two messages but I'm sure either one is relevant:

could not insert: [CounterSoft.Gemini.Commons.IssueAlertEN][SQL: INSERT INTO geminiissuealerts (issueid, projectid, userid, servicecomment, alertdata) VALUES (?, ?, ?, ?, ?); select SCOPEIDENTITY()]

and

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


SimonSupport
· 1
SimonSupport
helpful
0
not helpful

Don't look like these are relevant but the fact  that you are getting an error with the issue alerts is a concern. Are you using the mail plugin for alerts?

As for deleting the resolution, can you please run SQL profiler to catch the delete statement?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

We have the same problem here. This question was never fully answered, maybe some additional input is useful.

We have a deprecated resolution. All issues, including closed ones, have been moved to other resolutions, using batch updates.

When deleting the resolution item, the application does not give any feedback on whether this was successful or not.

The error log reports the following errors:

First error:

10502 19/01/2012 12:22:00 Error Gemini could not delete: [CounterSoft.Gemini.Commons.Entity.IssueResolutionEN#7][SQL: DELETE FROM gemini_issueresolutions WHERE resolutionid = ?] at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.x984a14d018f03fe9(BaseEN x6fcb9c1c812a0558, Boolean xed56185ad3c166ee) at CounterSoft.Gemini.DataProvider.x31cfc107e45a6f61.x9e0399ff71f99e7a(IssueResolutionEN x66541e88e82609d8) at CounterSoft.Gemini.Business.IssueWorkflow.DeleteIssueResolution(Int32 iResolutionID) at CounterSoft.Gemini.Presenter.AdminPresenter.DeleteIssueResolution(Int32 resolutionId) at CounterSoft.Gemini.Web.Methods.IssueResolutionHandler.Delete()

Followed by three times this error:

10505 19/01/2012 12:22:00 Error Gemini The DELETE statement conflicted with the REFERENCE constraint "geminiissuesissueresolutionidfk". The conflict occurred in database "EMIGemini", table "dbo.gemini_issues", column 'issueresolutionid'. The statement has been terminated. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) at NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) at NHibernate.Persister.Entity.AbstractEntityPersister.Delete(Object id, Object version, Int32 j, Object obj, SqlCommandInfo sql, ISessionImplementor session, Object[] loadedState)
The foreign key constraint gives a clear indication on the causes of this issue. There are still issue using the deprecated resolution. Our filter did not see them for two reasons:

  1. Issues in archived projects do not show up in the issue filter, even if All projects in the Project search field is selected; is there a way to changed the resolutions
  2. My account does cannot use a filter for resolution in the filter pane when opening the All issues page for a particular project. My global filter for all projects did not find any issues in this particular project; this seems reasonable, but is confusing.

Occurrences of cause 1. can be found by this query:

SELECT gemini_issues.issueid, gemini_issueresolutions.resolutionid, gemini_projects.projectname, gemini_issues.summary, gemini_issueresolutions.resdesc FROM gemini_issueresolutions INNER JOIN gemini_issues ON gemini_issueresolutions.resolutionid = gemini_issues.issueresolutionid INNER JOIN gemini_projects ON gemini_issues.projectid = gemini_projects.projectid WHERE gemini_issueresolutions.resolutionid = AND gemini_projects.projectarchived = 'Y'

So, basically the issue is just that a global filter for all projects does not find all issues in the system.

The same problem occurs for deprecated status items and possibly other system wide used issue attributes.


NiQuil
· 1
NiQuil