Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Could not determine the primary key columns to build a unique WHERE clause for applying a change record to the table" while running the Applier in UDR
Problem Description
In Universal Data Replication (UDR), the applier fails with the following error:

(90D59700) IDR-070059 E Could not determine the primary key columns to build a unique WHERE clause for applying a change record to the table '"ODS_PET_AAAAA"."TABLE_AAAA"'. SCN: 859686nnnnnnn.
(90D59700) IDR-070062 E The Applier thread 242991xxxx encountered an OTL or database error in the function 'ParallelPostRecordTask::FlushChangeRecordToDestination'.
(90D59700) IDR-070061 E The Applier thread 242991xxxx encountered an OTL or database error in the function 'ParallelPostRecordTask::svc'.
(75DEB3E0) IDR-070090 E The Applier thread 0 returned the error code 5.
(75DEB3E0) IDR-070082 E The Applier encountered a fatal error.
(75DEB3E0) IDR-070132 E Could not finalize the 'PostTaskExecutor' mechanism that distributes records from the intermediate files across Applier threads.
(75DEB3E0) IDR-000483 I The Data Replication process ends with the exit code -1.
Cause
Applier failed to find primary key and other rows of records because supplemental logging for all the columns for table "ODS_PET_AAAAA"."TABLE_AAAA" was not enabled.

Solution

To resolve the issue, do as follows:

  1. Enable Supplemental log group (SLG) at column level of source table.
  2. Recreate configuration.
  3. Perform initial sync.
  4. Run delta job. 

More Information
Applies To
Product: Universal Data Replication
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:6/26/2019 10:51 PMID:570833
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)