Incoming files are stuck in ESM_IMPORT_QUEUE and not processed by ESM service
(Doc ID 2789552.1)
Last updated on OCTOBER 10, 2024
Applies to:
Oracle Life Sciences Argus Safety - Version 8.2 and laterOracle Life Sciences Argus Interchange - Version 8.2.3 to 8.2.3 [Release 8.2]
Information in this document applies to any platform.
Symptoms
Incoming XML files are not picking up from Incoming folder by ESM service with the below errors being logged.
The files are populated in ESM_IMPORT_QUEUE table but are not progressed further and remain in Incoming folder.
If an empty txt/xml files are dropped into Incoming folder the files are removed with an invalid format error as expected.
Errors in E2BReceive.E2BReceive log
[EnterpiseID: ] 29-Jun-2021, 15:02:24:802, [1], UserId: , Exception
DetailsMessage
Value was either too large or too small for an Int16.
Stack Trace
at System.Convert.ToInt16(Int64 value)
at Oracle.DataAccess.Client.OracleParameter.PreBind_Int16()
at Oracle.DataAccess.Client.OracleParameter.PreBind(OracleConnection conn,
IntPtr errCtx, Int32 arraySize, Boolean bIsFromEF, Boolean bIsSelectStmt)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Relsys.Persistence.DataAccess.Oracle.Db.DoExecuteNonQuery(DbCommand
command)
at Relsys.Persistence.DataAccess.Oracle.Db.ExecuteNonQuery(DbCommand
command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand
dbCommand)
Erorrs in ESM Import Log
15-Jun-2021 01:47:07 PM: ========== Start Receive Process ============
15-Jun-2021 01:47:07 PM: >>DEBUG>> SQL: ESM_PKG.ESM_OWNER
15-Jun-2021 01:47:08 PM: >>DEBUG>> SQL: Update ESM_IMPORT_QUEUE Set STATUS =
3 Where JOB_ID = :P_JOB_ID
15-Jun-2021 01:47:08 PM: System Error has occurred in E2BReceive.Main Fn.
Contact your system administrator
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand
dbCommand)
at InterchangeUtility.DBUtil.ExecuteIUDSQLQuery(DbCommand& p_dbCommand)
at E2BReceive.Module1.Main()
15-Jun-2021 01:47:08 PM: >>DEBUG>> Enter Fn: Send_EMail
15-Jun-2021 01:47:09 PM: >>DEBUG>> Exit Fn: Send_EMail
15-Jun-2021 01:47:09 PM: >>DEBUG>> SQL: Update ESM_IMPORT_QUEUE Set STATUS =
1, JOB_ID = NULL Where STATUS IN (2,3) AND JOB_ID = 117750
15-Jun-2021 01:47:09 PM: ========== Finish Receive Process ==========
15-Jun-2021 01:47:17 PM: ========== Start Receive Process ============
15-Jun-2021 01:47:17 PM: >>DEBUG>> SQL: ESM_PKG.ESM_OWNER
15-Jun-2021 01:47:18 PM: >>DEBUG>> SQL: Update ESM_IMPORT_QUEUE Set STATUS =
3 Where JOB_ID = :P_JOB_ID
15-Jun-2021 01:47:18 PM: System Error has occurred in E2BReceive.Main Fn.
Contact your system administrator
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand
dbCommand)
at InterchangeUtility.DBUtil.ExecuteIUDSQLQuery(DbCommand& p_dbCommand)
at E2BReceive.Module1.Main()
15-Jun-2021 01:47:18 PM: >>DEBUG>> Enter Fn: Send_EMail
15-Jun-2021 01:47:18 PM: >>DEBUG>> Exit Fn: Send_EMail
15-Jun-2021 01:47:18 PM: >>DEBUG>> SQL: Update ESM_IMPORT_QUEUE Set STATUS =
1, JOB_ID = NULL Where STATUS IN (2,3) AND JOB_ID = 117751
15-Jun-2021 01:47:18 PM: ========== Finish Receive Process ==========
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 |