My Oracle Support Banner

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

Last updated on SEPTEMBER 16, 2022

Applies to:

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


On : 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:

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

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'))))'

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.