SQL query fails when column value exceeds SQL max length or precision

SQL query fails due to: column <> in table <> has value exceeding SQL max length or precision.

Error 210012 occurs regardless of whether client connects via JDBC or ODBC.

SQL query does not affect all records in the table.

SQL query succeeds when the field listed in the 210012 error message is excluded. 

When the Max Width of a field exceeds the SQL Width value then this SQL queries cannot read field data:

• SQL-Width is the current SQL Width for the field listed.
• Max-Width represents the size of the longest data entry in the field. 

To address column width discrepancies differences in SQL-Width and Max Width need to be addressed:

1. Before adjusting the current sql-width in the database schema, consider dumping the record to a text file to check the field content. To find the rowid refer to Article  How to detect fields with problematic SQL-WIDTH with 4GL/ABL   
2. Progress 9.1D05 and earlier, refer to the code examples in Articles:

3. Progress 9.1D06, 9.1E, the DBTOOL utility is provided to identify and fix SQL width violations of character and decimal data, as well as identify data values incompatible with SQL-92. DBTOOL with Option 2 (SQL Width Scan w/Fix Option) will report and fix the SQL Width based on the current Max-width found. Refer to Article  What is DBTOOL?   The SQL-WIDTH update will fail due to the 32K bytes field limit on the ABL character type, refer to Article DBTOOL SQL WIDTH crashes with "Unable to upgrade record"
4. OpenEdge 11.5.1 onward, OpenEdge SQL allows the Authorized Data Truncation (ADT) feature to be enabled at the database or client session so that the selected data fits the defined column size and the part of the value larger than the defined size of the column is truncated.  In OpenEdge 11.6 this feature was further enhanced to dynamically update the SQL Width post query execution with the Autonomous Schema Update (ASU) database feature. Refer to Article  Where to enable the -SQLTruncateTooLarge and -SQLWidthUpdate features  

 

Progress Article(s):

Are SQL width and Max width the same in the dbtool output?   
SQL: Error: "Column _Field-map in table PUB._File has value exceeding its max length or precision".  

This article has been merged with article Executing an SQL statement fails with the error "value exceeding its max length or precision".