Date Posted:
Product: E-Notebook Enterprise
Product: E-Notebook Enterprise
Problem:
When uploading files in Ancillary Data I get the error "ORA-29861: domain index is marked loading/failed/unusable".
Solution:
Please try the following steps:
1- Connect to SQL plus using the schema user/password
2- Run this query: select index_name,index_type,status,domidx_status,domidx_opstatus from user_indexes where index_type like '%DOMAIN%' and (domidx_status <> 'VALID' or domidx_opstatus <> 'VALID');
3- There will be an index with a FAILED state, run this query to fix it: alter index FAILED_DOMAIN_INDEX_NAME rebuild;