My Oracle Support Banner

Upgrade Issue With New Patch OIG (Doc ID 2724547.1)

Last updated on JUNE 21, 2021

Applies to:

Oracle Health Insurance Product Definition - Version and later
Information in this document applies to any platform.


On : version, Installation

While upgrading to Patch of Oracle Health Insurance Integration Gateway we are seeing the below issue:

The patch number is 31893904.The table or view doesn't exist at all

[Wed Sep 16 15:52:22 CDT 2020] [SEVERE] Liquibase update failed. Please check the log file upgrade_OHI_OIG_OWNER_phase_major_1.log for more details
15:52:22.692 [main] ERROR$LiquibaseInvoker - Liquibase Update Failed: %s
liquibase.exception.MigrationFailedException: Migration failed for change set 2019-04-05_HTA-268_RESOURCE_CACHE_SETTING.xml::1::jverheul:
  master.xml : liquibase.precondition.core.SqlPrecondition@74e6094b : ORA-00942: table or view does not exist
  at liquibase.changelog.ChangeSet.execute(
  at liquibase.changelog.visitor.UpdateVisitor.visit(
  at liquibase.Liquibase.update(
  at liquibase.Liquibase.update(
  at liquibase.Liquibase.update(
  Caused by: liquibase.exception.DatabaseException: Error executing SQL select count(*) from ohi_tables_b where name = 'OHI_RESOURCE_CACHE_SETTINGS': ORA-00942: table or view does not exist


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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