|Product:||Syniti Data Replication, DBMoto|
|Summary:||The Syniti DR/DBMoto log does not report errors when strings on the target table are truncated unless the field is a Primary Key|
Why doesn’t an error appear in the log file when strings on the target table are truncated?
If a string is too long for a target string field, Syniti DR/DBMoto may not write an error to the log, depending on the .NET provider/OLEDB provider/ODBC driver behavior.
However, if the field is a Primary Key field, one or both of the following errors will appear in the log:
“Error Record to be updated not found! A new record will be added”
“Error Record to be deleted not found! The cancellation request will be ignored”
To correct the problem, change the size of the target field to fit the amount of data.