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

Last updated on APRIL 17, 2023

Applies to:

Symptoms

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.

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.