Duplicate Search Error No: -2146233088 Description: ORA-29903: error in executing ODCIIndexFetch() routine
(Doc ID 1512740.1)
Last updated on DECEMBER 23, 2024
Applies to:
Oracle Life Sciences 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
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"
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 |