OGG EXTRACT PUMP Abend Column 'cust_id' cannot be used as a key column. (Doc ID 2136889.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

OGG EXTRACT PUMP using PASSTHRU:

***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 03:12:27

is abending with:

2016-04-27 13:57:57 INFO OGG-06507 MAP (TABLE) resolved (entry dbo.STORE): TABLE dbo.STORE.

2016-04-27 13:57:57 INFO OGG-02756 The definition for table dbo.STORE is obtained from the trail file.

2016-04-27 13:57:57 INFO OGG-06509 Using the following key columns for source table dbo.STORE: cust_id, store_id.

2016-04-27 13:57:57 ERROR OGG-00916 Column 'cust_id' cannot be used as a key column. Define a unique index for table 'dbo.STORE' without this column or use the KEYCOLS parameter to correct this issue.

Column 'cust_id' is Sybase int datatype.

We have tried using KEYCOLS with a separate column:

TABLE dbo.STORE, KEYCOLS (nhin_id);

but that fails as well.



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