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

Last updated on DECEMBER 02, 2016

Applies to:

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

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

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