My Oracle Support Banner

Product Definition Upgrade from 2.16.1 to 2.17.1 Failed with Unique Key Violation (Doc ID 2357978.1)

Last updated on SEPTEMBER 09, 2019

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]]




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.