DRG-50857: Oracle Error In drekrbgm When Performing A Search (Doc ID 1522979.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.5.0 and later
Information in this document applies to any platform.
Search Engine::ORACLETEXTSEARCH

Symptoms

On : 10.1.3.5.0 version, Content Server

When doing a search for an optimized metadata field, the content server takes a long time to respond and throws the following error:


ERROR
-----------------------
Unable to retrieve search results. Error generated when executing query
Unable to execute callable query 'CotsSearchQuery'. ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drekrbgm (reselect rowid row locator)
ORA-01013: user requested cancel of current operation

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_QUERY", line 791
ORA-06512: at "UCMPROD.CONTENT_SEARCH", line 125
ORA-06512: at "UCMPROD.CONTENT_SEARCH", line 320
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Search Query: '((((((A1\-1) WITHIN xFileNo)) and SDATA(xDocDate >= '2012/05/07 00:00:00') and SDATA(xDocDate < '2013/01/15 00:00:00'))))'


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, documents can not be found and users get tired of waiting long time just to see the error message.

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