Kbase P93715: UPDATE ALL COLUMN STATISTICS fails with ErrorCode=1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
UPDATE ALL COLUMN STATISTICS fails with ErrorCode=1
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=1
[JDBC Progress Driver]:1
Running different UPDATE ALL COLUMN STATISTICS FOR [<schema>.]"<table>"; fails with same error for tableX
FIX:
Run:
UPDATE ALL COLUMN STATISTICS FOR [<schema>.]"tableX";
COMMIT;
and then again:
UPDATE ALL COLUMN STATISTICS;
COMMIT;