TTDS7Loader - SqlServer - UniDAC 9.1.1 issues

[FredS]

There is a bug in TTDS7Loader.OQCOQCCCQ0 when using KeepIdentity in Direct mode.

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.

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.

[pavelpd]

Hey Fred,
Thanks for contacting Devart!

Unfortunately, we were not able to reproduce the behavior you described.

Please, compose and send us a sample application, with all the necessary DDL and DML scripts to create and populate database objects. As well as an example of data that is used to fill a table in SQL Server using the TUniLoader component.
You can send all the needed samples via the e-support form: https://www.devart.com/company/contactform.html