Database Full Text Searching with UCM 7.5 and Oracle DB v10g (Doc ID 450194.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Universal Content Management - Version: 7.5.1 to 7.5.1 - Release: Stellent to Stellent
Information in this document applies to any platform.
Product: Content Server
Version: 7.5.1

Symptoms

Environment:  Content Server 7.5.1 on Windows 2003 with an Oracle 10g (V10.2.0.2) database with context search handled by Oracle.

They go to a search page and they can search for metadata with out a problem.
When they type anything into a full text search box they get an error like the following:

Unable to retrieve search results. Unable to retrieve search results. Unable to create result set for query 'SELECT stellent.dID, dDocName, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dPublishType, dRendition1, dRendition2, VaultFileSize, WebFileSize, URL, DocMeta.* FROM stellent, DocMeta WHERE stellent.dID=DocMeta.dID AND ((CONTAINS(dDocFullText,'Text'))) ORDER BY dInDate Desc'. ORA-00920: invalid relational operator

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