Skip to main content

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.
 

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


Best Regards,
Yasas 

Hi @anuruddhabm 

hope this may also help

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

Regards
Shan

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? 

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

Terms & ConditionsCookie settings