Replicat abend and Logdump shows " Bad compressed block, found length " (Doc ID 2072869.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

OGG replicat abend due to bad data in the trail file.

2015-05-19 06:05:28 ERROR OGG-01296 Error mapping from <OWNER>.<TABLE> to <OWNER>.<TABLE>


The discard shows

Oracle GoldenGate Delivery for Oracle process started, group REP35 discard file opened: 2015-05-14 23:40:10.936126
Key column COL0 (0) is missing from update on table <OWNER>.<TABLE>
Key column COL1 (1) is missing from update on table <OWNER>.<TABLE>
Missing 2 key columns in update for table <OWNER>.<TABLE>.
Current time: 2015-05-19 06:05:28
Discarded record from action ABEND on error 0


Aborting transaction on ./dirdat/tf beginning at seqno 294 rba 81581612
  error at seqno 294 rba 81581851
Problem replicating <OWNER>.<TABLE> to <OWNER>.<TABLE>
Mapping problem with compressed update record (target format)...
*
*
------

The trail file shows bad data
***************

Logdump 1536 >ghdr on
Logdump 1537 >detail data
Logdump 1538 >ggstokens detail data
Logdump 1549 >pos 81581851
Reading forward from RBA 81581851
Logdump 1551 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 0 (x0000) IO Time : 2015/05/19 06:05:23.096.817
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 2887 AuditPos : 595816424
Continued : N (x00) RecCount : 1 (x01)

2015/05/19 06:05:23.096.817 FieldComp Len 0 RBA 81581851
Name: <OWNER>.<TABLE>
After Image: Partition 4 m
Bad compressed block, found length of 6 (x0006), RBA 81581851

Cause

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