Details

    • Type: Customer Defect
    • Status: In Regression (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2021R2
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      When trying to reprocess the messages in the on account sales error queue get the following error

      Title: On Account Sale Queue
      Timestamp: 5/27/2021 9:20:28 PM
      Message: Error occurred enqueuing transaction ID:9019743 for OnAccountSales processing - type OnAccountSales. Exception: NHibernate.Exceptions.GenericADOException: could not execute batch command.[SQL: SQL not available] ---> System.Data.SqlClient.SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_OnAccountSale". The conflict occurred in database "Chick-fil-a", table "dbo.tbOnAccountSale", column 'OnAccountSaleId'.
      The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_OnAccountSale". The conflict occurred in database "Chick-fil-a", table "dbo.tbOnAccountSale", column 'OnAccountSaleId'.
      The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_OnAccountSale". The conflict occurred in database "Chick-fil-a", table "dbo.tbOnAccountSale", column 'OnAccountSaleId'.
      The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_OnAccountSale". The conflict occurred in database "Chick-fil-a", table "dbo.tbOnAccountSale", column 'OnAccountSaleId'.
      The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_OnAccountSale". The conflict occurred in database "Chick-fil-a", table "dbo.tbOnAccountSale", column 'OnAccountSaleId'.
      The statement has been terminated.
      The statement has been terminated.
      The statement has been terminated.
      The statement has been terminated.
      The statement has been terminated.
      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
      at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
      at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
      at System.Data.SqlClient.SqlCommandSet.ExecuteNonQuery()
      at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps)
      — End of inner exception stack trace —
      at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps)
      at NHibernate.AdoNet.AbstractBatcher.ExecuteBatchWithTiming(IDbCommand ps)
      at NHibernate.AdoNet.AbstractBatcher.ExecuteBatch()
      at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)
      at NHibernate.Engine.ActionQueue.ExecuteActions()
      at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)
      at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)
      at NHibernate.Impl.SessionImpl.Flush()
      at NHibernate.Transaction.AdoTransaction.Commit()
      at Mx.Common.Data.BaseRepository`2.Save(TEntity entity)
      at Mx.CFA.Data.Repositories.CustomerRepository.Save(Customer entity)
      at Mx.CFA.Services.OnAccountSalesService.SaveCustomerWithTime(Customer entity, DateTime saveTimestamp)
      at Mx.Accounts.Services.OnAccountSalesServiceWrapper.SaveCustomer(OnAccountSalePolling onAccountSalePolling, Int32 retryCount)
      at Mx.Services.BaseSystem.Queues.OnAccountSalesMessage.PerformAction(Message message, ITaskController taskController)
      Activity Token: b2e002fb-bfd6-4e84-953a-2daee670b247
      Category: Mobile
      Priority: 30
      EventId: 2
      Severity: Error
      Machine: ATL2CFAAPPV001
      Application Domain: eStruxure Manager.exe
      Process Id: 7076
      Process Name: H:\Macromatix\ServerManager\Chick-fil-A - Instance 7\eStruxure Manager.exe
      Win32 Thread Id: 7132
      Information from Queue Tester


      I also saved off the error queue and attached it to this ticket.

        Attachments

        1. image-2021-05-27-17-26-56-824.png
          18 kB
          Cherlyn Thomas
        2. image-2021-05-27-17-28-25-324.png
          22 kB
          Cherlyn Thomas
        3. onaccountsales20210527.q
          3 kB
          Cherlyn Thomas

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                Cherlyn.Thomas Cherlyn Thomas
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.