ESMPROC.EXE Is Getting Terminated With Errors (Doc ID 1334666.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Argus Interchange - Version 4.1.0 to 5.0.0 [Release 4.1.0 to 5.0.0]
Information in this document applies to any platform.
***Checked for relevance 24-DEC-2012***
***Checked for relevance on 23-JUN-2017***

Symptoms

ESM Service is writing the following error in the status check log file:

"28-Jun-2011 6:15:01 PM: >>DEBUG>> In Get_MSGStatus_From_CYCLONE Fn: Total Record Count: 171"
"28-Jun-2011 6:15:01 PM: >>DEBUG>> Get_MSGStatus_From_CYCLONE Fn: Processing 1 of 171 For MSG_ID: 29932"
"28-Jun-2011 6:15:01 PM: >>DEBUG>> Get_MSGStatus_From_CYCLONE Fn: - SQL Before checking config -"
"28-Jun-2011 6:15:01 PM: >>DEBUG>> Get_MSGStatus_From_CYCLONE Fn: - SQL After checking config -"
"28-Jun-2011 6:15:01 PM: >>DEBUG>> Get_MSGStatus_From_CYCLONE Fn: - Before Running Cyclone SQL -"
"28-Jun-2011 6:15:01 PM: System error has occurred in ESMProc.Get_MSGStatus_From_CYCLONE Fn, error number = -2147217865 error desc. = ORA-00942: table or view does not exist
error source = Microsoft OLE DB Provider for Oracle"
"28-Jun-2011 6:15:01 PM: System error has occurred in Main ESMProc Fn, error number = 3265 error desc. = Item cannot be found in the collection corresponding to the requested name or ordinal. error source = ADODB.Fields"
"28-Jun-2011 6:15:01 PM: ESMPROC.EXE Terminated due to unexpected errors."
"28-Jun-2011 6:15:01 PM: ========== Finish Transmit Process ========== "

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms