Kbase P121882: useindex qualifier for idxactivate returns error 12808 when table-name specified
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/03/2010 |
|
Status: Unverified
SYMPTOM(s):
useindex qualifier for idxactivate returns error 12808 when table-name specified
Use index is inactive -- primary index in use. (12808)
FACT(s) (Environment):
OpenEdge 10.1B
OpenEdge 10.1A
CAUSE:
Bug# OE00145523
FIX:
The documentation OpenEdge Data Management: Database Administration (Dec 2005) for proutil idxactivate indicates the syntax for idxactivate as:
proutil db-name -C idxactivate [owner-name.]table-name.index-name [useindex table-name.index-name] [recs n] [refresh t]
If, however, the table-name is specified with useindex, then the idxactivate fails. The useindex qualifier should be used without specifying the table-name.
For example, if Customer.CustNum from sports2000 is the index to be reactivated using index Customer.Name, then the syntax would be:
proutil db-name -C idxactivate Customer.CustNum useindex Name
i.e. NOT useindex Customer.Name