Question

When creating Inventory Part in APP9 "domain index is marked LOADING/FAILED/UNUSABLE"

  • 12 October 2021
  • 4 replies
  • 153 views

Badge +2

I got the below error when I tried to create an inventory part in APP9.

“domain index is marked LOADING/FAILED/UNUSABLE”

I tried dropping the index for search domain “inventory parts” and rebuild but still the error persists. 

Please help to resolve the issue.
 


This topic has been closed for comments

4 replies

Userlevel 7
Badge +30

Hi @anuruddhabm,
Please refer following KBA’s Resolution:
 


Best Regards,
Yasas 

Userlevel 5
Badge +9

Hi @anuruddhabm 

hope this may also help

when creating Inventory Part "domain index is marked LOADING/FAILED/UNUSABLE" | IFS Community

Regards
Shan

Badge +2

I tried the resolutions mentioned but no luck. Dropping the index and rebuilding but still the issue is there. How can I find all the indices which not valid? 

Userlevel 5
Badge +9

Hi @anuruddhabm 

This may help
 

To identify which domain index has not valid, run the following SQL as app owner:

 

SELECT * FROM all_indexes
WHERE DOMIDX_OPSTATUS != 'VALID' OR STATUS != 'VALID' OR DOMIDX_STATUS != 'VALID'

Regards
Shan