Error: Oracle.goldengate.datasource.metadata.provider.ResolutionException: Invalid Column Datatype (Doc ID 2243139.1)

Last updated on APRIL 09, 2020

Applies to:

Symptoms

ERROR [main] (AvroHDFSRowFormatter.java:245) - The HDFS Avro Row Formatter formatOp operation failed.
org.apache.avro.AvroRuntimeException: Duplicate field table in record <table_name>: table type:UNION pos:7 and table type:STRING pos:0.
at org.apache.avro.Schema$RecordSchema.setFields(Schema.java:590)
at org.apache.avro.SchemaBuilder$FieldAssembler.endRecord(SchemaBuilder.java:2013)
at oracle.goldengate.format.avro.AvroRowSchemaGenerator.generateAvroSchema(AvroRowSchemaGenerator.java:48)
at oracle.goldengate.format.avro.AvroRowSchemaGenerator.generateSchema(AvroRowSchemaGenerator.java:30)
at oracle.goldengate.format.avro.AvroHDFSRowFormatter.formatOp(AvroHDFSRowFormatter.java:200)
at oracle.goldengate.handler.hdfs.HDFSAvroHandler.processOp(HDFSAvroHandler.java:353)
at oracle.goldengate.handler.hdfs.HDFSAbstractHandler.operationAdded(HDFSAbstractHandler.java:140)
at oracle.goldengate.datasource.DsEventManager$3.send(DsEventManager.java:439)
at oracle.goldengate.datasource.DsEventManager$EventDispatcher.distributeEvent(DsEventManager.java:231)
at oracle.goldengate.datasource.DsEventManager.fireOperationAdded(DsEventManager.java:447)
at oracle.goldengate.datasource.AbstractDataSource.fireOperationAdded(AbstractDataSource.java:464)
at oracle.goldengate.datasource.UserExitDataSource.addOperationToTransactionAndFireEvent(UserExitDataSource.java:1337)
at oracle.goldengate.datasource.UserExitDataSource.createOperation(UserExitDataSource.java:1305)
at oracle.goldengate.datasource.UserExitDataSource.createOperation(UserExitDataSource.java:1096)
ERROR [main] (HDFSAvroHandler.java:358) - HDFS Avro Handler failed to process operation: table=[<table_name>], op pos=00000000000000304909, tx pos=00000000000000304909, op ts=2016-11-17 23:48:52.034103
org.apache.avro.AvroRuntimeException: Duplicate field table in record <table_name>: table type:UNION pos:7 and table type:STRING pos:0.
at org.apache.avro.Schema$RecordSchema.setFields(Schema.java:590)

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.