ORA-00060 Deadlock Occurred While Running Concurrent Calculations in BSP (Doc ID 2184303.1)

Last updated on OCTOBER 07, 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

Deadlock occurred while running multiple concurrent calculations in Balance Sheet Planning (BSP).


Error:
fsi_bsp_process_log shows:
[MSG-FATAL]: ERROR OCCOURED WHILE POPULATING FSI_FINANCIAL_PLAN [ORA:ERR] ORA-00060: DEADLOCK DETECTED WHILE WAITING FOR RESOURCE.

RDBMS trace file at $ORACLE_HOME/admin/<SID>/udump shows below::

----- Dump Cursor sql_id=4203v74d19dfd xsc=0x7ff5344c1b30 cur=(nil) -----

LibraryHandle: Address=0xc45f9058 Hash=1a14b5cd LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name= select /*+ all_rows */ count(1) from "EPMBSPMODEL"."FSI_FBAL_ROLL_INTO" where "FBAL_SYS_ID" = :1 and "PRODUCT_ID" = :2 and "CCY_CD" = :3 and "ORG_UNIT_ID" = :4 and "STRATEGY_ID" = :5 and "CUSTOM1" = :6 and "CUSTOM2" = :7
FullHashValue=947aa70389fcd93941007b391a14b5cd Namespace=SQL AREA(00) Type=CURSOR(00) ContainerId=0 ContainerUid=0 Identifier=437564877 OwnerIdn=0
Statistics: InvalidationCount=0 ExecutionCount=93591 LoadCount=2 ActiveLocks=2 TotalLockCount=13 TotalPinCount=1
Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=1 Version=0 BucketInUse=12 HandleInUse=12 HandleReferenceCount=0
Concurrency: DependencyMutex=0xc45f9108(0, 176, 0, 0) Mutex=0xc45f91a0(0, 1681, 1, 0)
Flags=RON/PIN/TIM/PN0/DBN/[10012841] Flags2=[0000]
WaitersLists:
Lock=0xc45f90e8[0xc45f90e8,0xc45f90e8]
Pin=0xc45f90c8[0xc45f90c8,0xc45f90c8]
LoadLock=0xc45f9140[0xc45f9140,0xc45f9140]
Timestamp: Current=08-01-2016 10:14:04
HandleReference: Address=0xc45f92f0 Handle=(nil) Flags=[00]
LibraryObject: Address=0x1827b44f8 HeapMask=0000-0001-0001-0000 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000]
ChildTable: size='16'
Child: id='0' Table=0x1827b5378 Reference=0x1827b4e18 Handle=0xa2dab638
Children:
Child: childNum='0'

..etc

ended with

*** 2016-08-08 17:32:44.332
Attempting to break deadlock by signaling ORA-00060


Steps:

1.  Selected three different entity nodes, for the same product node and launched them concurrently.
2. The processes quickly failed with the above error.

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