Last updated on DECEMBER 26, 2013
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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
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
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