This discussion is archived
14 Replies Latest reply: Nov 24, 2010 4:32 AM by Jie Chen-Oracle RSS

Help! ORA-29861!

772334 Newbie
Currently Being Moderated
Hi, ladies and gentlemen!
I have used oracle database 11.1.06 + WebLogice Server 10.3.0 + Agile PLM 9.3 to setup a product management system, but i can't upload attachments! It told me it was an error ORA-29861 there.
Who can tell me how to resolve this problem?
PS: I am a noob in this applification field.
  • 1. Re: Help! ORA-29861!
    sb92075 Guru
    Currently Being Moderated
    29861, 00000, "domain index is marked LOADING/FAILED/UNUSABLE"
    // *Cause: An attempt has been made to access a domain index that is
    //         being built or is marked failed by an unsuccessful DDL
    //         or is marked unusable by a DDL operation.
    // *Action: Wait if the specified index is marked LOADING
    //          Drop the specified index if it is marked FAILED
    //          Drop or rebuild the specified index if it is marked UNUSABLE.
  • 2. Re: Help! ORA-29861!
    772334 Newbie
    Currently Being Moderated
    Thanks.
    I know this information, but i don't know how to "wait" or "rebuild" or "drop".
    Can you tell me resolve this step by step?
    By the way, i never use any oracle software.
  • 3. Re: Help! ORA-29861!
    618702 Expert
    Currently Being Moderated
    Hi user13069161,

    SQL> analyze index <index_name> validate structure online;
    SQL> drop index <index_name>;
    SQL> alter index <index_name> rebuild online;
    SQL> alter index <index_name> enable;

    validate structure will not lock your table however rebuilding will lock your table. If your index is disabled, you can try to enable it.

    Do not issue above commands step-by-step, those are the syntaxes.

    Hope it helps,

    Ogan
  • 4. Re: Help! ORA-29861!
    Chinar Guru
    Currently Being Moderated
    user13069161 wrote:
    Thanks.
    I know this information, but i don't know how to "wait" or "rebuild" or "drop".
    Can you tell me resolve this step by step?
    By the way, i never use any oracle software.
    Hi,you have to need drop and create(or rebuild) this index as
    select dbms_metadata.get_ddl('INDEX',INDEX_NAME) from dba_indexes
    where index_name='PK_ACCOUNT'; --keep this result
    drop index PK_ACCOUNT;
    then create again
  • 5. Re: Help! ORA-29861!
    FahdMirza Oracle ACE
    Currently Being Moderated
    Is dbms_metadata available in 8.0.6?

    regards
  • 6. Re: Help! ORA-29861!
    Chinar Guru
    Currently Being Moderated
    Fahd Mirza wrote:
    Is dbms_metadata available in 8.0.6?

    regards
    No it is not.
  • 7. Re: Help! ORA-29861!
    FahdMirza Oracle ACE
    Currently Being Moderated
    duplicate

    Edited by: Fahd Mirza on Jun 8, 2010 12:35 PM
  • 8. Re: Help! ORA-29861!
    772334 Newbie
    Currently Being Moderated
    I don't know which index/index_name causes the error, how can i locate it?
    In my opinion, i have to excute the codes in SQL developer. Is that right?
    It's a hard work for me, because i am an engineer of electronics.
  • 9. Re: Help! ORA-29861!
    FahdMirza Oracle ACE
    Currently Being Moderated
    Can you paste the complete error message here please?

    regards
  • 10. Re: Help! ORA-29861!
    772334 Newbie
    Currently Being Moderated
    Hi, below is the error tips i met.

    ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

    java.sql.SQLException: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
    :125)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
    java:185)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS
    tatement.java:633)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
    nt.java:1086)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
    aredStatement.java:2984)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat
    ement.java:3076)
    at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.jav
    a:98)
    at com.agile.pc.cmserver.attachment.AttachmentDAO.appendFileRow(Attachme
    ntDAO.java:258)
    at com.agile.pc.cmserver.attachment.AttachmentServiceFiles.saveAdd(Attac
    hmentServiceFiles.java:548)
    at com.agile.pc.cmserver.attachment.AttachmentServiceFiles.saveRow(Attac
    hmentServiceFiles.java:608)
    at com.agile.pc.cmserver.attachment.AttachmentService.addFile(Attachment
    Service.java:2111)
    at com.agile.pc.cmserver.base.BaseServiceAttachment.addFile(BaseServiceA
    ttachment.java:896)
    at com.agile.pc.cmserver.base.BaseService.addFile(BaseService.java:4424)

    at com.agile.pc.cmserver.base.BaseService.addFiles(BaseService.java:4501
    )
    at com.agile.pc.cmserver.base.CMSessionBean.addFiles(CMSessionBean.java:
    3842)
    at com.agile.pc.cmserver.item.ItemSessionBean_v9sfth_EOImpl.addFiles(Ite
    mSessionBean_v9sfth_EOImpl.java:9611)
    at com.agile.ipa.pc.CMObjectBase.wCmaddFiles(CMObjectBase.java:4460)
    at com.agile.ui.pcm.common.ObjectViewHandler.uploadFileAttachments(Objec
    tViewHandler.java:13480)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.agile.ui.web.action.ActionServlet.invokeMethod(ActionServlet.java
    :1062)
    at com.agile.ui.web.action.ActionServlet.handleRequest(ActionServlet.jav
    a:667)
    at com.agile.ui.web.action.ActionServlet.doPost(ActionServlet.java:309)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run
    (StubSecurityHelper.java:227)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecuri
    tyHelper.java:125)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.jav
    a:292)
    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
    va:42)
    at com.agile.ui.pcm.common.filter.RemoteFSRequestFilter.doFilter(RemoteF
    SRequestFilter.java:143)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
    va:42)
    at com.agile.ui.web.filter.LoggingFilter.doFilter(LoggingFilter.java:108
    )
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
    va:42)
    at com.agile.ui.pcm.common.filter.WebClientLog.doFilter(WebClientLog.jav
    a:78)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
    va:42)
    at com.jspbook.GZIPFilter.doFilter(GZIPFilter.java:21)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
    va:42)
    at com.agile.ui.pcm.common.filter.SSOTicketFilter.doFilter(SSOTicketFilt
    er.java:84)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
    va:42)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
    n.run(WebAppServletContext.java:3496)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
    dSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(Unknown Source)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppS
    ervletContext.java:2180)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletC
    ontext.java:2086)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.j
    ava:1406)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
  • 11. Re: Help! ORA-29861!
    772334 Newbie
    Currently Being Moderated
    ^_^
  • 12. Re: Help! ORA-29861!
    772334 Newbie
    Currently Being Moderated
    Nobody can answer my question...
  • 13. Re: Help! ORA-29861!
    FahdMirza Oracle ACE
    Currently Being Moderated
    Please paste the result of following query?
    select owner,index_name from all_indexes where domidx_status != 'VALID' or domidx_opstatus !='VALID';
  • 14. Re: Help! ORA-29861!
    Jie Chen-Oracle Newbie
    Currently Being Moderated
    Please re-run below sql:

    agile9.sql as schema user
    agile9_fts.sql as schema user
    agile9_fts_ctx.sql as ctx user

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points