Kbase P120106: Running update statistics against every table reports generates Fetching error (7721)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/12/2008 |
|
Status: Verified
SYMPTOM(s):
Running update statistics against every table reports generates error
[JDBC Progress Driver]:MM- Fetching error (7721)
SQL trace file reports error
tpl_array_fetch failed with unknown return code -211018 Unsubscripted array fetch found data longer than maximum <field-name>Error in function ddm_set_stat_fld: open + fetch , status = -211018 sqlca code = -211018 stmt:(select rowid from PUB."tablename" ) MM exception - status = -16004 MM exception - status = -16024 Error in function ddm_set_stat_fld: ddm_build_hist failed , status = -16024
Querying all fields in table reported the SQL trace file generates error
Array reference/update incorrect (7888)
DBTool reports no SQLWidth violations.
Database started using -SQLTempPgSize 32 and -SQLTempBuff 4000
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
UNIX
Windows
CAUSE:
Array/extent has a SQLWidth violation. The sqlwidth of the array is calculated. Individual fields within the array do not violate SQLWidth, therefore DBTool does not fix.
CAUSE:
Bug# OE00133979
FIX:
Upgrade to 10.0B04, 10.1A or higher.
If that is not possible at this time two workarounds exist:
1) Increase the SQLWidth/MaxWidth of the field reported via the Data Dictionary and commit changes.
2) Instead of "update statistics", run "update table statistics and index statistics." The prevents the updating of column statistics which is the portion of update statistics that is failing.