ECE Transaction Locks are not Cleared Even After TransactionLockCleanupInterval (Doc ID 2960481.1)

Last updated on OCTOBER 02, 2023

Applies to:

Goal

 In an active-active setup, the following parameters have been enabled post commit feature on Billing and Revenue Manager (BRM) & Elastic Charging Engine (ECE).

 Randomly the locks are not cleared, which leads to any other operation on the account is not allowed.

The following error can be seen on CustomerUpdater log:

SELECT COUNT(*) num_categories FROM ece_site_category_t) sc) c WHERE c.site_category = s.id and c.rn=1)
java.sql.SQLSyntaxErrorException: ORA-918: column ambiguously defined

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)

Solution

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