Hello. With our first replication package tests (QBO to SQL Server) we are receiving two sets of errors:
1. String or binary data would be truncated.
BTW it would be rather helpful if the log noted which field caused the error.
In this case the error is because Skyvia creates the EntityRefName field with a length of 100 chars, but our data occasionally exceeds this.
2. Violation of UNIQUE KEY constraint 'xxx_Customer_1'. Cannot insert duplicate key in object...
In this case Skyvia is, strangely, creating an additional unique key constraint on the destination Customer table, on the field DisplayName. This makes no sense as there already is a unique key constraint on the Id field, like with all tables.
For whatever reason our accountants create multiple customers with different fully qualified names but the same display name. Like "UNB" for the display name several times for different customers.
Are these issues that can be addressed?