Solved

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

  • 11 June 2021
  • 8 replies
  • 445 views

Userlevel 3
Badge +3

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.

icon

Best answer by Ragaventhan Sathananda 11 June 2021, 04:08

View original

This topic has been closed for comments

8 replies

Userlevel 7
Badge +15

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.

Userlevel 7
Badge +15

Hi @chathurangatb 

 

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

SQL> alter index <INDEX_NAME> rebuild;

Userlevel 7
Badge +18

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,

Userlevel 7
Badge +15

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.

Userlevel 7
Badge +18

Thank you @Ragaventhan Sathananda ! That’s great !

 

Thanks,

Userlevel 3
Badge +3

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.

 Issue has been solved. Thank you Ragaventhan Sathananda.

Userlevel 3
Badge +3

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

 

Badge +2

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.