Live to PIT SQL transfer fails
We have been testing the latest code release and we are unable to do a Live to PIT transfer between spaces.
- PIT -> PIT transfer works
- Live -> Live transfer works
- Direct import PIT works
- Direct import Live works
It is only Live to PIT TRANSFER between dataspaces that fails with the following error logged:
2021-03-24 12:43:10,859|[98]|disseminate|24|WARN |{...}|dotstatsuite-core-transfer|DotStatServices.Transfer.Controllers.TransferController+<>c__DisplayClass9_0+<b__0>d.MoveNext|The processing of observations was stopped and dropped due to one or more errors. Please read the details of the error(s) to see how to resolve it/them.||(null)|(null)|(null)|
2021-03-24 12:43:10,859|[98]|disseminate|24|ERROR|{...}|dotstatsuite-core-transfer|DotStatServices.Transfer.Controllers.TransferController+<>c__DisplayClass9_0+<b__0>d.MoveNext|Invalid attempt to read when no data is present.|System.InvalidOperationException: Invalid attempt to read when no data is present. at System.Data.SqlClient.SqlDataReader.CheckDataIsReady(Int32 columnIndex, Boolean allowPartiallyReadColumn, Boolean permitAsync, String methodName) at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn) at System.Data.SqlClient.SqlDataReader.GetFieldValueInternalT at System.Data.SqlClient.SqlDataReader.GetFieldValueT at System.Data.DataReaderExtensions.GetFieldValueT at DotStat.Db.Repository.SqlServer.SqlDataStoreRepository.MergeStagingToFactData(Dsd dsd, DbTableVersion tableVersion) at DotStat.Transfer.Consumer.SqlConsumer.Save(ITransferParam transferParam, Dataflow dataflow, TransferContent transferContent, IManagementRepository mgmtRepository, ITransactionRepository transRepository, IDataStoreRepository dataStoreRepository, ISqlDatasetAttributeDatabaseValidator datasetAttributeDatabaseValidator, IDatasetAttributeValidator datasetAttributeValidator, ICodeTranslator codeTranslator) in {...}\DotStat.Transfer\Consumer\SqlConsumer.cs:line 253 at DotStat.Transfer.Consumer.SqlConsumer.Save(ITransferParam transferParam, Dataflow dataflow, TransferContent transferContent) in {...}\DotStat.Transfer\Consumer\SqlConsumer.cs:line 75 at DotStat.Transfer.Manager.SqlToSqlTransferManager.Transfer(SqlToSqlTransferParam transferParam) in {...}\DotStat.Transfer\Manager\SqlToSqlTransferManager.cs:line 57 at DotStatServices.Transfer.Controllers.TransferController.<>c__DisplayClass9_0.<b__0>d.MoveNext() in {...}\DotStatServices.Transfer\Controllers\TransferController.cs:line 200 |(null)|(null)|(null)|
Running the Latest released code and on a fresh DB install (SQL server 2019)transactionLog.txt