Searches Fail Due To ORA-06502: PL/SQL: numeric or value error (Doc ID 2142298.1)

Last updated on AUGUST 28, 2017

Applies to:

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

Symptoms

The WebCenter Content server is configured for OracleTextSearch.

When a user attempts a search, it fails and the trace audit will show the following:

>systemdatabase/7 04.11 14:55:23.817 IdcServer-8053 (start) Executing CallableStatement ({call content_search.search_with_resultsetinterface(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)})

:

>systemdatabase/6 04.11 14:55:34.687 IdcServer-8053 !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-06502: PL/SQL: numeric or value error
systemdatabase/6 04.11 14:55:34.687 IdcServer-8053 ORA-06512: at line 1
>systemdatabase/6 04.11 14:55:34.687 IdcServer-8053 run: 1.71 ms. total 4.63 ms. [ORA-06502: PL/SQL: numeric or value error
systemdatabase/6 04.11 14:55:34.687 IdcServer-8053 ORA-06512: at line 1
systemdatabase/6 04.11 14:55:34.687 IdcServer-8053 ]

:

>requestaudit/6 04.11 14:55:23.941 IdcServer-8053 GET_SEARCH_RESULTS [dUser=JOE.USER][QueryText= ((Documents) WITHIN dDocType) and (( ((TEST) WITHIN xComments) ))][StatusCode=-1][StatusMessage=Unable to retrieve search results. Error occurred while processing. Unable to return results.][IsJava=1] 2.4297730922698975(secs)

 

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