Running Calculation Fails with 'CFE execution failed or function failed with generic exception' and 'Cannot open shared object file: No such file or directory' Errors (Doc ID 2208268.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)

Symptoms

On BSP 8.0.2.0.2, during calculation in "Financial Plan Default" for "Current Business" the ofsrm process encountered the following errors in the BSPCalculation_UnpricedAcc_udf.log:

ERROR

2016-11-17 11:55:31,360 INFO com.oracle.bsp.udf.BSPExtComponet :: BSP_200057_20160831
2016-11-17 11:55:31,360 INFO com.oracle.bsp.udf.BSPExtComponet :: /essbase/EPMSystem11R1/products/Planning/bin/ofsrm.sh BSP_200057_20160831 OFSRM TASK1 20160831 200057 ADMIN BSP BSP_REG
2016-11-17 11:55:31,360 INFO com.oracle.bsp.udf.BSPExtComponet :: Directory : /essbase/EPMSystem11R1/products/Planning/bin
2016-11-17 11:55:31,360 INFO com.oracle.bsp.udf.BSPExtComponet :: command : /essbase/EPMSystem11R1/products/Planning/bin/ofsrm.sh BSP_200057_20160831 OFSRM TASK1 20160831 200057 ADMIN BSP BSP_REG
2016-11-17 11:55:31,363 INFO com.oracle.bsp.udf.BSPExtComponet :: Getting the process status
2016-11-17 11:55:31,365 INFO com.oracle.bsp.udf.StreamGobbler1 :: EPM_ORACLE_HOME : /essbase/EPMSystem11R1
2016-11-17 11:55:31,371 INFO com.oracle.bsp.udf.StreamGobbler1 :: OS
2016-11-17 11:55:31,375 INFO com.oracle.bsp.udf.StreamGobbler1 :: /essbase/EPMSystem11R1/products/Planning/bin/ofsrm: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
2016-11-17 11:55:31,376 INFO com.oracle.bsp.udf.BSPExtComponet :: Final CFE return status :127
2016-11-17 11:55:31,376 INFO com.oracle.bsp.udf.BSPExtComponet :: CFE execution Failed
2016-11-17 11:55:31,376 INFO com.oracle.bsp.udf.BSPCfeCall :: ============================== Status : 127 Process Id : 200057
2016-11-17 11:55:31,376 INFO com.oracle.bsp.udf.BSPCfeCall :: Procedure PR_RES_DET_IMPORT is not exceuted because CFE execution failed or function failed with generic exception

Checked the LD_LIBRARY_PATH and it points to the proper library files. Executed in foreground in terminal window with same error. This has never previously working on this instance.

The issue can be reproduced at will with the following steps:
1. Run calculation in "Financial Plan Default" for "Current Business"
2. Check the BSPCalculation_UnpricedAcc_udf.log for errors

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