Targeted Quick Search Returns Error: ORA-06512: at "CTXSYS.DRUE" (Doc ID 880043.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.1 to 10.1.3.3.4 [Release 10gR3]
Information in this document applies to any platform.

Symptoms

Using Oracle database fulltext searching, there is a problem with the targeted Quick Search in the Trays layout if you enable search keyword highlighting.

To reproduce the issue:

  1. In the Admin Server, under General Configuration, check the selection for "Enable search keyword highlighting".

  2. Select the Author targeted Quick Search, type sysadmin in the Quick Search box and click the Quick Search button. The URL if you click on the Content ID for an item returned is:

    http://localhost:84/10g_oracle/groups/public/documents/adacct/000001.doc
  3. In the Quick Search dropdown, select Clear Selection. Type a word in the Quick Search box, and click the Quick Search button. This now also does a fulltext search, and will highlight the word in the document. The URL if you click on the Content ID for an item returned is:

    http://localhost:84/10g_oracle/idcplg?IdcService=GET_HIGHLIGHT_INFO&QueryText=%3cqsch%3edocument%3c%2fqsch%3e&SortField=dInDate&SortOrder=Desc&dDocName=000001&dID=1&HighlightType=HtmlHighlight&dWebExtension=doc
  4. Select the Author targeted Quick Search, type sysadmin in the Quick Search box and click the Quick Search button. The URL if you click on the Content ID for an item returned is:

    http://localhost:84/10g_oracle/idcplg?IdcService=GET_HIGHLIGHT_INFO&QueryText=%3cusch%3edDocAuthor+%3csubstring%3e+%60sysadmin%60%3c%2fusch%3e&SortField=dInDate&SortOrder=Desc&dDocName=000001&dID=1&HighlightType=HtmlHighlight&dWebExtension=doc

    This URL still has the highlighting information, even though it should not be a fulltext search.  The URL should be the same as in Step 2 above.

  5. If you click the Content ID, you get this error:

    Content Server Request Failed
    csSearchRetrieveHighlightInfoError Unable to execute query 'CtextHighlight'.
    ORA-20000: Oracle Text error:
    DRG-50901: text query parser syntax error on line 1, column 1

    ORA-06512: at "CTXSYS.DRUE", line 160
    ORA-06512: at "CTXSYS.CTX_DOC", line 1129
    ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms