My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.