Dear all,

At the moment we are using Gemini version v3.6.5 Build 2638 on a windows 2003 r2 server with MSSQL 2005 express edition. This edition was after a upgrade from v3.1.2 Build 2257 on a Windows 2000 server with mssql 2000.

A user complains about not able to edit or add a filter. When he wants to do this he got the following server error:

Server Error in '/' Application.

The UPDATE statement conflicted with the FOREIGN KEY constraint "geminipersonalfiltersprojectidfk". The conflict occurred in database "gemini", table "dbo.geminiprojects", column 'projectid'. The statement has been terminated. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint "geminipersonalfiltersprojectidfk". The conflict occurred in database "gemini", table "dbo.geminiprojects", column 'projectid'. The statement has been terminated.

Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): The UPDATE statement conflicted with the FOREIGN KEY constraint "geminipersonalfiltersprojectidfk". The conflict occurred in database "gemini", table "dbo.geminiprojects", column 'projectid'. The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137 NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) +224 NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) +17 NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) +973

[GenericADOException: could not update: [CounterSoft.Gemini.Commons.Entity.IssuesFilterEN#36][SQL: UPDATE gemini_personalfilters SET filtername = ?, userid = ?, projectid = ?, components = ?, versions = ?, affectedversions = ?, resources = ?, issuetypes = ?, issuepriorities = ?, issueseverity = ?, issuestatuses = ?, issueresolutions = ?, risklevels = ?, keywords = ?, excludeclosed = ?, systemfilter = ?, issueids = ?, sortfield = ?, sortdirection = ?, reportedbyuserid = ?, createdafter = ?, createdbefore = ?, revisedafter = ?, revisedbefore = ?, projectids = ?, startdate = ?, duedate = ?, initialstartdate = ?, finalstartdate = ?, initialduedate = ?, finalduedate = ?, customfieldvalues = ?, savedfromreports = ? WHERE filterid = ?]] CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.x097cc82acf165ae9(BaseEN x6fcb9c1c812a0558) +72 CounterSoft.Gemini.DataProvider.xc0186e148e957052.x482a4f894c689780(IssuesFilterEN xb0f684c47236959a) +10 CounterSoft.Gemini.Business.x95da312ae9372c2e.x482a4f894c689780(IssuesFilterEN xb0f684c47236959a) +15 CounterSoft.Gemini.Web.Controls.IssuesFilterControl.UpdateFilter(Object sender, EventArgs e) +589 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +108 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +118 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618

On the webserver I see the same error in the event viewer. Furthermore I see that the table exists in the database.

Do you have any idea what can be the problem? Thanks in advance.