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 OCTOBER 26, 2016

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

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