Replicat abend and Logdump shows " Bad compressed block, found length "
(Doc ID 2072869.1)
Last updated on JULY 18, 2023
Applies to:
Oracle GoldenGate - Version 12.1.2.1.0 and laterInformation 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 <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
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 |
Cause |
Solution |
References |