My Oracle Support Banner

ICSR file does not import into Argus (Doc ID 2461796.1)

Last updated on DECEMBER 16, 2024

Applies to:

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

Symptoms

ICSR file (E2B R3 format) does not import into Argus and the error appears in the ESM import log


---------------------------------------------
ERRORS:
---------------------------------------------
09-Oct-2018 07:59:38 PM  XXX  : >>DEBUG>> Enter Fn:UpdateEDIInfo Msg ID = 3580400
09-Oct-2018 07:59:38 PM  XXX  : >>Debug>> ENTER Fn: GetInboundMsgStatus(I-XXX-20180926020302-JP201817568AA_08_OCT.XML)
09-Oct-2018 08:00:15 PM  XXX  : Error in GetInboundMsgStatus for file name I-XXX-20180926020302-JP201817568AA_08_OCT.XML
Contact your system administrator
  at Relsys.Persistence.DataAccess.DataAccess.ExecuteDataSet(DbCommand dbCommand)
  at Relsys.Gateway.Cyclone.CycloneFolder.GetInboundMsgStatus(EDIStatusInputParam ediStatusParam)
  at E2BReceive.E2BReceive.GetInboundMsgStatus(String p_sFileName)
ORA-12154: TNS:could not resolve the connect identifier specified
  at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable)
  at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
  at Oracle.DataAccess.Client.OracleConnection.Open()
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection(Boolean disposeInnerConnection)
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
  at Microsoft.Practices.EnterpriseLibrary.Data.OracleDataProvider.OracleDatabase.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String tableName)
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteDataSet(DbCommand command)
  at Microsoft.Practices.EnterpriseLibrary.Data.OracleDataProvider.OracleDatabase.ExecuteDataSet(DbCommand command)
  at Relsys.Persistence.DataAccess.DataAccess.ExecuteDataSet(DbCommand dbCommand)
09-Oct-2018 08:00:15 PM  XXX  : >>Debug>> Exit Fn: GetInboundMsgStatus
09-Oct-2018 08:00:15 PM  XXX  : >>DEBUG>> Exit Fn:UpdateEDIInfo
09-Oct-2018 08:00:15 PM  XXX  : >>DEBUG>> File \\XXX\\GATEWAY\PMDA\IN\I-XXX-20180926020302-JP201817568AA_08_oct.xml moved to Archive folder :E:\Argus_Installation\Argus_App\InterchangeService\Archive\
09-Oct-2018 08:00:15 PM  XXX  :  ========== Finish Receive Process ==========



---------------------------------------------
STEPS
---------------------------------------------
1. Drop the ICSR file in IN folder

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.