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.




Error Saving My Work Customise

web-app

I am getting an error when I hit the save button on the My Work View page.  You get here by clicking the Customise link from the My Work page.  I have just upgraded from 2.2.6, and everything else seems to be working correctly.  I had to resolve a few other upgrade issues here and there.  The forums here were quite helpful, but I haven't seen anything for this issue.

Thanks!

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'geminiuserissuesviewsprojectidfk'. The conflict occurred in database 'Gemini', table 'geminiprojects', column 'projectid'.
The statement has been terminated.

        <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

        <b> Description: </b>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.

        <b> Exception Details: </b>System.Data.SqlClient.SqlException:

INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'geminiuserissuesviewsprojectidfk'. The conflict occurred in database 'Gemini', table 'geminiprojects', column 'projectid'.
The statement has been terminated.

        <b>Source Error:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code>

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.

              </td>
           </tr>
        </tbody></table>

        <br>

        <b>Stack Trace:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code></code><pre>[SqlException (0x80131904): INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'gemini_userissuesviews_projectid_fk'. The conflict occurred in database 'Gemini', table 'gemini_projects', column 'projectid'.<br>The statement has been terminated.]<br>   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466<br>   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118<br>   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186<br>   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932<br>   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31<br>   System.Data.SqlClient.SqlDataReader.get_MetaData() +62<br>   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297<br>   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005<br>   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132<br>   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32<br>   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122<br>   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12<br>   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +9<br>   NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) +32<br>   NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) +387<br><br>[ADOException: could not insert: [CounterSoft.Gemini.Commons.UserIssueViewItemEN][SQL: INSERT INTO gemini_userissuesviews (UserID, projectid, issueattribute, customfieldid, displayorder) VALUES (?, ?, ?, ?, ?)]]<br>   NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) +890<br>   NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) +223<br>   NHibernate.Impl.ScheduledIdentityInsertion.Execute() +33<br>   NHibernate.Impl.SessionImpl.Execute(IExecutable executable) +112<br>   NHibernate.Impl.SessionImpl.DoSave(Object theObj, EntityKey key, IEntityPersister persister, Boolean replicate, Boolean useIdentityColumn, CascadingAction cascadeAction, Object anything) +759<br>   NHibernate.Impl.SessionImpl.DoSave(Object obj, Object id, IEntityPersister persister, Boolean useIdentityColumn, CascadingAction cascadeAction, Object anything) +443<br>   NHibernate.Impl.SessionImpl.SaveWithGeneratedIdentifier(Object obj, CascadingAction action, Object anything) +349<br>   NHibernate.Impl.SessionImpl.Save(Object obj) +140<br>   CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9, ISession x45b53be31e53d68b) +12<br>   CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9) +57<br>   CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558) +6<br>   CounterSoft.Gemini.DataProvider.xcaaeca374ab161a3.xdd990f782af5867c(UserIssueViewItemEN x11fb7c37ef79f78a) +4<br>   CounterSoft.Gemini.Business.xdb5078500e706012.x99b870f84d13a813(Int32 xdf6548ad179b4d83, ArrayList x5ff06ff8f58c78e8) +117<br>   CounterSoft.Gemini.WorkloadView.btnUpdate_Click(Object sender, EventArgs e) +186<br>   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105<br>   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107<br>   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7<br>   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11<br>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33<br>   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746<br></pre></td></tr></tbody></table></font>
thebizrock
· 1
thebizrock
Replies (2)
helpful
0
not helpful

Thanks, this is a known issue and is fixed in 3.0.1, out next week.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Great!  Thanks for the help.


thebizrock
· 1
thebizrock