OGG Errors Using Different Keycols for Exceptions Mapping and Base Table Mapping in the Same Replicat (Doc ID 1367010.1)

Last updated on DECEMBER 26, 2013

Applies to:

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

Symptoms

When using different keycols for base table mapping and exception mapping, the replicat might abend with errors.

The errors may differ depending on the datatype of the column used as key and test cases.


Aborting transaction on ./dirdat/e1 beginning at seqno 2 rba 1027
error at seqno 2 rba 1027
Problem replicating RGOVINDA.TESTCR to HR.TESTCR
Record not found
Mapping problem with delete record (target format)...

KEY1 = 1
LAST_CHANGED = 2011-09-20 13:18:05

OR

SSS1R04U.rpt:2011-09-14 16:37:53 WARNING OGG-00869 OCI Error ORA-01722:
invalid number (status = 1722), SQL <UPDATE "SSS"."SSS_EMPLOYEE"or

OCI Error ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
(status = 932), SQL <UPDATE "SSO"."USER_PROFILE" SET "SSOUSERINTERNALID" = :a1
 
 

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