Can't Delete Issue Resolution
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 |
|
Friday, March 5, 2010, 6:02:43 PM |
0
|
Did you check that closed issues do not use this resultion? Please check Gemini's error log for errors |
||||
|
0
|
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. |
||||
|
0
|
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). |
||||
|
0
|
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. |
||||
|
0
|
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. |
||||
|
0
|
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? |
||||
|
0
|
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:
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. |
||||
|