Column Origin in Table has Value Exceeding its Max Length or Precision

Problem

The problem arises when you try to export the data, that is longer than the SQL-WIDTH specified for the column, using the ODBC connection.

Solution

You can fix the issue manually by changing the value of SQL-WIDTH parameter using the PROGRESS Data Administration tool.
To do this, please follow the steps below:

1. In the Data Administration, please select the name of the database and the name of the table. Then please select Options → SQL Properties → Adjust Field Width, as specified in the picture below:

2. In the opened window please choose the column which length should be changed and change the value in the field Width:

The Width value must correspond to the data length stored in the column in the table, otherwise the issue will raise again and you'll have to change the value one more time.

SQLWays Migration Product Page Free Evaluation