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

Last updated on OCTOBER 10, 2019

Applies to:

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

Cause

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