TTDS7Loader - SqlServer - UniDAC 9.1.1 issues
Posted: Sun 22 May 2022 23:16
There is a bug in TTDS7Loader.OQCOQCCCQ0 when using KeepIdentity in Direct mode.
With that resolved there was another issue which threw obscure errors:
Different Desc depend on server versions and platforms..
After some hacking this turned out to be a volume issue. While the same and larger volume of data has none of these issues using MSOLEDB..
Reducing the RowsPerBatch solves this, while altering KilobytesPerBatch had no effect at all, even if set below the rows equivalent.
Curious that I had to reduce Rows=50, yet while using MSOLEDB all 1014 go through without issues.
With that resolved there was another issue which threw obscure errors:
Code: Select all
EUniError: The server failed to resume the transaction.
Desc:3400000003.
Desc:3400000002.
After some hacking this turned out to be a volume issue. While the same and larger volume of data has none of these issues using MSOLEDB..
Reducing the RowsPerBatch solves this, while altering KilobytesPerBatch had no effect at all, even if set below the rows equivalent.
Curious that I had to reduce Rows=50, yet while using MSOLEDB all 1014 go through without issues.