golden gate replication error

[Roshan]

Oracle Database 18c(target)
Oracle Database 12c(source)

Hello Erman,

I have setup a schema replication using OGG 18. Now I see replication on target has abended.

Error from logfile:

2019-04-04T15:09:16.677+0400  ERROR   OGG-01169  Oracle GoldenGate Delivery for Oracle, dwarer.prm:  Encountered an update where all key columns for target table CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER are not present.

Is it true that XML datatypes are not supported by OGG?

Thanks,

Roshan

[ErmanArslansOracleBlog]

It seems, the source table has a column which doesn't exist in the target table.

That is , replicat tried to apply a record by using a specific key from the source table, but some or all of the matching key columns do not exist in the target table.

IF you want to omit the replication of XML columns, you may use COLSEXCEPT.

Read the following for the supported data types:

18c (18.1.0)
E95983-04
January 2019

https://docs.oracle.com/en/middleware/goldengate/core/18.1/oracle-db/using-oracle-goldengate-oracle-database.pdf - "section - Understanding What’s Supported"

[Roshan]

Hi Erman,

I added the keycols in the parameter file

MAP CBS_CORE.CB_MULTI_ACCT_RECEIPT_HEADER , TARGET CBS_CORE.CB_MULTI_ACCT_RECEIPT_HEADER ,keycols(SERV_ACC_LINK_CODE_N);

and error is gone