1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle UCM 10g R3.5 Search Error

Discussion in 'Oracle Webcenter Suite (formerly Oracle ECM)' started by Cloud99, Apr 15, 2011.

  1. Cloud99

    Cloud99 Active Member

    Likes Received:
    Trophy Points:
    Hi All,

    Currently we facing search problem on our UCM Server. The ucm server often give us error messages when we search document either from quick search or from search profile.We
    sometimes have to wait for long time for the search results. After the error messages comes out, when we search again for the same keyword, the ucm ussually will give us the search result with quick responds.

    the error messages is looks like this.

    DRG-50857: oracle error in ctx_query.result_set
    ORA-20000: Oracle Text error:
    ORA-06512: at "CTXSYS.DRUE"\, line 160
    ORA-06512: at "CTXSYS.CTX_QUERY"\, line 788
    ORA-06512: at "ECM.CONTENT_SEARCH"\, line 116
    ORA-06512: at line 1

    Content server version:
    2010_03_25 (build 58)
    Compatible with Build (

    did anyone know how to solve this problem or have experiecened with this kind of problem.. please give us any advice or clue how to solve this problem.

    best regards.