My Oracle Support Banner

Attempt to Import Table/Content via WebCenter Content (WCC) Archiver Result in Error: "Primary Keys Mismatch" or "does not have primary keys" (Doc ID 1988870.1)

Last updated on JULY 06, 2020

Applies to:

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


Attempt to import tables from WCC, import fails with error:  "Primary keys mismatch"

The WCC trace shows the following:
>systemdatabase/6 03.03 15:38:30.740 IdcServer-49 Retrieving primary keys for Catalog:null Schema:ZXDWCC_OCS Table:DOCUMENTCLASSIFICATION
>systemdatabase/6 03.03 15:38:30.742 IdcServer-49 run: 4.19 ms. total 9.40 ms. [Retrieved. Primary key contains 0 columns]
>archiver/6 03.03 15:38:30.742 IdcServer-49 Mismatch primary key, unable to proceed to sync table design.

where the "DOCUMENTCLASSIFICATION" is a custom table created in WCC Configuration Manager


Attempt to import content from WCC, import fails with error:  "does not have primary keys"

The WCC trace shows the following:
intradoc.common.ServiceException: !csArchiverTablePrimaryKeysNotExist,ECOM_NON_GUIDE_TOPIC_DETAILS
Import error for archive 'content-subset-1' in collection 'ucm_cluster': Unable to import table from file: 18-nov-28_14.25.01_700_03/GUIDELINE_SUB_TOPICS_arTable~1.hda Table ('GUIDELINE_SUB_TOPICS') does not have primary keys.

where the NON_GUIDE_TOPIC_DETAILS is a custom table created in WCC Configuration Manager



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
 Add primary keys on the custom table:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.