HDFS Adapter Replicate Avro abended DBASYS_N (Doc ID 2142128.1)

Last updated on MARCH 05, 2019

Applies to:

Symptoms

INFO 2016-04-05 17:38:54,828 [main] Generating the Avro schema for the table [<schema>.<table>].
ERROR 2016-04-05 17:38:54,831 [main] The Avro Row Formatter formatOp operation failed.
org.apache.avro.SchemaParseException: Illegal character in: SYS_NC00042$
at org.apache.avro.Schema.validateName(Schema.java:1083)
at org.apache.avro.Schema.access$200(Schema.java:79)
at org.apache.avro.Schema$Field.<init>(Schema.java:372)

===> log4j.log

at oracle.goldengate.datasource.UserExitDataSource.commitTx(UserExitDataSource.java:1526)
ERROR 2016-04-05 17:38:54,832 [main] HDFS Handler failed to process operation: table=[<schema>.<table>], op pos=00000001930000411866, tx pos=00000001930000084588, op ts=2016-04-05 06:30:01.019431
org.apache.avro.SchemaParseException: Illegal character in: SYS_NC00042$
at org.apache.avro.Schema.validateName(Schema.java:1083)
at org.apache.avro.Schema.access$200(Schema.java:79)

select OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, HIDDEN_COLUMN from dba_tab_cols where column_name='SYS_NC00042$' and owner='<schema>';

OWNER TABLE_NAME
------------------------------ ------------------------------
COLUMN_NAME
------------------------------
DATA_TYPE
--------------------------------------------------------------------------------
HIDDEN_COLUMN
-------------
<schema> <table>
SYS_NC00042$
VARCHAR2
YES

<schema> <table>
SYS_NC00042$
VARCHAR2
YES

Cause

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