Content-based Search In UCM 10g Using OracleTextSearch on RDBMS 11gR1 Fails With DRG-50900 And DRG-50903 In Non-English Locale (Doc ID 1119213.1)

Last updated on MAY 30, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.4 and later
Information in this document applies to any platform.

Symptoms


Executing a content-based search in UCM 10g using the OracleTextSearch index engine on RDBMS 11gR1 fails with the following error:

On a system with a Polish locale setting:

Content Server Request Failed
Unable to retrieve search results. Error generated when executing query '((((DEFINESCORE((yourkeyword), RELEVANCE * .01)) ))) * 10.0 * 10.0'. Unable to execute callable query 'CotsSearchQuery'. ORA-20000: Oracle Text -virhe:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text -virhe:
DRG-50900: tekstikyselyn j�sennysvirhe rivill� 1, sarake 49
DRG-50903: virheellinen painotus 10.0

ORA-06512: "CTXSYS.DRUE", line 160
ORA-06512: "CTXSYS.CTX_QUERY", line 788
ORA-06512: "IDC_ORC_CONT.CONTENT_SEARCH", line 1
ORA-06512: line 1


On a system with a German locale setting, this would be:


Content Server Request Failed
Unable to retrieve search results. Error generated when executing query '((((DEFINESCORE((yourkeyword), RELEVANCE * .01)) ))) * 10.0 * 10.0'. Unable to execute callable query 'CotsSearchQuery'. ORA-20000: Oracle Text -virhe:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-50900: Fehler bei Textabfrage-Parser in Zeile 1, Spalte 217
DRG-50903: Ungltige Gewichtung 10.0

ORA-06512: "CTXSYS.DRUE", line 160
ORA-06512: "CTXSYS.CTX_QUERY", line 788
ORA-06512: "IDC_ORC_CONT.CONTENT_SEARCH", line 1
ORA-06512: line 1


The ORA- and DRG- errors are displayed in a non-English/US language.

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