Kbase P109085: SQL-92 query fails when reading a field, log file shows error message: Width of data is greater than
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/11/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 query fails when reading a field, log file shows error message: Width of data is greater than %s.%s.%s (rowid %X) _width.
Width of data is greater than %s.%s.%s (rowid %X) _width.
FACT(s) (Environment):
SQL-92 application is reading records.
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The data contained in the field is greater than the SQL_WIDTH.
FIX:
Increase the SQL_WIDTH of this field via the Data Dictionary or using dbtool:
The Data Dictionary maybe used in any 9 or 10 release of Progress by choosing:
Options > SQL Properties > Adjust Field Width.
dbtool was first introduce in 9.1D06. To run dbtool, do the following:
dbtool dbname
Then select option 2 SQL Width Scan w/Fix Option