My Oracle Support Banner

OGG Integrated Replicat (IR) errors with ORA-26787 or applies bad numeric data when DBOPTIONS INTEGRATEDPARAMS (parallelism n) is greater than 1 (Doc ID 2195583.1)

Last updated on SEPTEMBER 28, 2021

Applies to:

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

Symptoms

Oracle GoldenGate (OGG) Integrated Replicat (IR) exhibits one of the following issues when PARALLELISM is greater than 1

1. IR applies data read from the OGG trails in incorrect order causing the replicat to abend with ORA-1403 error or (ORA-26787: The row with key  does not exist in table )

2. IR can miss certain data causing Data Integrity issues.

3. IR can apply bad numeric data 

 

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!

In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.