Kbase P128638: useindex qualifier for idxactivate returns error 12810 when word index is specified
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/07/2008 |
|
Status: Verified
SYMPTOM(s):
Error attempting to activate an index online using proutil idxactivate
Use index is a word index -- primary index in use. (12810)
proutil idxactivate has the useindex parameter specifying a non-primary index
proutil dbname -C idxactivate pub.tablename.index useindex indexname
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
A word index cannot be used to activate an index.
FIX:
Specify a non-word index with the useindex parameter:
$ proutil dbname -C idxactivate pub.tablename.index useindex indexname recs 1000 refresh 120
The table-name qualifer is not necessary on the useindex command, this is a documentation error in earlier releases.