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

Last updated on JULY 19, 2017

Applies to:

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

Symptoms

ERROR [main] (AvroHDFSRowFormatter.java:245) - The HDFS Avro Row Formatter formatOp operation failed.
org.apache.avro.AvroRuntimeException: Duplicate field table in record rawdev.bge_ccb_ci_per_phone: 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=[rawdev.bge_ccb_ci_per_phone], op pos=00000000000000304909, tx pos=00000000000000304909, op ts=2016-11-17 23:48:52.034103
org.apache.avro.AvroRuntimeException: Duplicate field table in record rawdev.bge_ccb_ci_per_phone: table type:UNION pos:7 and table type:STRING pos:0.
at org.apache.avro.Schema$RecordSchema.setFields(Schema.java:590)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms