My Oracle Support Banner

How To Recover From Deadlock error In IREL Log (Doc ID 846155.1)

Last updated on OCTOBER 09, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 and later
Information in this document applies to any platform.

Goal

There is one rated CDR file that is sent to error directory when IREL fails with the following error message:

PIN_REL log:

Error 06/05/09 8:18:25:0136 PM ( 1244200705137 ) T:Update SP Thread 4 REL RELUpdaterThread 1:dev:UnknownProgramName:0:Update SP Thread 4:0:1244200705:0
ORA-20003: Error -20013error while processing data from event_essentials occurred in the update procedure start_obj_id0 = 1406248984949656399 end_obj_id0 = 1406248984949656403
sqlcode = -20013 sqlerrm = ORA-20013: Error -60 occurred in the update account balances
ORA-00060:deadlock detected while waiting for resource
ORA-06512: at "PIN.PIN_REL", line 2765
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "PIN.PIN_REL", line 3439
ORA-20013: Error -60 occurred in the update account balancesORA-00060: deadlock detected while waiting for resource
ORA-06512: at "PIN.PIN_REL", line 2765
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at line 1

Error 06/05/09 8:19:06:0006 PM ( 1244200746006 ) T:main REL IREL 1:dev:UnknownProgramName:0:main:1:1244200555:0
Error encountered in the Update Stored Procedure: 8003
The update stored procedure encountered an error on an update statement.
Error 06/05/09 8:19:06:0009 PM ( 1244200746009 ) T:main REL IREL 1:dev:UnknownProgramName:0:main:1:1244200555:0
Exiting with return code: 8

 
How to recover from this error ? Can one load the file again using PIN_REL with -override option ?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.