Hi @chathurangatb 

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.

Hi @chathurangatb 

You may rebuild the index through the below query and resolve the issue.

SQL> alter index <INDEX_NAME> rebuild;

Hi @chathurangatb ,

You can drop the InventoryPart search index through the application itself. @Ragaventhan Sathananda please correct me if I’m wrong.

I have got the same error when creating an Inventory Part, it was resolved after dropping the search indexes like above.

Thanks,

Hi @ThushAsanka,

Correct you can drop and reactivate the indexes through the Search Domain application window as well as you mentioned. Or else you can manually do that from the database end as well through SQL queries.

Thank you @Ragaventhan Sathananda ! That’s great !

Thanks,

 Issue has been solved. Thank you Ragaventhan Sathananda.

Hi @chathurangatb ,

You can drop the InventoryPart search index through the application itself. @Ragaventhan Sathananda please correct me if I’m wrong.

I have got the same error when creating an Inventory Part, it was resolved after dropping the search indexes like above.

 

Thanks,

 Thank you ThushAsanka

I got the same 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.