Skip to main content
Question

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

  • October 12, 2021
  • 4 replies
  • 193 views

Forum|alt.badge.img+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 replies.

4 replies

Yasas Kasthuriarachchi
Superhero (Employee)
Forum|alt.badge.img+30

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


Best Regards,
Yasas 


Forum|alt.badge.img+9
  • Hero (Employee)
  • 79 replies
  • October 12, 2021

Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 2 replies
  • October 12, 2021

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? 


Forum|alt.badge.img+9
  • Hero (Employee)
  • 79 replies
  • October 12, 2021

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