My Oracle Support Banner

Why IM Repository Export *.zip (WITHOUT "Content Records Included") Import/Merge Failed With "ORA-00001: unique constraint (OK_IM.PK_LOCALE) violated" (Doc ID 2008898.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Knowledge - Version 8.2.3 and later
Information in this document applies to any platform.


Failed to import IM repository *.zip (WITHOUT "Content Records Included") via IM Console UI with exception/error:
[GC 1042034K->158570K(2835328K), 0.0825550 secs]
[GC 1057066K->159612K(2830976K), 0.1276410 secs]
82095253 [Thread-21] ERROR - java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OK_IM.PK_LOCALE) violated

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OK_IM.PK_LOCALE) violated

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(


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.