Argus Interchange Service is creating huge logs in the Database (Doc ID 2572656.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

Argus Interchange Service is creating huge logs in the Database. Upon DB level analysis here are the below sqls found to be running:

Module: esmproc.exe
INSERT INTO ESMPROC_LOCKED_RECORDS (PROCESS_TYPE_ID, LOCKED_MACH
INE_NAME, RECORD_ID, ENTERPRISE_ID, SORT_ORDER, PROCESS_DATETIME
) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE)

Module: esmproc.exe
declare x number; begin x := gss_wnds.set_user_id(-9494531817, :
PIO_USER_ID, :P_ENTERPRISE_ID, :PI_USER_NAME , :PI_APP_NAME); en
d;

Changes

Cause

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