Deadlocks Appear When Using Pin_Rel (Doc ID 408907.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.1 and later
Oracle Solaris on SPARC (32-bit)
Solaris Operating System (SPARC)

***Checked for relevance on 19-Jan-2010***
***Checked for relevance on 15-Dec-2012***

Symptoms

When trying to load a big amount of CDR files (around 300 files), pin_rel returns the following errors in its log files (DB Dead-lock):

ORA-20003: error while processing data from event_essentials occurred in the

update procedure start_obj_id0 = 1384276343293405440 end_obj_id0 =

1384276343293405445 sqlcode = -20013 sqlerrm = ORA-20013: Error -60 occurred in the update account balances ORA-00060: deadlock detected while waiting for resource.

 

 

 

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