Kbase P131482: SQL: Error: "Column _Field-map in table PUB._File has value exceeding its max length or precision".
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/30/2008 |
|
Status: Verified
SYMPTOM(s):
SQL: Error: "Column _Field-map in table PUB._File has value exceeding its max length or precision".
ERROR [HY000] [DataDirect][ODBC PROGRESS driver][PROGRESS]Column _Field-map in table PUB._File has value exceeding its max length or precision.
Executing the SQL statement:
SELECT * FROM PUB."_File".
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
In a Progress 9.x database, the default size of the SQL-WIDTH attribute of the _File._Field-map field is 232. In an OpenEdge 10.x, the default size of the MAX-WIDTH attribute of the _File._Field-map field is 240. The above error indicates that the contents of this field exceeds its default SQL-WIDTH or the MAX-WIDTH size.
FIX:
Use the DBTool utility to fix the width of the offending field(s) in the _File table. For example the following steps will scan the _File table and modify the SQL-WIDTH or the MAX-WIDTH attribute to make it xx% more than the longest contents of any offending field. Where xx% is the padding percentage entered in step 4.1 (Applicable to OpenEdge 10.x DBTool version only):
1. Get the table number of the offending table using 4GL. For example:
FIND _file WHERE _File-Name = "_File".
MESSAGE _File-Num
VIEW-AS ALERT-BOX INFO BUTTONS OK.
2. Run the DBTool utility by executing the command:
dbtool sports2000
3. Type choice 2 to select SQL Width Scan w/Fix Option
4. Type 0 or 1 to select the database connection mode
4.1. (Applicable to OpenEdge 10.x DBTool version only) Type padding percentage level desired.
5. Type the table number obtained from running the 4Gl code above.
6. Type the verbose level desired.