Product Definition Upgrade from 2.16.1 to 2.17.1 Failed with Unique Key Violation

(Doc ID 2357978.1)

Last updated on FEBRUARY 06, 2018

Applies to:

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


Started the upgrade from 2.16.1 to 2.17.1 and upgrade failed with below error in our PRODDEF environment.


[Wed Jan 17 02:27:17 EST 2018] [WARNING] Caught exception committing connection: ORA-02091: transaction rolled back
ORA-00001: unique constraint (OHI_PRODDEF_OWNER.OHI_BOILERPLATE_TEXT_UK1) violated

[Wed Jan 17 02:27:17 EST 2018] [INFO] Import failed. Retrying once more to check for possible constraint violations...
 Jan 17 02:27:25 EST 2018] [SEVERE] GEN-PROC-012: Migration has failed.
Unique key violation for the User table. The rows with ID [] have the
same logical identifier [LOGIN_NAME:[null]]




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