My Oracle Support Banner

Colmap Does Not Work With Kafka Handler (Doc ID 2506990.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate Application Adapters - Version 12.3 and later
Information in this document applies to any platform.


On : 12.3 version, Java Capture

colmap does not work with Kafka Handler

when added an additional mapping for Kafka replicat and it errors out.

If I put this in replicat param file:
MAP <table_name>, TARGET <table_name>, COLMAP (USEDEFAULTS, <target_column_name> = 123);

I will get an error below.

But if I do
MAP <table_name>, TARGET <table_name>, COLMAP (USEDEFAULTS);

it works.

2018-11-26 15:08:47 ERROR OGG-00919 Error in COLMAP clause.

2018-11-26 15:08:47 INFO OGG-06505 MAP resolved (entry <table_name>): MAP "<table_name>", TARGET <table_name>, COLMAP (USEDEFAULTS, <target_column_name>= 123).

2018-11-26 15:08:47 INFO OGG-02756 The definition for table <table_name> is obtained from the trail file.
...(USEDEFAULTS, <target_column_name> = 123)...
Error in COLMAP clause. Unrecognized clause or element.




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

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