-
Type: Customer Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Closed/Resolved by Caller
-
Affects Version/s: CFA 2020R1
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Forecast Import FAILED store : 00782 Day : 06-21-2020 : The server failed to resume the transaction. Desc:c200000229.
The transaction active in this session has been committed or aborted by another session. 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 Mx.Data.AuditDataImportData.qryMMSAuditDataImport_Insert(Int64 auditID, Int64 recordNumber, Int16 dataImportTypeID, Int16 dataImportEventTypeID, Int16 dataImportOperationID, String auditDetails, Int16 importType, Int64& auditDataImportID, SqlTransaction transaction, Int32 timeoutValue, Boolean fillPrimaryKey)
at Mx.Services.AuditDataImportService.InsertAuditDataItem(AuditDataImport auditDataImport, SqlTransaction transaction)
at Mx.Services.ImportService.LogEvent(String message, String ImportReference, ImportEvent eventType, List`1 processLog, ImportLoggingLevel loggingLevel, ITaskController taskController, AuditDataImport auditDataImport, AuditDataImportList auditLog, ImportLoggingLevel msgLogLevel, String auditLogFilePath)
at Mx.Services.ImportService.LogEvent(MxEvent mxEvent, String importReference, List`1 processLog, ImportLoggingLevel loggingLevel, ITaskController taskController, Int64 auditId, Int64 rowNumber, DataImportType dataImportType, ImportOperation dataImportOperation, AuditDataImportList auditLog, ImportLoggingLevel msgLogLevel, String auditLogFilePath)
at Mx.Services.ImportService.ImportRecord(IImportProvider provider, IImportable record, ImportRecordArgs args, String auditLogFilePath, Boolean trackSuccessfulImports)
at Mx.Services.TaskWebServiceClient.Import(Int32 entityId, IImportProvider provider, IImportable record, ImportRecordArgs args, DataImportTask forecastImportTask, String auditlogFilePath, ForecastWithVersion forecast)
at Mx.Services.TaskWebServiceClient.ImportForecast(Int32 entityId, String storeNumber, ForecastWithVersion forecast)
- blocks
-
CFAMX-11540 Production Defects
- Open