+2I 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
hope this may also help
when creating Inventory Part "domain index is marked LOADING/FAILED/UNUSABLE" | IFS Community
Regards
Shan
+2I 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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
