Salesforce

Character string is too long (8184) when SQL-WIDTH / MAX-WIDTH is smaller than field being updated

« Go Back

Information

 
TitleCharacter string is too long (8184) when SQL-WIDTH / MAX-WIDTH is smaller than field being updated
URL NameP35172
Article Number000140998
EnvironmentProduct: Progress
Version: 9.1x
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
Error (8184) when inserting records from an ODBC client.
 
Steps to Reproduce
Clarifying Information
In the context of Data Definition (.DF) files, SQL-WIDTH and MAX-WIDTH are the same.
SQL-WIDTH is used in Progress 9.x .DF files;
MAX-WIDTH is used in OpenEdge 10.x onward .DF files.
Error Message[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Character string is too long (8184) (-20152)
Conversion failed because the data value overflowed the data type used by the provider.
Defect Number
Enhancement Number
Cause
The data contained in the field is greater than the SQL-WIDTH / MAX-WIDTH.
Resolution
Increase the SQL-WIDTH / MAX-WIDTH of this field either:

A. The Data Dictionary.

In a Character (CHUI) Data Dictionary session:

1.  Choose menu Schema > Adjust Field Width.
2.  Select the appropriate table and then modify the Width of the field that needs to be changed.
3.  Select the Save button, then the OK button.
4.  Select Apply Changes.

Within a Graphical (GUI) Data Dictionary session:

1.  Select the appropriate table from the Tables list.
2.  Choose menu Options > SQL Properties > Adjust Field Width.
3.  Click into the Width column of the field that needs to be changed, then change the value.
4.  Click the Save button, then the OK button.
5.  Choose menu Edit > Commit Transaction and click the Yes button to commit the changes.

B. DBTOOL

Since Progress 9.1D06, the DBTOOL utility can be used to report and fix SQL Width alignment. Refer to Article 000020119 for further detail.
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:21 AM

Powered by