Error ORA-01430 When Upgrading From OHI Claims 2.17.1 To 2.17.2 (Doc ID 2288641.1)

Last updated on JULY 20, 2017

Applies to:

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

Symptoms

On :  2.17.2.0.0 version, Installation


An ORA-01430 error is thrown when upgrading from OHI Claims 2.17.1 to 2.17.2  See error below.
A workaround is a  fresh-install of 2.17.2.

ERROR
-----------------------
ORA-01430

SEVERE 7/11/17 6:01 PM:liquibase: Change Set
2016-04-04_REL-34_UUID.xml::1::smichels failed.  Error: Error executing
SQL ALTER TABLE REL_RELATIONS ADD UUID VARCHAR2(36 char): ORA-01430:
column being added already exists in table

liquibase.exception.DatabaseException:
 Error executing SQL ALTER TABLE REL_RELATIONS ADD UUID VARCHAR2(36
char): ORA-01430: column being added already exists in table

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)


The issue can be reproduced at will with the following steps:

- Execute util/install/ohi-update.sh from install-media for 2.17.2

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