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 a version on the 'Project Administration > Versions' page

web-app

I am attempting to delete a version from a project, and the delete function on the 'Project Administration > Versions' page pops up the confirmation, but then doesn't do the delete or respond with an error / information as to why, and doesn't refresh the list.

The version is empty (has not open or closed issues).

Should this function work, or am I possibly missing some aspect that will be stopping the delete?

I am using version 3.5.3 (build 2390).
mark.walker
· 1 		mark.walker
Friday, August 21, 2009, 2:02:05 AM
Replies (3)
helpful
0
not helpful

Do you see any error (exception) in the System Log? (Administration-> System Log)
Bikram
· 1 		Bikram
Friday, August 21, 2009, 8:34:20 AM
helpful
0
not helpful

Yes, there is a series of errors (see below).  It looks like it is due to the project having a version attribute configured.  I tried clearing it's value for this version in the hope that that would delete the version attribute record, but the error was the same.

I assume that the delete should be:

  1. Automatically deleting the associated version
  2. Reporting the failure to the user:
    • I would assume there are a series of issues that would stop a delete from happening (e.g. issues attached), and would expect a user friendly message informing me of why the delete didn't work.
    • Where an error like this one (I am assuming it is a bug) occurs I would expect a generic 'unexpected error' message to be shown.

 

could not delete: [CounterSoft.Gemini.Commons.VersionEN#201][SQL: DELETE FROM geminiversions WHERE versionid = ?] 24/08/2009 10:44:47 at CounterSoft.Gemini.DataProvider.x4fca630f50c44cdb.x362923a3eda00c5c(Int32 xa0800228d415ca96) at CounterSoft.Gemini.Business.x7d48fd170c4d1b4b.x362923a3eda00c5c(Int32 xa0800228d415ca96) at CounterSoft.Gemini.Web.Project.Admin.ProjectVersions.RepeaterCommand(Object sender, CommandEventArgs e) CounterSoft.Gemini.DataProvider The DELETE statement conflicted with the REFERENCE constraint "geminiprojectversionattributesvaluesversionidfk". The conflict occurred in database "gemini", table "dbo.geminiprojectversionattributevalues", column 'versionid'. The statement has been terminated. 24/08/2009 10:44:47 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.InternalExecuteNon .Net SqlClient Data Provider The DELETE statement conflicted with the REFERENCE constraint "geminiprojectversionattributesvaluesversionidfk". The conflict occurred in database "gemini", table "dbo.geminiprojectversionattributevalues", column 'versionid'. The statement has been terminated. 24/08/2009 10:44:47 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.InternalExecuteNon .Net SqlClient Data Provider The DELETE statement conflicted with the REFERENCE constraint "geminiprojectversionattributesvaluesversionidfk". The conflict occurred in database "gemini", table "dbo.geminiprojectversionattributevalues", column 'versionid'. The statement has been terminated. 24/08/2009 10:44:47 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.InternalExecuteNon .Net SqlClient Data Provider The DELETE statement conflicted with the REFERENCE constraint "geminiprojectversionattributesvaluesversionidfk". The conflict occurred in database "gemini", table "dbo.geminiprojectversionattributevalues", column 'versionid'. The statement has been terminated. 24/08/2009 10:44:47 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.InternalExecuteNon .Net SqlClient Data Provider The DELETE statement conflicted with the REFERENCE constraint "geminiprojectversionattributesvaluesversionidfk". The conflict occurred in database "gemini", table "dbo.geminiprojectversionattributevalues", column 'versionid'. The statement has been terminated. 24/08/2009 10:44:47 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.InternalExecuteNon .Net SqlClient Data Provider The DELETE statement conflicted with the REFERENCE constraint "geminiprojectversionattributesvaluesversionidfk". The conflict occurred in database "gemini", table "dbo.gemini_projectversionattributevalues", column 'versionid'. The statement has been terminated. 24/08/2009 10:44:47 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.InternalExecuteNon .Net SqlClient Data


mark.walker
· 1 		mark.walker
Monday, August 24, 2009, 2:52:08 AM
helpful
0
not helpful

This is fixed in 3.5.4, which is due out this week.

http://gemini.countersoft.com/Default.aspx?p=2&i=3047
Mark Wing
· 9108 		Mark Wing
Monday, August 24, 2009, 10:43:27 AM