My Oracle Support Banner

Duplicate Search Error No: -2146233088 Description: ORA-29903: error in executing ODCIIndexFetch() routine (Doc ID 1512740.1)

Last updated on JANUARY 11, 2022

Applies to:

Oracle Argus Safety - Version 6.0.2 to 8.1.3 [Release 6.0 to 8.1]
Information in this document applies to any platform.

Symptoms

The following error is seen when performing duplicate search:

 

Error No: -2146233088 Description: ORA-29903: error in executing ODCIIndexFetch() routine

ORA-20000: Oracle Text error:

ORA-04030: out of process memory when trying to allocate 160024 bytes (ERM heap,dreb_likeq:outwArray)

 

Other errors that may occur include below when doing a duplicate search via E2B Pending Screen:

 

PKG_TEXT_SEARCH.P_GET_CASE_DATA :- System.Data.OracleClient.OracleException: ORA-29903: error in executing ODCIIndexFetch() routine
ORA-20000: Oracle Text error:
DRG-00100: internal error, arguments : [50935],[drpn.c],[1105],[],[]
DRG-00100: internal error, arguments : [50935],[drpnw.c],[738],[],[]
DRG-00100: internal error, arguments : [51002],[drwa.c],[625],[],[]
DRG-00100: internal error, arguments : [51028],[drwaw.c],[320],[0],[%ALIROCUMAB%%]
DRG-10900: out of memory
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

  at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
  at System.Data.OracleClient.OracleDataReader.ReadInternal()
  at System.Data.OracleClient.OracleDataReader.Read()
  at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
  at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
  at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
  at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
  at System.Data.DataSet.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler, DataTable[] tables)
  at System.Data.DataSet.Load(IDataReader reader, LoadOption loadOption, String[] tables)
  at Relsys.Common.SearchEngine.OracleExecuter.Execute(ExecuterParameter[] Parms)
  at Relsys.Common.SearchEngine.ArgusTextSearchEngine.Lookup(Int32 SearchLimit)
PL/SQL Call Stack:
 SQL
673        PKG_CONSOLE_COMMON.P_ERROR_LOG
1          __anonymous_block


Additionally - via Case Book-in Duplicate Search:

PKG_TEXT_SEARCH.P_GET_CASE_DATA :- System.Data.OracleClient.OracleException: ORA-29903: error in executing ODCIIndexFetch() routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in dretbase
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "CTXSYS.DRIXMD", line 1298
ORA-00039: error during periodic action
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-06512: at "CTXSYS.D

  at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
  at System.Data.OracleClient.OracleDataReader.ReadInternal()
  at System.Data.OracleClient.OracleDataReader.Read()
  at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
  at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
  at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
  at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
  at System.Data.DataSet.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler, DataTable[] tables)
  at System.Data.DataSet.Load(IDataReader reader, LoadOption loadOption, String[] tables)
  at Relsys.Common.SearchEngine.OracleExecuter.Execute(ExecuterParameter[] Parms)
  at Relsys.Common.SearchEngine.ArgusTextSearchEngine.Lookup(Int32 SearchLimit)
PL/SQL Call Stack:
 SQL
673        PKG_CONSOLE_COMMON.P_ERROR_LOG
1          __anonymous_block"

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.