Batch With Many FTP Processes Fails in the Middle of Processing With 'semget failed' (Doc ID 2746300.1)

Last updated on JULY 26, 2023

Applies to:

Symptoms

When running a Batch with many FTP Processes, the Batch consistently fails at a certain Task.  The batch contains Adjustment FTP Processes with Alternate Rate Output in addition to standard FTP Processes.  For the Task that fails, an Adjustment Task, the ofstp log from $FIC_DB_HOME/log/FusionApps ends with the following SQL:

Module Logging OFS calculation module data: select
select distinct a.ISO_CURRENCY_CD, a.PRODUCT_ID
from FSI_D_TERM_DEPOSITS a
where (((a.ADJUSTABLE_TYPE_CD = '0')))
and as_of_date = to_date('12/ 31/ 2020', 'mm/ dd/ yyyy')
and LEGAL_ENTITY_ID = -1
order by a.ISO_CURRENCY_CD, a.PRODUCT_ID 

Module Logging OFS calculation module data: Executing: ISO_CURRENCY_CD:EUR, PRODUCT_ID: 10000000001

Module Logging OFS Access module data: /*cl_ids.cpp :: BOOL TP_Context::FindTP(const FTPKey& Key) */

If you check the ofstp log for the Task prior to the one that fails, it contains the following errors:

Module Logging OFS errors: semget failed, errno = 28, file ipcmutex.cpp, line 205

Module Logging OFS errors: semget failed, errno = 28, file ipcmutex.cpp, line 251

Module Logging OFS errors: semget failed, errno = 28, file ipcmutex.cpp, line 205

Clearing shared memory does not fix the issue.  Re-starting services also had no impact.  The nohup.out from $FIC_DB_HOME/bin does not contain any errors.

You can run the FTP Process that fails from FTP Processing > Standard Process and it completes successfully.  It only fails in the Batch.

Cause

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