Product Definition Upgrade from 2.16.1 to 2.17.1 Failed with Unique Key Violation
Last updated on FEBRUARY 06, 2018
Applies to:Oracle Health Insurance Product Definition - Version 126.96.36.199.0 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