Mapping Rules Fail with User Requested Termination / Semget Failed / CMultileafLUT Errors (Doc ID 748700.1)

Last updated on OCTOBER 20, 2015

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Oracle Profitability Manager - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance on 31-Jan-2013.

Symptoms

In Oracle Profitability Manager 11i, all Mapping Rules are failing with User Requested Termination errors or "CMultileafLUT: Failed to create enough semaphores" errors.  After you turn on the FEMCCE Debug, "semget failed" errors appear.  The errors are preventing the Mapping Rules from outputting results.  After one Mapping Rule receives the error, all Mapping Rules receive the errors.

Initially, the View Log contains User Requested Termination errors:

*** FCFilterCondition: SqlStr returned: (a.FINANCIAL_ELEM_ID = 280248) AND (a.USER_DIM6_ID = 280334) AND (a.LINE_ITEM_ID = 307183) 
AND (((a.DATASET_CODE =11002) and a.CAL_PERIOD_ID =24545260000000000000021100200140)) OR((a.DATASET_CODE =28008) AND (a.CREATED_BY_OBJECT_ID NOT IN 11438)) AND (a.LEDGER_ID = 21003)
[31156] User requested termination
[31159] User requested termination
[31160] User requested termination
[31167] User requested termination
[31158] User requested termination

Or "CMultileafLUT: Failed to create enough semaphores":

*** FCFilterCondition: SqlStr returned: a.CHANNEL_ID IN ( SELECT CHILD_ID FROM FEM_CHANNELS_HIER WHERE CHILD_ID IN (126390) AND HIERARCHY_OBJ_DEF_ID = 107102 AND PARENT_DEPTH_NUM = 1 AND PARENT_VALUE_SET_ID = 10042 AND CHILD_VALUE_SET_ID = 10042 UNION ALL SELECT CHILD_ID FROM FEM_CHANNELS_HIER WHERE PARENT_ID IN (126550,126390) AND HIERARCHY_OBJ_DEF_ID = 107102 AND PARENT_ID <> CHILD_ID AND PARENT_VALUE_SET_ID = 10042 AND CHILD_VALUE_SET_ID = 10042) AND (a.FINANCIAL_ELEM_ID = 131973) AND (((a.DATASET_CODE =14024)and(a.CAL_PERIOD_ID =24555930000000000000011200200140)) OR((a.DATASET_CODE =14036)and(a.CAL_PERIOD_ID =24555930000000000000011200200140)) OR((a.DATASET_CODE =14020)and(a.CAL_PERIOD_ID =24555930000000000000011200200140)) OR((a.DATASET_CODE =14022)and(a.CAL_PERIOD_ID =24555930000000000000011200200140)) OR((a.DATASET_CODE =14026)and(a.CAL_PERIOD_ID =24555930000000000000011200200140)) ) AND (a.CREATED_BY_OBJECT_ID NOT IN(62866)) AND (a.LEDGER_ID = 3018)

CMultileafLUT: Failed to create enough semaphores.
/opt/app/p1pft1j2/p1pft1d2appl/fem/11.5.0/bin/FEMCCE
Program was terminated by signal 11

 

 However, after turning on the FEMCCE debug  (see <Document ID 417446.1>), the user requested termination errors are replaced by the following in the View Log:

Module Logging OFS Access module data: begin FEM_Engines_Pkg.Get_PB_Param_Value( P_OBJECT_TYPE_CODE => 
:ObjectTypeCode, P_STEP_NAME => :StepName, P_OBJECT_ID => 
:ObjectId, P_PARAMETER_NAME => :ParamName, X_PB_PARAM_DATA_TYPE 
=> :ParamDataType, X_PB_PARAM_VALUE => :ParamValue, X_MSG_COUNT 
=> :MsgCount, X_MSG_DATA => :MsgData, X_RETURN_STATUS => 
:ReturnStatus) ; end; 

Module Logging OFS errors: semget failed, errno = 17, file 6941520/ fem/ lib/ ipcmutex.cpp, 
line 185 

Module Logging OFS errors: semget failed, errno = 17, file 6941520/ fem/ lib/ ipcmutex.cpp, 
line 185 

Module Logging OFS errors: semget failed, errno = 17, file 6941520/ fem/ lib/ ipcmutex.cpp, 
line 185 

Module Logging OFS errors: semget failed, errno = 17, file 6941520/ fem/ lib/ ipcmutex.cpp, 
line 185

The following errors also appear in the View Log:

Module Logging OFS errors: APP- FEM- 416961: Failed to run CCE.

Module Logging OFS errors: APP- FEM- 416645: Fatal error during processing.


There are no errors in the database alert log.

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