IDXACTIVATE fails when attempting to activate an index where PRIMARY index is inactive

IDXACTIVATE fails when attempting to activate an index where PRIMARY index is inactive errors 15882 997
How to activate an INACTIVE index using IDXACTIVATE when the PRIMARY index is not active.
Trying to reactivate a primary index with IDXACTIVATE fails with error 15882 when the primary index is accidentally deactivated
When trying to change a primary index to an alternative primary index raises error 997

IDXACTIVATE cannot perform an online activation of the PRIMARY index of a table.
IDXACTIVATE cannot perform an online activation of any index of a table if the PRIMARY index of that table is inactive. 

When no PRIMARY index is active it needs to be:

1. IDXBUILD
2. IDXFIX Option 3 offline
3. IDXACTIVATE with the useindex option against an available active index
4. If Multi-Tenancy is enabled then MTIDXBUILD may be another option
5. If Table Partitioning is enabled then TPIDXBUILD may be another option

For further information refer to Article  How to activate a Primary Index  
 

Progress Article:

 What is IDXACTIVATE?

Some customers have expresssed various ideas of how to improve this function of proutil.
If you would like to file an Idea for suggestions or requests to improve our functionality please refer to this article:
How to submit an enhancement request for a Progress product?