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 DECEMBER 23, 2024
Applies to:
Oracle Life Sciences Argus Safety - Version 8.2.1 and laterInformation 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 |