My Oracle Support Banner

FileWriter FORMAT.METACOLUMNSTEMPLATE=${ALLTOKENS} Not Working In 12.3.2.1.0 (Doc ID 2513514.1)

Last updated on APRIL 09, 2020

Applies to:

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

Symptoms

Customer is using metaColumnsTemplate parameter with alltokens option.


metaColumnsTemplate parameter
=======================================================
gg.handler.filewriter.format.metaColumnsTemplate=${alltokens}



Parquet data example
==============================================
{
"table":"<table_name>",
"op_type":"I",
"op_ts":"2019-01-16 11:33:15.012145",
"current_ts":"2019-01-16T11:37:20.300002",
"pos":"00000033050049896971",
"primary_keys":["<column_name>"],
"tokens":{},"<column_name>":"372228564 ",
"<column_name1>":"818674711800","SET_STATUS_FLG":"C ",
"<column_name2>":"2018-12-06 00:00:00",
"VERSION":1,
"<column_name3>":" ",
"<column_name4>":"PT0002000117L_15A"
}

Using below settings

gg.includeggtokens=true
gg.handler.name.includeTokens=true

Cause

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
Symptoms
Cause
Solution
References


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