Replicat Exceptions Handling on Conflict Results in BLOB Content Invalid / Corrupt in Exceptions Table (Doc ID 2781598.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

OGG 12.2 replicat is configured with exceptions handling for a table with BLOB column (BASICFILE).  Replicat successfully replicates the BLOB content to the 11g target table when there is no conflict, but on occurrence of a conflict and subsequent insert into exceptions table, the BLOB content is invalid / corrupt in the exceptions table i.e. BLOB content of scanned images can't be opened and viewed as a .jpg extension. 

On handling the exception, the following is also reported in the replicat report file and ggserr.log:

OGG-02154  Skipping Conflict detection resolution for partial_lob_data.
OGG-00888  SQL statement executed successfully on interval.

Changes

Cause

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