My Oracle Support Banner

Unable To Transmit E2B Files From Argus (ESMProc.Send_E2B_Report Fn, Error Number = 5 ) After Clone/Refresh of Multi-Tenant Environment (Doc ID 2691937.1)

Last updated on JULY 17, 2020

Applies to:

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

Symptoms

Unable to transmit E2B files from argus

Generated E2B report, then subsequently Transmitted at this point it fails


On checking E2BTransmission log noted below error(s):



05-Jun-2020 03:15:30 PM: ========== Start Transmit Process ==========
05-Jun-2020 03:15:31 PM: ESM Service Login to 'DATABASE1' Database with UserID 'esm_login' Successfully
05-Jun-2020 03:15:31 PM: ESM Proc for E2BTransmission
05-Jun-2020 03:15:31 PM XXX_Upgrade : System error has occurred in ESMProc.Send_E2B_Report Fn, error number = 5 error desc. = Contact your system administrator error source = Relsys.Persistence.DataAccess
05-Jun-2020 03:15:31 PM XXX_Upgrade : Exception Contact your system administrator
  at Relsys.Persistence.DataAccess.DataAccess.ExecuteDataSet(DbCommand dbCommand)
  at InterchangeUtility.DBUtil.ExecuteSelectQueryDS(String p_sSQL)
  at ESMProc.Module1.Send_E2B_Report(Int64& p_iSuccess, Int64& p_iFailure) Specified cast is not valid.
  at Oracle.DataAccess.Client.OracleDataReader.GetValues(Object[] values)
  at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
  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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
  at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
  at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  at Relsys.Persistence.DataAccess




Steps to Reproduce:

1. Newly refreshed Multi-Tenant Environment
2. Schedule, generate and transmit E2B
3. Report fails and above warning is output in transmission logs


Other functions in the application are working correctly, only E2B Transmission is affected.

Changes

 Recent upgrade to Argus Safety 8.2.1  with a subsequent refresh/clone from Production Environment to Development.

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.