Gemini Version : 3.1 (build 2179)

On the report all issues page (/gemini/Issues.aspx) when a logged in users attempts to use the "Customise"  feature to add additonal columns to the issues list some times the custom fields are not found within the list.

If the items are listed ( sometimes they are and other times they are not) and the user adds the items to "Selected Issues Properties" and then clicks "Save" the Issues page is reload without the added fields. (some times there is an error, see message below) But if the user clicks on the "Excel" or "Printer Friendly" links the fields are shown on the new window or in the Excel spreadsheet.

If the user selects a specific project instead of the "All Projects" or project group then the issues list shows the custom fields.

Error Message

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'geminiuserissuesviewsprojectidfk'. The conflict occurred in database 'GEMINI', table 'geminiprojects', column 'projectid'. The statement has been terminated. 1/14/2009 6:02:06 PM 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 .Net SqlClient Data Provider