Content-based Search Using OracleTextSearch In UCM 11g Fails With DRG-50857 And DRG-11124 In Non-English Locale

(Doc ID 1329718.1)

Last updated on AUGUST 30, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.3.0 to 11.1.1.5.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

After installing ECM 11g on an 11gR2 Oracle RDBMS and setting up Content Server with OracleTextSearch, all fulltext searches fail with the following error:
Content Server Request Failed Unable to retrieve search resultes. Error occurred while processing. Unable to return results.

Looking at the server output (with systemdatabase tracing enabled) we see that the SQL fails with:

systemdatabase/6 .. Prepared statement is reused.
systemdatabase/6 .. Parameters:
([indexName:FT_IdcText1],[tableName:IdcText1],[queryText:((((DEFINESCORE((support), RELEVANCE * .1)))))*10.0*10.0],[returnFields:dDocName,dDocTitle,dDocType,dSecurityGroup,dInDate,dRevisionID,
dDocCreator,dWebExtension,dDocCreatedDate,dCreateDate,dOriginalName,dFormat,
dPublishType,dDocFunction,dDocAuthor,VaultFileSize,dDocLastModifier,xWebFlag,
dOutDate,dGif,dExtension,dDocLastModifiedDate,AlternateFormat,URL,WebFileSize,
dDocOwner,xPartitionId,xComments,dRevLabel,xStorageRule,dFullTextFormat,
dRendition2,dRendition1,dID,dDocAccount,xIdcProfile,otsFormat,otsCharset,
otsLanguage],[resultDescriptor:<ctx_result_set_descriptor><countexact="false"/><group sdata="sdDrillDown"><countexact="true"/></group><hitlist start_hit_num="1" end_hit_num="25"order="dInDate Desc">
systemdatabase/6 .. <sdata name="dID"/><sdata name="sddDocName"/><score/>
systemdatabase/6 .. </hitlist></ctx_result_set_descriptor>],[result(output)],[metaResult (output)],[baseResult (output)],[count(output)],[qvSnippetStartTag:<span class=largeTableEntry><spanclass=highlightField>],[qvSnippetEndTag:</span></span>],[qvSnippetTranslation:true],[qvSnippetSeparator:<b>...</b>],[procFlags:0],[trace (output)])
systemdatabase/7 .. (start) SELECT 1 FROM DUAL
systemdatabase/6 .. 1.19 ms. SELECT 1 FROM DUAL[Executed. Returned row(s):true]
systemdatabase/6 ..!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Erreur Oracle Text :
systemdatabase/6 .. DRG-50857: oracle error in ctx_query.result_set
systemdatabase/6 .. ORA-20000: Erreur Oracle Text :
systemdatabase/6 .. DRG-11124: valeur non valide : .1
systemdatabase/6 ..
systemdatabase/6 .. ORA-6512: #00E0 "CTXSYS.DRUE"\, ligne 160
systemdatabase/6 .. ORA-6512: #00E0 "CTXSYS.CTX_QUERY"\, ligne 791
systemdatabase/6 .. ORA-6512: #00E0 "DEV_OCS.CONTENT_SEARCH"\, ligne 123
systemdatabase/6 .. ORA-6512: #00E0 ligne 1

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