OGG-00017 Not enough stack space error with OGG-00869 No unique key is defined for table (Doc ID 1624335.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Symptoms

On : 11.2.1.0.6 version, 1 - Oracle DB backend

When attempting to replicate a table,
the following errors occur.

ERRORS
-----------------------
OGG-00869 No unique key is defined for table 'table-name'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key. Using following columns in default map by name: (200+ columns listed)
OGG-00017 Not enough stack space. Specify FUNCTIONSTACKSIZE greater than 200.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to re-instantiate the table using import, but get unique key violations
2. Drop the unique key and import successfully.
3. Start GoldenGate EXTRACT and REPLICAT
4. REPLICAT reports OGG-00869 and OGG-00017 errors

Changes

 The Unique Index was dropped on the table being replicated

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