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:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 8.0.5
Oracle Financial Services Funds Transfer Pricing (FTP) 8.0.5
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
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 |
References |