My Oracle Support Banner

PKG_TEXT_SEARCH.P_GET_CASE_DATA Error During Duplicate Search (Doc ID 2901014.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.2.3 and later
Information in this document applies to any platform.

Symptoms

The following error is thrown during the duplicate search for Incoming ICSR

Error
'Contact your system administrator'

THE CMN_ERROR_LOG table captures the following:

PKG_TEXT_SEARCH.P_GET_CASE_DATA :- System.Data.OracleClient.OracleException
(0x80131938): ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
ORA-06512: at "ARGUS.PKG_UTL_SQL", line 107
ORA-06512: at "ARGUS.PKG_UTL_SQL", line 73
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "ARGUS.PKG_UTL_SQL", line 58
ORA-06512: at "ARGUS.PKG_UTL_SQL", line 100
ORA-06512: at "ARGUS.PKG_TEXT_SEARCH", line 189
ORA-06512: at line 1

   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle
errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle
statementHandle, CommandBehavior behavior, Boolean needRowid,
OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean
needRowid, OciRowidDescriptor& rowidDescriptor)
   at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
   at Relsys.Common.SearchEngine.OracleExecuter.Execute(ExecuterParameter[]
Parms)
   at Relsys.Common.SearchEngine.ArgusTextSearchEngine.Lookup(Int32
SearchLimit)
PL/SQL Call Stack:
  13653083243445794321
673        PKG_CONSOLE_COMMON.P_ERROR_LOG
1          __anonymous_block


After analysis, it was determined that the error occurs only when the duplicate search index job is scheduled for execution.
Once the job is executed, there is no issue with duplicate search.

Workaround
As a work around we could change the job execution schedule by adjusting
Argus Console--> System Configuration--> (Common Profile Switches)
Case Processing--> Performance

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.