Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JSWCLOUD-16640

Error Message Updating WSP on Compliance Suite

XMLWordPrintable

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      When Jodi from Douglas Scott Securities is trying to update her WSP and goes to click Save, to save changes, she is receiving an error message (I do believe this error message is similar to the one Kevin Rowe received when updating WSP's for Austin Atlantic)

      The error message she receives is below:

      Server Error in '/' Application.

      Violation of PRIMARY KEY constraint 'PK_dbo.DocumentChange'. Cannot insert duplicate key in object 'dbo.DocumentChange'. The duplicate key value is (3245c1b7-eef7-e411-80fa-0018fe7374b8, 10). The statement has been terminated.

      Description: 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. Exception Details: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_dbo.DocumentChange'. Cannot insert duplicate key in object 'dbo.DocumentChange'. The duplicate key value is (3245c1b7-eef7-e411-80fa-0018fe7374b8, 10). The statement has been terminated. Source Error:

      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.

      Stack Trace:

       
      [SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_dbo.DocumentChange'. Cannot insert duplicate key in object 'dbo.DocumentChange'. The duplicate key value is (3245c1b7-eef7-e411-80fa-0018fe7374b8, 10).
      The statement has been terminated.]
         System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3180300
         System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +332
         System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4224
         System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) +476
         System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) +221
         System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, String endMethod, Boolean isInternal) +863
         System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult) +278
         System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult) +170
         System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) +56
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         System.Data.Entity.Core.Mapping.Update.Internal.<ExecuteAsync>d__0.MoveNext() +2595
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         System.Data.Entity.Core.Mapping.Update.Internal.<UpdateAsync>d__0.MoveNext() +564
       
      [UpdateException: An error occurred while updating the entries. See the inner exception for details.]
         System.Data.Entity.Core.Mapping.Update.Internal.<UpdateAsync>d__0.MoveNext() +952
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         System.Data.Entity.Core.Objects.<ExecuteInTransactionAsync>d__3d`1.MoveNext() +955
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         System.Data.Entity.Core.Objects.<SaveChangesToStoreAsync>d__39.MoveNext() +556
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         System.Data.Entity.SqlServer.<ExecuteAsyncImplementation>d__9`1.MoveNext() +486
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         System.Data.Entity.Core.Objects.<SaveChangesInternalAsync>d__31.MoveNext() +888
       
      [DbUpdateException: An error occurred while updating the entries. See the inner exception for details.]
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         Compliance.Data.Repositories.<UpdateSectionAsync>d__22.MoveNext() +2310
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         Compliance.Web.Controllers.<EditSection>d_28.MoveNext() +621
         System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +31
         System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +60
         System.Web.Mvc.Async.TaskAsyncActionDescriptor.EndExecute(IAsyncResult asyncResult) +92
         System.Web.Mvc.Async.<>c_DisplayClass37.<BeginInvokeAsynchronousActionMethod>b_36(IAsyncResult asyncResult) +22
         System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
         System.Web.Mvc.Async.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d() +72
         System.Web.Mvc.Async.<>c_DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b_3f() +385
         System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +42
         System.Web.Mvc.Async.<>c_DisplayClass2b.<BeginInvokeAction>b_1c() +38
         System.Web.Mvc.Async.<>c_DisplayClass21.<BeginInvokeAction>b_1e(IAsyncResult asyncResult) +185
         System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
         System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +29
         System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +70
         System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
         System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +36
         System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
         System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState) +43
         System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +70
         System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
         System.Web.CallHandlerExecutionStep.InvokeEndHandler(IAsyncResult ar) +212
         System.Web.CallHandlerExecutionStep.OnAsyncHandlerCompletion(IAsyncResult ar) +166
       
       
       

            [JSWCLOUD-16640] Error Message Updating WSP on Compliance Suite

            Mike Howells made changes -
            Workflow Original: JAC Suggestion Workflow JSWCLOUD [ 4102306 ] New: JAC Suggestion Workflow 3 [ 4368706 ]
            Matthew Hunter made changes -
            Labels Original: timeout-suggestion-bulk-close202104 New: timeout-suggestion-bulk-close timeout-suggestion-bulk-close202104
            Owen made changes -
            Workflow Original: JAC Suggestion Workflow 3 [ 3697593 ] New: JAC Suggestion Workflow JSWCLOUD [ 4102306 ]
            Matthew Hunter made changes -
            Resolution New: Won't Fix [ 2 ]
            Status Original: Gathering Interest [ 11772 ] New: Closed [ 6 ]
            Matthew Hunter made changes -
            Labels New: timeout-suggestion-bulk-close202104
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3464927 ] New: JAC Suggestion Workflow 3 [ 3697593 ]
            Monique Khairuliana (Inactive) made changes -
            Workflow Original: JIRA PM Feature Request Workflow v2 - TEMP [ 2629797 ] New: JAC Suggestion Workflow [ 3464927 ]
            Status Original: Open [ 1 ] New: Gathering Interest [ 11772 ]
            Allison Rail created issue -

              Unassigned Unassigned
              af471b93e18c Allison Rail
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: