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

Last updated on FEBRUARY 03, 2019

Applies to:

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

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