Bug - Deleting Stories

3 posts, 0 answers
  1. Joe
    Joe avatar
    51 posts
    Member since:
    Oct 2008

    Posted 21 Apr 2010 Link to this post

    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

  2. Sebastian Talamoni
    Sebastian Talamoni avatar
    32 posts
    Member since:
    Mar 2008

    Posted 22 Apr 2010 Link to this post

    +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>
  3. David Harris
    Admin
    David Harris avatar
    1 posts

    Posted 22 Apr 2010 Link to this post

    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.
Back to Top