Unable To Create Folders on Import Due To Primary Key Constraint Error (Doc ID 793076.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.2 and later
Information in this document applies to any platform.

Symptoms

The creation of folders from one server to another by the process of replication is stopped by an error with primary key constraint errors.

The content server had the following error message in its log file:

csFoldersArchiveError Unable to execute SQL statement 'INSERT INTO ColMeta (dCollectionID) VALUES (465)'. Violation of PRIMARY KEY constraint 'PK_CollectionMeta'. Cannot insert duplicate key in object 'dbo.ColMeta'. java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_CollectionMeta'. Cannot insert duplicate key in object 'dbo.ColMeta'.







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