Replicat Abends With Database Error 6550 () When Applying Sequence Operation (Doc ID 2183923.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

Replicat abends with following error

2016-09-17 18:28:58 INFO OGG-02759 The definition for table SCOTT.EMPID is obtained from the target database.

2016-09-17 18:28:58 INFO OGG-06513 Resolving target sequence : SCOTT.EMPID.

2016-09-17 18:28:59 WARNING OGG-01004 Aborted grouped transaction on 'SCOTT.EMPID', Database error 6550 ().

Error message in the discard file
==========================

Aborting transaction on /ggs/dirdat/remote/ch/eai/r1 beginning at seqno 20 rba 32503915
  error at seqno 2 rba 98764
Problem replicating SCOTT.EMPID to SCOTT.EMPID
Mapping problem with compressed update record (target format)...
*
No columns were available
*

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