GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

OCI Error ORA-26787 with ORA-01403: no data found in OGG(Target)

edited Nov 28, 2019 8:48PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered ✓

Error from Discard Log -

*

Current time: 2019-04-04 18:14:50

OCI Error ORA-26787: The row with key ("AUDIT_CHANGED_DATETIME", "AUDIT_STATUS", "BUSINESS_DATE", "DATA_STATUS", "DAY", "FILES_LOADED", "INV_BUS_DATE_IND", "INV_STORE_IND", "STORE", "STORE_CLOSED_DATETIME", "STORE_DAY_SEQ_NO", "STORE_STATUS") = (, R, 2019-02-19:00:00:00, P, 19, 2, N, N, 13004, , 11060072, W) does not exist in table RMS13PROD.SA_STORE_DAY

ORA-01403: no data found

ORA-01403: no data found

Operation failed at seqno 14 rba 4309812 Discarding record on action DISCARD on error 1403 Problem replicating RMS13PROD.SA_STORE_DAY to RMS13PROD.SA_STORE_DAY Record not found Mapping problem with compressed key update record (target format)...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center