HDFS Adapter Replicate Avro abended DBASYS_N

(Doc ID 2142128.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

INFO 2016-04-05 17:38:54,828 [main] Generating the Avro schema for the table [CUSOWNER.CUS_CUSTOMER].
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=[CUSOWNER.CUS_CUSTOMER], 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='CUSOWNER';

OWNER TABLE_NAME
------------------------------ ------------------------------
COLUMN_NAME
------------------------------
DATA_TYPE
--------------------------------------------------------------------------------
HIDDEN_COLUMN
-------------
CUSOWNER CUS_ADDRESS
SYS_NC00042$
VARCHAR2
YES

CUSOWNER CUS_CUSTOMER
SYS_NC00042$
VARCHAR2
YES

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