My Oracle Support Banner

Extract Data Completed With WARNING OGG-06439 No Unique Key Is Defined For Table (Doc ID 2403962.1)

Last updated on MAY 29, 2018

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.6.0.0.0 to 2.7.0.0.0 [Release 2.6 to 2.7]
Information in this document applies to any platform.

Symptoms

Enabled the extracts to catch up the delta after completed the initial data load, from log file, lots of warnings reported as below:

For example, there is unique key defined on CCB1REP.CI_SA(SA_ID,JRN_EFF_START_DTTM) but in logs showing no unique key defined --

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.