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:

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

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