OHI Application Log: What Does Error ORA-00054 Related To Limit Counters Mean? (Doc ID 1536793.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.12.3 and later
Information in this document applies to any platform.

Goal

What does it mean when the OHI Application Log contains the following information?


Internal Exception: java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Error Code: 54
Call: select 1 from cla_limit_counters lico_lock where lico_lock.id in (select lcon.lico_id from cla_limit_consumptions lcon where lcon.clai_id = ? and lcon.ind_reversed = 'N' union all select lico.id from cla_limit_counters lico join cla_limit_consumptions lcon on lcon.lico_id = lico.lico_id where lcon.clai_id = ? and lcon.ind_reversed = 'N' and lcon.service_date >= lico.carryover_start_date ) for update nowait
  bind => [1356339, 1356339]
Query: DataReadQuery(sql="select 1 from cla_limit_counters lico_lock where lico_lock.id in (select lcon.lico_id from cla_limit_consumptions lcon where lcon.clai_id = ? and lcon.ind_reversed = 'N' union all select lico.id from cla_limit_counters lico join cla_limit_consumptions lcon on lcon.lico_id = lico.lico_id where lcon.clai_id = ? and lcon.ind_reversed = 'N' and lcon.service_date >= lico.carryover_start_date ) for update nowait ")
  at com.oracle.healthinsurance.claims.domain.internal.accumulators.components.BaseConsumptionService.finalizeAllConsumptions(BaseConsumptionService.java:87) ~[ohi-claims-domain-impl-2.12.3.0.6.jar:na]
  at com.oracle.healthinsurance.claims.domain.internal.accumulators.components.LimitConsumptionServiceImpl.finalizeAllConsumptions(LimitConsumptionServiceImpl.java:68) ~[ohi-claims-domain-impl-2.12.3.0.6.jar:na]
  at com.oracle.healthinsurance.claims.domain.internal.accumulators.components.ClaimConsumptionProcessingCoordinatorImpl.finalizeAllConsumptions(ClaimConsumptionProcessingCoordinatorImpl.java:41) ~[ohi-claims-domain-impl-2.12.3.0.6.jar:na]
  at com.oracle.healthinsurance.claims.domain.internal.adjudication.components.FinalizationService.finalizeConsumptions(FinalizationService.java:96) ~[ohi-claims-domain-impl-2.12.3.0.6.jar:na]
  at com.oracle.healthinsurance.claims.domain.internal.adjudication.components.FinalizationService.finalize(FinalizationService.java:83) ~[ohi-claims-domain-impl-2.12.3.0.6.jar:na]
 
etc.

Caused by: com.oracle.healthinsurance.support.exception.LockForUpdateException: Lock for update of LimitCounterDomain 1356339 failed, due to
Internal Exception: java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired


Solution

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