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.

Symptoms

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 com.inquira.admin.data.ImportDataThread - 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(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)

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