Deadlock Error If Usage Loading (Pin_rel) And Bill Run Are Executed Concurrently
Last updated on FEBRUARY 26, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 09-09-2013 ***
Some of the bills are not generated in production if usage loading (pin_rel) and bill run (pin_bill_day) are executed concurrently.
Deadlock error messages in the logs indicate that some of the DB tables are locked by the pin_rel process.
We are running pin_rel with loading method Direct and as per our understanding, this will lock the partition of some of the tables while loading successfully rated CDRs.
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