My Oracle Support Banner

BSP 8.0.5 Node Level Calculation does Not Finish (Doc ID 2402123.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.5.0.0 version, Calculation Engine

When running BSP Node level complete calculation for Node Level Entity and COA member selections, the process hang and did not finish.


Error

2018-04-17 16:18:34,977 INFO com.oracle.bsp.udf.StreamGobbler1 :: | strBatchId : BSP_203550_20170731 | strComponentId : OFSRM | Process ID : 203550 | User ID : ADMIN |
2018-04-17 16:18:35,117 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2018-04-17 16:18:35,117 INFO com.oracle.bsp.udf.StreamGobbler1 :: ProcSysID = 203550
2018-04-17 16:18:35,259 INFO com.oracle.bsp.udf.StreamGobbler1 :: Running Oracle ALM, Process Rule: 203550 Engine started execution
2018-04-17 16:18:35,259 INFO com.oracle.bsp.udf.StreamGobbler1 :: 1 | OFSAA.EXEC_STARTED | INFORMATION
2018-04-17 16:18:35,314 INFO com.oracle.bsp.udf.StreamGobbler1 :: Setting Strategy Flag
2018-04-17 16:18:35,314 INFO com.oracle.bsp.udf.StreamGobbler1 :: Setting Custom1 Flag
2018-04-17 16:18:35,314 INFO com.oracle.bsp.udf.StreamGobbler1 :: Setting Custom2 Flag
2018-04-17 16:18:35,318 INFO com.oracle.bsp.udf.StreamGobbler1 :: Strategy Leaf : 5
2018-04-17 16:18:35,318 INFO com.oracle.bsp.udf.StreamGobbler1 :: custom1_leaf : 6
2018-04-17 16:18:35,318 INFO com.oracle.bsp.udf.StreamGobbler1 :: custom2_leaf : 7
2018-04-17 16:18:36,834 INFO com.oracle.bsp.udf.StreamGobbler1 :: TPWrapper Class is initialized
2018-04-17 16:18:52,808 INFO com.oracle.bsp.udf.StreamGobbler1 :: Warning: iso88951 does not exist.
2018-04-17 16:18:52,819 INFO com.oracle.bsp.udf.StreamGobbler1 :: Warning: Warning: iso88951 does not exist.
2018-04-17 16:18:52,819 INFO com.oracle.bsp.udf.StreamGobbler1 :: iso88951 does not exist.
...etc
2018-04-17 16:18:52,844 INFO com.oracle.bsp.udf.StreamGobbler1 :: Warning: iso88951 does not exist.
2018-04-17 16:34:33,004 INFO com.oracle.bsp.udf.StreamGobbler1 :: /usr/local/epm/Oracle/Middleware/EPMSystem11R1/products/Planning/bin/ofsrm.sh: line 19: 31095 Killed
$EPM_ORACLE_HOME/products/Planning/bin/ofsrm $1 $2 $3 $4 $5 $6 $7 $8
2018-04-17 16:34:33,005 INFO com.oracle.bsp.udf.BSPExtComponet :: Final CFE return status :137
2018-04-17 16:34:33,005 INFO com.oracle.bsp.udf.BSPExtComponet :: CFE execution Failed
2018-04-17 16:34:33,005 INFO com.oracle.bsp.udf.BSPCfeCall :: ================================================ Status : 137 Process Id : 203550
2018-04-17 16:34:33,005 INFO com.oracle.bsp.udf.BSPCfeCall :: Procedure PR_RES_DET_IMPORT is not exceuted because CFE execution failed or function failed with generic exception
2018-04-17 16:34:33,005 INFO com.oracle.bsp.udf.BSPCfeCall :: --------------------------------------------------------
2018-04-17 16:34:33,005 INFO com.oracle.bsp.udf.BSPCfeCall :: importFunction not exceuted because CFE execution failed or function failed with generic exception
2018-04-17 16:34:33,006 INFO com.oracle.bsp.udf.BSPCfeCall :: ###################################################################
2018-04-17 16:34:33,006 INFO com.oracle.bsp.udf.BSPCfeCall :: financial plan procedure PR_FINANCIAL_PLAN executed sucessfully
2018-04-17 16:34:33,006 INFO com.oracle.bsp.udf.BSPCfeCall :: Function called sucessfully and returning process id 203550
2018-04-17 16:34:33,006 INFO com.oracle.bsp.udf.BSPCfeCall :: CFE execution failed with executed status is 137

Steps to Replicate:
1. Running calculate using Node Level Entity and COA member selections does not finish.  The calculations are all using Target Average Forecast Balance Method, and New Add Rate Pricing Method.
2. The engine makes it through all the preparation phases successfully, and the engine just keeps running and writing to the ofsrm. log file.
    For example: ran for node level entity and leaf level COA wrote out 267MG of data to the log file before job has to be killed manually. Previous runs have written out HUGE amounts to the log file (Gigs).
3. Running calculate using Node Level COA and Leaf level Entity member completes successfully.
4. Calculate for Node Level Entity and Coa members was not a big job - one coa and 18 entity leaves under the node level entity processed.
5. Current Position calculation is completed successfully.


Changes

 The calculation was successful on BSP 8.0.2.0.9 prior to the upgrade.

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!


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