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 INDEX IDX_DCS_PRODUCT ON DCS_PRODUCT("DESCRIPTION") INDEXTYPE IS "CTXSYS"."CONTEXT";
Index created.

This resolved the error and I was able to insert the Product data from ACC.



Comments

Post a Comment

Popular posts from this blog

Navigating the College Application Labyrinth: A Parent's Journal from Junior Year

-
 As a parent, there are few experiences quite as exhilarating, and simultaneously nerve-wracking, as embarking on the college application process with your child. It's a journey that takes you through an emotional rollercoaster ride, packed with highs and lows, anticipation and anxiety, joy and worry. It is a path that is both uncertain and uncharted, and yet, it holds the promise of a bright future. This blog chronicles my personal journey with my child through the maze that is the college application process. It's a narrative filled with countless Google searches, late-night discussions, endless paperwork, and the most pivotal decisions that are shaping path towards the next significant milestone in my child's life as he is at the end of Junior year in High School.   We had a session with five college advisors from Stanford, Duke, UPenn, Cornell and Berkeley. Here are the raw notes from the meeting and lot of good questions from meeting that will help. Sharing unfiltered
Read more

Empowering Sales Excellence: Gen AI-Driven Sales Call Planning

-
Sales pre-call planning is the process of preparing and strategizing before making a sales call or engaging with a potential customer.  Planning encompasses the collection of information, the establishment of objectives, and the formulation of a strategic course of action to enhance the efficacy and success of the sales call. Proficient pre-call planning lays the foundation for the sales interaction, endowing sales representatives with the essential knowledge, strategy, and assurance required to meaningfully engage with potential customers. Generative AI engines such as GPT can be incredibly useful for pre-call planning in a Sales team.  Here are some ways a AI engine can assist sales representatives: #1 Planning Sales Calls - AI engine can help identify the customers to call or interact in the month or week ahead based on a number of dimensions and help plan the time for the sales team. #2 Customer Insights : By analyzing accessible customer data, past interactions, and historical bu
Read more