ATG Repository Exception | ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
While working with the ACC I received this error while trying to add Products. 2010-04-30 18:00:45,079 ERROR [nucleusNamespace.atg.devtools.DevSessionManager._1.atg.devtools.RepositoryAgent] CAUGHT AT:CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE at atg.adapter.gsa.GSAItemDescriptor.addItem(GSAItemDescriptor.java:6400) To resolve this error I have done the following: 1. Find out the table that is causing this error. In my case it was DCS_PRODUCT table and index that is causing this error was IDX_DCS_PRODUCT 2. Log into Oracle with the DBA user SQL>Connect ATG_DBA/ATG_DBA; 3. Get the DDL for the Index before dropping the same SQL> Select dbms_metadata.get_ddl('INDEX','IDX_DCS_PRODUCT','ATG_DBA') from dual; 4. Drop index that is causing the error SQL> drop index IDX_DCS_PRODUCT; Index dropped. 5. Create that index again using the following statement SQL> CREATE INDE