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.




Personal Filter, causes exception when trying to delete existing or save new.

web-app

Note: We just upgraded from version 3.1. to 3.6

When trying to save personal filters we get an exception:

The INSERT statement conflicted with the FOREIGN KEY constraint "geminipersonalfiltersprojectidfk". The conflict occurred in database "btrak2", table "dbo.geminiprojects", column 'projectid'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Id.IdentityGenerator.InsertSelectDelegate.ExecuteAndExtract(IDbCommand insert, ISessionImplementor session) at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)

Please advise. thanks!
mumbles
· 1 		mumbles
Wednesday, February 10, 2010, 4:35:27 PM
Replies (3)
helpful
0
not helpful

Does it happen for all projects?
What is the error when you delete a filter?
Mark Wing
· 9108 		Mark Wing
Wednesday, February 10, 2010, 5:02:38 PM
helpful
0
not helpful

Yeah, it happens in all project. Nothing happens in GUI. I see this when i go into the log.
mumbles
· 1 		mumbles
Friday, February 12, 2010, 12:24:17 AM
helpful
0
not helpful

Are you able to run SQL Profiler to see the offending SQL?
If not, please send a zipped backup of you database to support at countersoft dot com
Mark Wing
· 9108 		Mark Wing
Friday, February 12, 2010, 9:52:56 AM