supplemental log group

[Roshan]

Oracle DB 12.1.0.2
OGG 18.1.0

Dear Erman,

kindly advise whether the ALWAYS supplemental log groups can be dropped. My aim is to allow PK UPDATE -> DELETE AND INSERT on Striim. I often get error:
Unexpected Exception. Message: Please provide the full image for insertion as PKUpdateHandlingMode is set as DELETE and Insert

I suppose because of the ALWAYS condition I am getting error.

Table DDL entry:
         SUPPLEMENTAL LOG GROUP "GGS_130565" ("ARTICLE_CODE_V") ALWAYS,
         SUPPLEMENTAL LOG GROUP "GGS_144462" ("ARTICLE_CODE_V") ALWAYS,
         SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
         SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,
         SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,
         SUPPLEMENTAL LOG DATA (ALL) COLUMNS

Regards,

Roshan

[ErmanArslansOracleBlog]

According to the Striim, PKUpdateHandlingMode is related with Primary Keys.
Probably, you got a PK update, and as your mode is Delete Insert , you need a full image and probably you don't have a full image -- you have some values missing for some columns of the row.

With this in mind, please check your conf and ask Striim Support.

Also ensure that you don't have Compression property in the CDC source reader set to False..

[Roshan]

OK thanks.