Description
This warning will occur when attempting to add a value to a field that is inappropriate for that value. For instance, a text value with a width of 10 cannot be merged into a field that has a width of 5. The record shown with this warning will be omitted from the output. This warning will also result from adding a null value to a field that does not support null values. The operation will continue, but the record provided in the message will be excluded from the output. Not all data types allow fields that support null values; for instance, shapefiles and dBASE tables do not, whereas geodatabase feature classes and tables do. Further, even when supported by the data format, null values can be restricted from a field by setting Allow Null Values to No when the field is created. An example of this message would occur when appending one dataset to another, where an input dataset had a field that supported nulls (and contained nulls) and was mapped to a field in the target dataset that did not support nulls.
Solution
Where possible, use field properties that are inclusive of any values that may potentially be added. For instance, when merging or appending datasets, make sure that the output field supports the largest of the text field widths. When dealing with nulls, the Preserve Nulls environment can be turned on or off to control whether nulls are preserved in the output. If turned off, the tool used will attempt to add null values to a field or format that will not accept them.
Note:
Field properties for the target dataset cannot be changed when using field mappings in the Append tool. Use the environment discussed above or change the field property prior to using the tool.