Kbase P111736: UPDATE ALL COLUMN STATISTICS fails with ErrorCode=-20217
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/04/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
SYMPTOM(s):
UPDATE ALL COLUMN STATISTICS fails with ErrorCode=-20217
ErrorCode=-20217
[JDBC Progress Driver]:-20217
UPDATE ALL COLUMN STATISTICS FOR [<schema>.]"<table>"; also fails on certain tables
CAUSE:
Bug# OE00125172
FIX:
Upgrade to OpenEdge version 10.1C or higher.
For previous versions the following workaround exists:
1) To determine where the problem is, update the column statistics for each table individually:
UPDATE ALL COLUMN STATISTICS FOR [<schema>.]"table";
COMMIT;
2) Update the column statistics of the failing tables again:
UPDATE ALL COLUMN STATISTICS FOR [<schema>.]"table";
COMMIT;
3) Now update the column statistics of all the tables:
UPDATE ALL COLUMN STATISTICS;
COMMIT;