Kbase P118846: Error: Character string is too long (8184) running UPDATE ALL COLUMN STATISTICS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/27/2009 |
|
Status: Verified
SYMPTOM(s):
Error: Character string is too long (8184) running UPDATE ALL COLUMN STATISTICS
Getting Error: Character string is too long (8184) (State:S1000, Native Code:
FFFFB148) running UPDATE ALL COLUMN STATISTICS and certain queries against tables.
Error: Insufficient Memory. Memory allocation failed at %s in %s. Contact Progress Technical Support. (13163)
Using DBTOOL to adjust SQL width of fields within database.
Using 100% padding option of DBTOOL to adjust SQL width of fields within database.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1A
OpenEdge Category: Database
CAUSE:
Bug# OE00132553
CAUSE:
The maximum value of SQL Width is 31995. Using the padding option of dbtool it is possible to adjust the value to 32000. This value should not be configurable with the dbtool but currently dbtool is allowing this to be set when using padding.
FIX:
Upgrade to OpenEdge 10.1B or later. If upgrading to OpenEdge 10.1B or later is not feasible, then manually adjust the SQL Width using the Data Dictionary tool.