Hello,
I am trying to create Inventory Part in IFS Application 9 but it raise error.
“domain index is marked LOADING/FAILED/UNUSABLE”
kindly help me to resolve this issue.
error log attached.
Hello,
I am trying to create Inventory Part in IFS Application 9 but it raise error.
“domain index is marked LOADING/FAILED/UNUSABLE”
kindly help me to resolve this issue.
error log attached.
Best answer by Ragaventhan Sathananda
Hi
This is due to the indexes in the Inventory Part table has been marked on those three status. You may find that through the below query on the database.
SELECT INDEX_NAME, STATUS FROM USER_INDEXES WHERE TABLE_NAME = 'tablename'; If you are not the owner of the table, then search ALL_INDEXES or DBA_INDEXES instead of USER_INDEXES.
You need to rebuild the indexes related to the Inventory Part table or drop and recreate the indexes in order to resolve the issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.