-
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
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.
- blocks
-
CFAMX-11540 Production Defects
- Open