Error Saving My Work Customise
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 |
|
Friday, May 23, 2008, 9:14:09 PM |