My Oracle Support Banner

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 DECEMBER 21, 2017

Applies to:

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


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.*




To view full details, 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 a vibrant support community of peers and Oracle experts.