OGG-00017 Not enough stack space error with OGG-00869 No unique key is defined for table
Last updated on JANUARY 12, 2017
Applies to:Oracle GoldenGate - Version 220.127.116.11.6 and later
Information in this document applies to any platform.
On : 18.104.22.168.6 version, 1 - Oracle DB backend
When attempting to replicate a table,
the following errors occur.
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.
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
The Unique Index was dropped on the table being replicated
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