Targeted Quick Search Returns Error: ORA-06512: at "CTXSYS.DRUE"
(Doc ID 880043.1)
Last updated on MAY 22, 2020
Applies to:
Oracle WebCenter Content - Version 10.0 and laterInformation 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:
- In the Admin Server, under General Configuration, check the selection for "Enable search keyword highlighting".
- 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 - 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=document&SortField=dInDate&SortOrder=Desc&dDocName=000001&dID=1&HighlightType=HtmlHighlight&dWebExtension=doc - 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=dDocAuthor++`sysadmin`&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. - 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
Changes
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 |
Changes |
Cause |
Solution |
References |