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 MAY 03, 2023

Applies to:

Symptoms

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:
!csImportErrorForArchiveInCollection,content-subset-1,ucm_cluster!csArchiverTableUnableToImport,18-nov-28_14.25.01_700_03/ECOM_NON_GUIDE_TOPIC_DETAILS_arTable~1.hda!csArchiverTablePrimaryKeysNotExist,ECOM_NON_GUIDE_TOPIC_DETAILS
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

Changes

Cause

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