Oracle To Snowflake GGBG Replication Error With Columns CONTAINING Special Characters
(Doc ID 3073932.1)
Last updated on FEBRUARY 26, 2025
Applies to:
Oracle GoldenGate Big Data and Application Adapters - Version 23.4.0 and laterInformation in this document applies to any platform.
Symptoms
We are replicating below tables which have # in their column names and they are failing with below errors.
Tables:
MAP PSTAGE.DXXXXX, TARGET PSTAGE_ICEBERG.DXXXXXXX;
Errors:
=ERROR 2025-02-13 12:49:34.000911 [main] - FORMATTERS-00068 The Avro Row Formatter formatOp operation failed.
org.apache.avro.SchemaParseException: Illegal character in: TRACKING#
=ERROR 2025-02-13 12:49:34.000917 [main] - FW-00096 File Writer Handler failed to process operation: table=[PSTAGE_ICEBERG.DXXXXXX], op pos=[00000000670032683510], tx pos=[00000000670004331428], op ts=[2025-02-10 10:22:42.000625000].
org.apache.avro.SchemaParseException: Illegal character in: TRACKING#
=ERROR 2025-02-13 12:49:34.000917 [main] - FW-00099 The File Writer Handler failed for operation: table=[PSTAGE_ICEBERG.DXXXXXXX], op pos=[00000000670032683510], tx pos=[00000000670004331428], op ts=[2025-02-10 10:22:42.000625000].
Changes
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 |
| Changes |
| Cause |
| Solution |