Oracle WebCenter Content (MOSC)

MOSC Banner

Is the word 'about' a reserved keyword for Search in Oracle UCM.

edited Nov 8, 2013 6:05AM in Oracle WebCenter Content (MOSC) 1 commentAnswered
We are using Oracle UCM 10g3 and whenever we search for word 'about', we get the below error.

Error:

Content Server Request FailedUnable to retrieve search results. Unable to retrieve search results. Unable to create result set for query 'SELECT IdcColl2.dID, dDocName, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dCreateDate, dPublishType, dRendition1, dRendition2, VaultFileSize, WebFileSize, URL, dFullTextFormat, dFullTextCharset, DocMeta.*
FROM IdcColl2, DocMeta
WHERE IdcColl2.dID=DocMeta.dID AND ((((((((UPPER(dDocName) LIKE UPPER('%about%') AND dDocName IS NOT NULL) OR (UPPER(dDocTitle) LIKE UPPER('%about%') AND dDocTitle IS NOT NULL) OR (CONTAINS(dDocFullText,'about') > 0 ) ))))))) ORDER BY dInDate Desc'. ORA-20000: Oracle Text error:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center