Error No -2146233088 When Performing A Duplicate Search For Specific Users (Doc ID 2085140.1)

Last updated on JANUARY 25, 2016

Applies to:

Oracle Argus Safety - Version 7.0.6 to 7.0.6 [Release 7.0.0]
Information in this document applies to any platform.

Symptoms

In Argus 7.0.6:

After Upgrading to Argus 7.0.6, when specific users perform a duplicate search, they are receiving the following error:

Error No -2146233088 Description: Contact your system administrator


CMN_ERROR_LOG shows:

PKG_TEXT_SEARCH.P_GET_CASE_DATA :- System.Data.OracleClient.OracleException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "ARGUS_APP.PKG_TEXT_SEARCH", line 114
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)



This was completed on an environment without a customized duplicate search

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