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 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***


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.





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