Bug - Deleting Stories

[Joe]

Symptom - When deleting a story, the story disappears from the grid but a pop-up displays saying "TeamPulse has encountered an issue"

Steps to reproduce

1. Click the "Story Management" tab (works as expected)
2. Click on a story to highlight it (works as expected)
3. Click the "Delete Story" icon (story disappears as expected)
4. Error message appears 
5. If you exit TeamPluse and return, all stories are present

 

Ability to reproduce - Every time

Error Message

Exception Type: System.Data.Services.Client.DataServiceRequestException
Exception Message: An error occurred while processing this request.
   at System.Data.Services.Client.DataServiceContext.SaveResult.HandleBatchResponse()
   at System.Data.Services.Client.DataServiceContext.SaveResult.EndRequest()
   at System.Data.Services.Client.DataServiceContext.EndSaveChanges(IAsyncResult asyncResult)
   at Titan.Client.Managers.ProjectManager.<>c__DisplayClass1a5.<>c__DisplayClass1a7.<SaveProject>b__1a1()
(Inner Exception)
Exception Type: System.Data.Services.Client.DataServiceClientException
Exception Message: <?xml version="1.0" encoding="utf-8" standalone="yes"?>
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
  <code></code>
  <message xml:lang="en-US">An error occurred while processing this request.</message>
  <innererror>
    <message>The DELETE statement conflicted with the REFERENCE constraint "FK_StoryRichDescription_Story". The conflict occurred in database "TeamPulse", table "dbo.StoryRichDescription", column 'StoryID'.&#xD;
The statement has been terminated.</message>
    <type>System.Data.SqlClient.SqlException</type>
    <stacktrace>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)&#xD;
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)&#xD;
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()&#xD;
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)&#xD;
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)&#xD;
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)&#xD;
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)&#xD;
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)&#xD;
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()&#xD;
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)&#xD;
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)&#xD;
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)&#xD;
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicDelete(TrackedObject item)&#xD;
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.Delete(TrackedObject item)&#xD;
   at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)&#xD;
   at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)&#xD;
   at Titan.Core.TitanDataContext.SaveChanges()&#xD;
   at System.Data.Services.DataService`1.BatchDataService.HandleBatchContent(Stream responseStream)</stacktrace>
  </innererror>
</error>
   at System.Data.Services.Client.DataServiceContext.SaveResult.<HandleBatchResponse>d__1e.MoveNext()
Exception Type: System.Data.Services.Client.DataServiceRequestException
Exception Message: An error occurred while processing this request.
   at System.Data.Services.Client.DataServiceContext.SaveResult.HandleBatchResponse()
   at System.Data.Services.Client.DataServiceContext.SaveResult.EndRequest()
   at System.Data.Services.Client.DataServiceContext.EndSaveChanges(IAsyncResult asyncResult)
   at Titan.Client.Managers.ProjectManager.<>c__DisplayClass1a5.<>c__DisplayClass1a7.<SaveProject>b__1a1()
(Inner Exception)
Exception Type: System.Data.Services.Client.DataServiceClientException
Exception Message: <?xml version="1.0" encoding="utf-8" standalone="yes"?>
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
  <code></code>
  <message xml:lang="en-US">An error occurred while processing this request.</message>
  <innererror>
    <message>The DELETE statement conflicted with the REFERENCE constraint "FK_StoryRichDescription_Story". The conflict occurred in database "TeamPulse", table "dbo.StoryRichDescription", column 'StoryID'.&#xD;
The statement has been terminated.</message>
    <type>System.Data.SqlClient.SqlException</type>
    <stacktrace>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)&#xD;
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)&#xD;
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()&#xD;
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)&#xD;
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)&#xD;
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)&#xD;
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)&#xD;
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)&#xD;
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()&#xD;
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)&#xD;
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)&#xD;
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)&#xD;
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicDelete(TrackedObject item)&#xD;
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.Delete(TrackedObject item)&#xD;
   at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)&#xD;
   at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)&#xD;
   at Titan.Core.TitanDataContext.SaveChanges()&#xD;
   at System.Data.Services.DataService`1.BatchDataService.HandleBatchContent(Stream responseStream)</stacktrace>
  </innererror>
</error>
   at System.Data.Services.Client.DataServiceContext.SaveResult.<HandleBatchResponse>d__1e.MoveNext()

Thanks,
Joe

Thanks,
Joe

[Sebastian Talamoni]

+1 to this bug.

I got the same error today.

It looks like that happens only when you type in the RTF description.

Notice the FK_StoryRichDescription_Story.

 <message>The DELETE statement conflicted with the REFERENCE constraint "FK_StoryRichDescription_Story". The conflict occurred in database "TeamPulse", table "dbo.StoryRichDescription", column 'StoryID'.&#xD;

The statement has been terminated.</message>

[David Harris]

Hi Sebastian & Joe,

Thank you for submitting this issue, we have logged it internally and will look to eliminating it.

Best wishes,
David Harris
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.