Upgrade Issue With New Patch OIG 3.20.2.0.3 (Doc ID 2724547.1)

Last updated on JUNE 21, 2021

Applies to:

Symptoms

On : 3.20.2.0.3 version, Installation

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

ERROR
-----------------------
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 com.oracle.healthinsurance.install.Install$LiquibaseInvoker - Liquibase Update Failed: %s
liquibase.exception.MigrationFailedException: Migration failed for change set 2019-04-05_HTA-268_RESOURCE_CACHE_SETTING.xml::1::jverheul:
  Reason:
  master.xml : liquibase.precondition.core.SqlPrecondition@74e6094b : ORA-00942: table or view does not exist
 
  at liquibase.changelog.ChangeSet.execute(ChangeSet.java:559)
  at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
  at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83)
  at liquibase.Liquibase.update(Liquibase.java:202)
  at liquibase.Liquibase.update(Liquibase.java:179)
  at liquibase.Liquibase.update(Liquibase.java:175)
  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

Cause

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