Calculation program is failing with dead lock error very frequently in R12.2

Cause:

The deadlocks appear to have been caused by the database table storage parameter initrans being set too low.  The default value for initrans is 10 for cn_commission_headers_all and cn_commission_lines_all.

Solution:

(1) You can check the current value of the initrans table storage parameter with the following SQL queries:
select ini_trans from all_tables where table_name = ‘CN_COMMISSION_HEADERS_ALL’;
select ini_trans from all_tables where table_name = ‘CN_COMMISSION_LINES_ALL’;
(2) Increase the initrans table storage parameter from the default value to 50 with the following SQL statements:
alter table CN.CN_COMMISSION_HEADERS_ALL INITRANS 50;
alter table CN.CN_COMMISSION_LINES_ALL INITRANS 50;
(3) Check to see if the calculation is still having deadlocks.
  • July 3, 2019 | 18 views
  • Comments