Kbase P76579: SQL query getting -20217 error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/04/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
SQL query getting -20217 error
CAUSE:
Index records in the SYSIDXSTAT table were corrupt. Because this table is used to optimize queries the corrupted index records caused the query to be optimized incorrectly
FIX:
Use the proutil YourDatabaseNameGoesHere -C idxfix command to repair the indexes for the SYSIDXSTAT table