My Oracle Support Banner

Replicat Abends with "Database error 1403" when Column of CHAR Data Type Is Included in Primary Key (Doc ID 2973752.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Replicat process abends with "Database error 1403" when column of CHAR data type is included in Primary Key.

ggserr.log

2022-11-14T23:43:46.643+0000  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, <replicat>.prm:  Aborted grouped transaction on <schema>.<table>, Database error 1403 (No data found).
2022-11-14T23:43:46.645+0000  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, <replicat>.prm:  Repositioning to rba 1958 in seqno 2.
2022-11-14T23:43:46.648+0000  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, <replicat>.prm:  SQL error 1403 mapping <schema>.<table> to <schema>.<table> No data found.
2022-11-14T23:43:46.650+0000  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, <replicat>.prm:  Error mapping from <schema>.<table> to <schema>.<table>.
2022-11-14T23:43:46.652+0000  INFO    OGG-02932  Oracle GoldenGate Delivery for Oracle, <replicat>.prm:  Reading <Path>/dirdat/l3000000002, current SEQNO 2, RBA 1,958, 0 records, m_file_seqno = 2, m_file_rba = 2,118.
2022-11-14T23:43:46.652+0000  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, <replicat>.prm:  PROCESS ABENDING.

Changes

 

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
Changes
Cause
Solution


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