OGG-15051 Oracle GoldenGate Delivery, r2kaf_ar.prm: Java or JNI exception: Adding Txind To Metacolumns In Goldengate (Doc ID 2569818.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

 Ct wanted to add the txind metadata column in GG and was trying to test in R2. But when adding below line to Kafka.props they run into following error.

gg.handler.kafkahandler.format.metaColumnsTemplate=${optype},${position},${timestamp},${objectname},${xid},${currenttimestamp},${opseqno},${txind}


2019-05-15T19:02:20.807+0000  WARNING OGG-00869  Oracle GoldenGate Delivery, r2kaf_ar.prm:  oracle.goldengate.datasource.metacolumn.MetaColumnException: MetaColumn format contains the following errors:
                             Unknown Token type for '${txind}'.

2019-05-15T19:02:20.808+0000  ERROR   OGG-15051  Oracle GoldenGate Delivery, r2kaf_ar.prm:  Java or JNI exception:
                             oracle.goldengate.util.GGException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userExitDataSource' defined in class path resource [oracle/goldengate/datasource/DataSource-context.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [oracle.goldengate.datasource.GGDataSource]: Factory method 'getDataSource' threw exception; nested exception is oracle.goldengate.util.GGException: Error in Metacolumn Template
                             org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userExitDataSource' defined in class path resource [oracle/goldengate/datasource/DataSource-context.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [oracle.goldengate.datasource.GGDataSource]: Factory method 'getDataSource' threw exception; nested exception is oracle.goldengate.util.GGException: Error in Metacolumn Template
                               at oracle.goldengate.datasource.DataSourceLauncher.<init>(DataSourceLauncher.java:168)
                               at oracle.goldengate.datasource.UserExitMain.main(UserExitMain.j

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.