CCSCD1 DEL Fails With "ORA-00060: Deadlock Detected While Waiting For Resource" (Doc ID 2020954.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.2 to 5.0.3 [Release 5.0]
Information in this document applies to any platform.

Symptoms

The PImanager complains with "ORA-00060: deadlock detected while waiting for resource" when the following sequence of PI requests scenario is continuously requested over a pool of MSISDNs.

Create Subscriber → (delay 1.5 sec) → Change Profile Tags → Activate → Change MSISDN → Deactivate → Delete MSISDN (CCSCD1 DEL)

The Delete command reports the following deadlock error once in a while :

May 22 12:44:18 scch01prsms01 PIprocess:8007: [ID 438867 user.warning] PIprocess:8007(10806) WARNING Oracle=-60 CCSCD1_oracle.pcc@814: delete from ccs_acct_reference where id=:b0: ORA-00060: deadlock detected while waiting for resource

This happens with NCC 5.0.2.

It is expected that Delete commands always properly complete.

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