OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File)

OGG Replicat Abends On LOB Data. OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File)


SYMPTOMS:
2018-10-06 18:13:43 ERROR OGG-02188 Unexpected LOB record or record fragment in /trail/DL000000016, rba 1,750.

CAUSE:
replicat altered to start on trail where the first record is a LOB and not the base record INSERT/UPDATE/DELETE

SOLUTION:
1. Use logdump to locate the base record in the trail previous to one replicat is processing. This will display the RBA number of the last base record in trail

rectype 03 – Delete

rectype 05 – Insert

rectype 15 – Update (FieldComp)

rectype 73 – Primary Key Update (GGSPKUpdate)

logdump> open <trail file>

logdump> ghdr on

logdump> pos eof

logdump> pos reverse

logdump> filter exclude rectype 116

logdump>n

2. Alter replicat to position to start on the base record

ggsci> alter <replicat>, extseqno ### ,extrba <RBA of record from above output>

 

Leave a Reply

Your email address will not be published. Required fields are marked *