Product: | Syniti Data Replication, DBMoto |
Version: | All |
ID: | 1462 |
Summary: | Errors: “Numeric value overflow” and “Field too small to paste the amount of data” occur when target fields are too small |
Q.
Why am I getting these errors: “Numeric Value Overflow”, or “Field too small to paste the amount of data”?
A.
These errors appear when the target field is of a data type 'smaller' than the source field.
Before starting data replication, verify that the fields in the target table are big enough to receive the source data.
This can happen even if you are using the Syniti DR/DBMoto Table Generator. The Create Target Table Wizard recommends which fields to create in the target table, but you should check the relative sizes of the source and target fields.