CounterSoft User Forums

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)

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

Please check Gemini's error log for errors

---

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.

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).

---

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.

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

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

and

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

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?

---