My Oracle Support Banner

OHI Upgrade Failed Error: ORA-04021: timeout occurred while waiting to lock object (Doc ID 2210345.1)

Last updated on MAY 05, 2018

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.15.1.0.0 and later
Information in this document applies to any platform.
***Reviewed for relevance on 5-May-2018***

Symptoms

When upgrading to OHI Claims 2.16.1 an error occurred:


SEVERE 11/16/16 6:01 PM:liquibase: Error executing SQL create or replace package cla_data_purge_pkg
as
/*============================================================================
  Function
  --------
  Purges tables:
  o enrollments and their details
  o payment status and their details
  o callout executions and details

  Parameters
  ----------
  p_purge_days : the amount of days to purge data in the past
 ============================================================================*/
 procedure purge_data
 ( p_purge_days in integer
 );

end cla_data_purge_pkg;
java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object


Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.