Error inserting records on publish

Error 2740 while inserting records into the APS Database table because the given value of type String from the data source cannot be converted due to illegal character

If an error similar to what is below occurs during a publish, it is usually due to an illegal character in a field being published.

....... START ENTRY 2/6/2020 11:56:11 AM PT Version=11.34.2 PT Serialization Version=714 .......

ERROR 2740:
Error while inserting records into the APS Database in table: Jobs. The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.
String or binary data would be truncated.
The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.
String or binary data would be truncated.

The resolution would be to click the Brows Publish data and review the table indicated in the error message (usually these issues are in User Defined Fields, but could be found elsewhere):