29-04-2018 10:21:50: Failed to recalculate. System.InvalidOperationException: The transaction is either not associated with the current connection or has been completed. at System.Data.SqlClient.SqlBulkCopy.CreateOrValidateConnection(String method) at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken) at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at InherentSimplicity.DataAccess.DassBulkCopy.BulkInsert(IDataReader reader, BulkCopySettings settings) at InherentSimplicity.DataAccess.InvCoverage.DassInvCoverage.saveDataForSkusNewWeek(IEnumerator enumartorStores, Boolean isSku, SqlConnection conn, SqlTransaction trans, Nullable`1 partitionID, String SalePartitionFunctionName, String TempSalePartitionFunctionName, String MTSPartitionFunctionName, String HPartitionFunctionName) at InherentSimplicity.Module1.Coverage.InvCoverageCalculator.saveStoreData(DateTime weekEnd, SqlConnection conn, SqlTransaction trans, Boolean saveLastCalcDate, Nullable`1 partitionID) at InherentSimplicity.Module1.Coverage.InvCoverageManager.doCalcualate(DateTime weekEnd, SqlConnection conn, SqlTransaction trans, Boolean initialCase, Boolean lastRound) at InherentSimplicity.Module1.Coverage.InvCoverageManager.calcualate(SqlConnection conn, SqlTransaction trans) at InherentSimplicity.Module1.Recalculation.calcualteInventoryCovarage(SqlConnection conn, SqlTransaction trans) at InherentSimplicity.Module1.Recalculation.recalculateAll(Boolean afterLoadFile) at InherentSimplicity.Module1.SymphonyInitApplication.recalculate(String dbName, Boolean isConnectionOpen, String& resultStr, Nullable`1 ActionSource, Boolean forceDplm) 29-04-2018 10:21:50: loadFiles general exception: The transaction is either not associated with the current connection or has been completed. 29-04-2018 10:21:50: System.InvalidOperationException: The transaction is either not associated with the current connection or has been completed. at System.Data.SqlClient.SqlBulkCopy.CreateOrValidateConnection(String method) at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken) at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at InherentSimplicity.DataAccess.DassBulkCopy.BulkInsert(IDataReader reader, BulkCopySettings settings) at InherentSimplicity.DataAccess.InvCoverage.DassInvCoverage.saveDataForSkusNewWeek(IEnumerator enumartorStores, Boolean isSku, SqlConnection conn, SqlTransaction trans, Nullable`1 partitionID, String SalePartitionFunctionName, String TempSalePartitionFunctionName, String MTSPartitionFunctionName, String HPartitionFunctionName) at InherentSimplicity.Module1.Coverage.InvCoverageCalculator.saveStoreData(DateTime weekEnd, SqlConnection conn, SqlTransaction trans, Boolean saveLastCalcDate, Nullable`1 partitionID) at InherentSimplicity.Module1.Coverage.InvCoverageManager.doCalcualate(DateTime weekEnd, SqlConnection conn, SqlTransaction trans, Boolean initialCase, Boolean lastRound) at InherentSimplicity.Module1.Coverage.InvCoverageManager.calcualate(SqlConnection conn, SqlTransaction trans) at InherentSimplicity.Module1.Recalculation.calcualteInventoryCovarage(SqlConnection conn, SqlTransaction trans) at InherentSimplicity.Module1.Recalculation.recalculateAll(Boolean afterLoadFile) at InherentSimplicity.Module1.SymphonyInitApplication.recalculate(String dbName, Boolean isConnectionOpen, String& resultStr, Nullable`1 ActionSource, Boolean forceDplm) at InherentSimplicity.Module1.SymphonyInitApplication.recalculate(String DBName, Boolean isConnectionOpen, String& resultStr, Boolean forceDplm) at InherentSimplicity.Module1.SymphonyInitApplication.loadFiles(String dbName, Nullable`1 ActionSource, Boolean sExportCustomReport, Boolean sEmailCustomReports, Boolean autoloadOn, Boolean forceDplm) 29-04-2018 10:21:50: ------------------------------------ 29-04-2018 10:21:50: --> Rollback 29-04-2018 10:21:50: Failed to rollback transactionThis SqlTransaction has completed; it is no longer usable.