Replicat abend and Logdump shows " Bad compressed block, found length "

(Doc ID 2072869.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.
Currency Check- Sep 2017

Symptoms

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

2015-05-19 06:05:28 ERROR OGG-01296 Error mapping from PJACOB.HASH_CONTENT to PJACOB.HASH_CONTENT


The discard shows

Oracle GoldenGate Delivery for Oracle process started, group REP35 discard file opened: 2015-05-14 23:40:10.936126
Key column HASHCODE (0) is missing from update on table PJACOB.HASH_CONTENT
Key column INSERT_DATE (1) is missing from update on table PJACOB.HASH_CONTENT
Missing 2 key columns in update for table PJACOB.HASH_CONTENT.
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 PJACOB.HASH_CONTENT to PJACOB.HASH_CONTENT
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: PJACOB.HASH_CONTENT
After Image: Partition 4 m
Bad compressed block, found length of 6 (x0006), RBA 81581851


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