Fulltext Searches for Words Such As "about", "tt", or "tr" Give an Error: "ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error" (Doc ID 736271.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Thesaurus Management System - Version 4.5.2 and later
Oracle WebCenter Content - Version 7.5.1 to 10.1.3.3.3 [Release Stellent to 10gR3]
Information in this document applies to any platform.
***Checked for relevance on 10-Jan-2012***


Symptoms

Search indexer used in UCM is Database.Fulltext.  If you do a quick search for words "about","tt", or "tr", then the following error is displayed:

ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax

intradoc.common.ServiceException: !csSearchUnableToRetrieveSearchResult!csDbUnableToCreateResultSet,SELECT IdcColl2.dID\, dDocName\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dPublishType\, dRendition1\, dRendition2\, VaultFileSize\, WebFileSize\, URL\, dFullTextFormat\, dFullTextCharset\, DocMeta.*

Changes

 

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