BSP Complete Calculation Failed Due to ORA-12801 and ORA-12516 (Doc ID 2219121.1)

Last updated on DECEMBER 30, 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 Analytical Applications (OFSAA)

Symptoms

On : 8.0.2.0.2 version, Calculation Engine

When submitting a complete calculation at higher node, the following error occurs.

Error:
fsi_bsp_process_log shows:

"[MSG-FATAL]: ERROR OCCOURED WHILE POPULATING FSI_FINANCIAL_PLAN
[ORA:ERR] ORA-12801: ERROR SIGNALED IN PARALLEL QUERY SERVER P718, INSTANCE LDOHSDESJSD09:DDES171 (1)
ORA-00379: NO FREE BUFFERS AVAILA"

"BSPCalculation_UnpricedAcc_udf.log" shows:
 | strBatchId : BSP_200489_20160831 | strComponentId : OFSRM | Process ID : 200489 | User ID : ADMIN |
2016-12-16 08:41:39,886 INFO com.oracle.bsp.udf.StreamGobbler1 :: Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
2016-12-16 08:41:39,886 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2016-12-16 08:41:39,886 INFO com.oracle.bsp.udf.StreamGobbler1 :: OCI Function: [0] - olon(), orlon()
2016-12-16 08:41:39,886 INFO com.oracle.bsp.udf.StreamGobbler1 :: Oracle Error: [12516] - ORA-12516: TNS:listener could not find available handler with matching protocol stack
2016-12-16 08:41:39,886 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2016-12-16 08:41:39,886 INFO com.oracle.bsp.udf.StreamGobbler1 :: Driver Function: drv_oci::Connect()
2016-12-16 08:41:39,887 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2016-12-16 08:41:39,887 INFO com.oracle.bsp.udf.StreamGobbler1 :: MB(AttachDB()) Error attaching to database: DDES17
2016-12-16 08:41:39,899 INFO com.oracle.bsp.udf.BSPExtComponet :: Final CFE return status :1
2016-12-16 08:41:39,899 INFO com.oracle.bsp.udf.BSPExtComponet :: CFE execution Failed

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