Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4126

Oracle Connector DDL Parsing Exception

    XMLWordPrintable

Details

    Description

      I am getting a DDL Parsing Exception when using the latest oracle connector on a Oracle "Database 19c Enterprise Edition Release 19.0.0.0.0 - Production" Database.

      It seems the Debezium Oracle DDL Parser cannot handle the `INMEMORY` statements.

      I am able to circumvent this issue with `database.history.skip.unparseable.ddl=true`

      See exception (abbreviated, see attached for original exception):

      2021-10-07 15:14:22,231 INFO  [io.deb.ser.ConnectorLifecycle] (pool-7-thread-1) Connector completed: success = 'false', message = 'Error while trying to run connector class 'io.debezium.connector.oracle.OracleConnector'', error = '{}': org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
              at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:175)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:54)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:165)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127)
              at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
              at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
              at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
              at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
              at java.base/java.lang.Thread.run(Thread.java:833)
      Caused by: Multiple parsing errors
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE "ZZJOBRUN_MDE" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "REPID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "VARNA" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "ZZ_MDE_INFO" VARCHAR2 (000075) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3TBLS NOCOMPRESS NO INMEMORY STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01);'
      mismatched input 'INMEMORY' expecting 'FLASHBACK'
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE "ZZJOBRUN_MDE" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "REPID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "VARNA" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "ZZ_MDE_INFO" VARCHAR2 (000075) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3TBLS NOCOMPRESS NO INMEMORY STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01);'
      mismatched input '0000000064' expecting {')', ','}
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE "ZZJOBRUN_MDE" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "REPID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "VARNA" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "ZZ_MDE_INFO" VARCHAR2 (000075) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3TBLS NOCOMPRESS NO INMEMORY STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01);'
      extraneous input '0000001024' expecting {<EOF>, 'ABORT', 'ABS', 'ACCESS', 'ACCESSED', 'ACCOUNT', 'ACL', 'ACOS', 'ACTION', 'ACTIONS', 'ACTIVATE', 'ACTIVE', 'ACTIVE_COMPONENT', 'ACTIVE_DATA', 'ACTIVE_FUNCTION', 'ACTIVE_TAG', 'ACTIVITY', 'ADAPTIVE_PLAN', 'ADD', 'ADD_COLUMN', 'ADD_GROUP', 'ADD_MONTHS', 'ADJ_DATE', 'ADMIN', 'ADMINISTER', 'ADMINISTRATOR', 'ADVANCED', 'ADVISE', 'ADVISOR', 'AFD_DISKSTRING', 'AFTER', 'AGENT', 'AGGREGATE', 'A', 'ALIAS', 'ALLOCATE', 'ALLOW', 'ALL_ROWS', 'ALTER', 'ALWAYS', 'ANALYZE', ... 'NVL', 'RATIO_TO_REPORT', 'REGR_', 'ROUND', 'ROW_NUMBER', 'SUBSTR', 'TO_CHAR', 'TRIM', 'SUM', 'STDDEV', 'VAR_', 'VARIANCE', 'LEAST', 'GREATEST', 'TO_DATE', '.', DELIMITED_ID, '(', '/', ';', '_', PROMPT_MESSAGE, START_CMD, REGULAR_ID}
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE "ZZJOBRUN_MDE" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "REPID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "VARNA" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "ZZ_MDE_INFO" VARCHAR2 (000075) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3TBLS NOCOMPRESS NO INMEMORY STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01);'
      extraneous input '0000000001' expecting {<EOF>, 'ABORT', 'ABS', 'ACCESS', 'ACCESSED', 'ACCOUNT', 'ACL', 'ACOS', 'ACTION', 'ACTIONS', 'ACTIVATE', 'ACTIVE', 'ACTIVE_COMPONENT', 'ACTIVE_DATA', 'ACTIVE_FUNCTION', 'ACTIVE_TAG', 'ACTIVITY', 'ADAPTIVE_PLAN', 'ADD', 'ADD_COLUMN', 'ADD_GROUP', 'ADD_MONTHS', 'ADJ_DATE', 'ADMIN', 'ADMINISTER', 'ADMINISTRATOR', 'ADVANCED', 'ADVISE', 'ADVISOR', ...
      'SYS_XQ_UPKXML2SQL', 'SYS_XQXFORM', 'SYS_XSID_TO_RAW', 'SYS_ZMAP_FILTER', 'SYS_ZMAP_REFRESH', 'TABLE_LOOKUP_BY_NL', 'TABLESPACE_NO', 'TABLESPACE', 'TABLES', 'TABLE_STATS', 'TABLE', 'TABNO', 'TAG', 'TANH', 'TAN', 'TBL$OR$IDX$PART$NUM', 'TEMPFILE', 'TEMPLATE', 'TEMPORARY', 'TEMP_TABLE', 'TEST', 'TEXT', 'THAN', 'THEN', 'THE', 'THREAD', 'THROUGH', 'TIER', 'TIES', 'TIMEOUT', 'TIMESTAMP_LTZ_UNCONSTRAINED', 'TIMESTAMP', 'TIMESTAMP_TZ_UNCONSTRAINED', 'TIMESTAMP_UNCONSTRAINED', 'TIMES', 'TIME', 'TIMEZONE_ABBR', 'TIMEZONE_HOUR', 'TIMEZONE_MINUTE', 'TIMEZONE_OFFSET', 'TIMEZONE_REGION', 'TIME_ZONE', 'TIV_GB', 'TIV_SSF', 'TO_ACLID', 'TO_BINARY_DOUBLE', 'TO_BINARY_FLOAT', 'TO_BLOB', 'TO_CLOB', 'TO_DSINTERVAL', 'TO_LOB', 'TO_MULTI_BYTE', 'TO_NCHAR', 'TO_NCLOB', 'TO_NUMBER', 'TOPLEVEL', 'TO_SINGLE_BYTE', 'TO_TIMESTAMP', 'TO_TIMESTAMP_TZ', 'TO_TIME', 'TO_TIME_TZ', 'TO_YMINTERVAL', 'TRACE', 'TRACING', 'TRACKING', 'TRAILING', 'TRANSACTION', 'TRANSFORM_DISTINCT_AGG', 'TRANSITIONAL', 'TRANSITION', 'TRANSLATE', 'TRANSLATION', 'TREAT', 'TRIGGERS', 'TRIGGER', 'TRUE', 'TRUNCATE', 'TRUNC', 'TRUSTED', 'TRUST', 'TUNING', 'TX', 'TYPES', 'TYPE', 'TZ_OFFSET', 'UB2', 'UBA', 'UCS2', 'UID', 'UNARCHIVED', 'UNBOUNDED', 'UNBOUND', 'UNCONDITIONAL', 'UNDER', 'UNDO', 'UNDROP', 'UNIFORM', 'UNISTR', 'UNLIMITED', 'UNLOAD', 'UNLOCK', 'UNMATCHED', 'UNNEST_INNERJ_DISTINCT_VIEW', 'UNNEST_NOSEMIJ_NODISTINCTVIEW', 'UNNEST_SEMIJ_VIEW', 'UNNEST', 'UNPACKED', 'UNPIVOT', 'UNPLUG', 'UNPROTECTED', 'UNQUIESCE', 'UNRECOVERABLE', 'UNRESTRICTED', 'UNSUBSCRIBE', 'UNTIL', 'UNUSABLE', 'UNUSED', 'UPDATABLE', 'UPDATED', 'UPDATE', 'UPDATEXML', 'UPD_INDEXES', 'UPD_JOININDEX', 'UPGRADE', 'UPPER', 'UPSERT', 'UROWID', 'USABLE', 'USAGE', 'USE_ANTI', 'USE_CONCAT', 'USE_CUBE', 'USE_HASH_AGGREGATION', 'USE_HASH_GBY_FOR_PUSHDOWN', 'USE_HASH', 'USE_HIDDEN_PARTITIONS', 'USE_INVISIBLE_INDEXES', 'USE_MERGE_CARTESIAN', 'USE_MERGE', 'USE_NL', 'USE_NL_WITH_INDEX', 'USE_PRIVATE_OUTLINES', 'USER_DATA', 'USER_DEFINED', 'USERENV', 'USERGROUP', 'USER_RECYCLEBIN', 'USERS', 'USER_TABLESPACES', 'USER', 'USE_SEMI', 'USE_STORED_OUTLINES', 'USE_TTT_FOR_GSETS', 'USE', 'USE_VECTOR_AGGREGATION', 'USE_WEAK_NAME_RESL', 'USING_NO_EXPAND', 'USING', 'UTF16BE', 'UTF16LE', 'UTF32', 'UTF8', 'V1', 'V2', 'VALIDATE', 'VALIDATION', 'VALID_TIME_END', 'VALUE', 'VARCHAR2', 'VARCHAR', 'VARIABLE', 'VAR_POP', 'VARRAYS', 'VARRAY', 'VAR_SAMP', 'VARYING', 'VECTOR_READ_TRACE', 'VECTOR_READ', 'VECTOR_TRANSFORM_DIMS', 'VECTOR_TRANSFORM_FACT', 'VECTOR_TRANSFORM', 'VERIFIER', 'VERIFY', 'VERSIONING', 'VERSIONS_ENDSCN', 'VERSIONS_ENDTIME', 'VERSIONS_OPERATION', 'VERSIONS_STARTSCN', 'VERSIONS_STARTTIME', 'VERSIONS', 'VERSIONS_XID', 'VERSION', 'VIOLATION', 'VIRTUAL', 'VISIBILITY', 'VISIBLE', 'VOLUME', 'VSIZE', 'WAIT', 'WALLET', 'WARNING', 'WEEKS', 'WEEK', 'WELLFORMED', 'WHENEVER', 'WHEN', 'WHILE', 'WHITESPACE', 'WIDTH_BUCKET', 'WITHIN', 'WITHOUT', 'WITH_PLSQL', 'WITH', 'WORK', 'WRAPPED', 'WRAPPER', 'WRITE', 'XDB_FASTPATH_INSERT', 'X_DYN_PRUNE', 'XID', 'XML2OBJECT', 'XMLAGG', 'XMLATTRIBUTES', 'XMLCAST', 'XMLCDATA', 'XMLCOLATTVAL', 'XMLCOMMENT', 'XMLCONCAT', 'XMLDIFF', 'XML_DML_RWT_STMT', 'XMLELEMENT', 'XMLEXISTS2', 'XMLEXISTS', 'XMLFOREST', 'XMLINDEX_REWRITE_IN_SELECT', 'XMLINDEX_REWRITE', 'XMLINDEX_SEL_IDX_TBL', 'XMLISNODE', 'XMLISVALID', 'XMLNAMESPACES', 'XMLPARSE', 'XMLPATCH', 'XMLPI', 'XMLQUERYVAL', 'XMLQUERY', 'XMLROOT', 'XMLSCHEMA', 'XMLSERIALIZE', 'XMLTABLE', 'XMLTRANSFORMBLOB', 'XMLTRANSFORM', 'XMLTYPE', 'XML', 'XPATHTABLE', 'XS_SYS_CONTEXT', 'XS', 'YEARS', 'YEAR', 'YES', 'YMINTERVAL_UNCONSTRAINED', 'ZONEMAP', 'ZONE', 'PREDICTION', 'PREDICTION_BOUNDS', 'PREDICTION_COST', 'PREDICTION_DETAILS', 'PREDICTION_PROBABILITY', 'PREDICTION_SET', 'CUME_DIST', 'DENSE_RANK', 'LISTAGG', 'PERCENT_RANK', 'PERCENTILE_CONT', 'PERCENTILE_DISC', 'RANK', 'AVG', 'CORR', 'COVAR_', 'LAG', 'LEAD', 'MAX', 'MEDIAN', 'MIN', 'NTILE', 'NVL', 'RATIO_TO_REPORT', 'REGR_', 'ROUND', 'ROW_NUMBER', 'SUBSTR', 'TO_CHAR', 'TRIM', 'SUM', 'STDDEV', 'VAR_', 'VARIANCE', 'LEAST', 'GREATEST', 'TO_DATE', '.', DELIMITED_ID, '(', '/', ';', '_', PROMPT_MESSAGE, START_CMD, REGULAR_ID}
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE "ZZJOBRUN_MDE" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "REPID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "VARNA" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "ZZ_MDE_INFO" VARCHAR2 (000075) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3TBLS NOCOMPRESS NO INMEMORY STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01);'
      extraneous input '0000' expecting {<EOF>, 'ABORT', 'ABS', 'ACCESS', 'ACCESSED', 'ACCOUNT', 'ACL', 'ACOS', 'ACTION', 'ACTIONS', 'ACTIVATE', 'ACTIVE', 'ACTIVE_COMPONENT', 'ACTIVE_DATA', 'ACTIVE_FUNCTION', 'ACTIVE_TAG', 'ACTIVITY', 'ADAPTIVE_PLAN', 'ADD', 'ADD_COLUMN', ... 'GREATEST', 'TO_DATE', '.', DELIMITED_ID, '(', '/', ';', '_', PROMPT_MESSAGE, START_CMD, REGULAR_ID}
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE "ZZJOBRUN_MDE" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "REPID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "VARNA" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "ZZ_MDE_INFO" VARCHAR2 (000075) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3TBLS NOCOMPRESS NO INMEMORY STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01);'
      extraneous input '001' expecting {<EOF>, 'ABORT', 'ABS', 'ACCESS', 'ACCESSED', 'ACCOUNT', 'ACL', 'ACOS', 'ACTION', 'ACTIONS', 'ACTIVATE', 'ACTIVE', 'ACTIVE_COMPONENT', 'ACTIVE_DATA', 'ACTIVE_FUNCTION', 'ACTIVE_TAG', 'ACTIVITY', 'ADAPTIVE_PLAN', 'ADD', 'ADD_COLUMN', ...
      'TIME', 'TIMEZONE_ABBR', 'TIMEZONE_HOUR', 'TIMEZONE_MINUTE', 'TIMEZONE_OFFSET', 'TIMEZONE_REGION', 'TIME_ZONE', 'TIV_GB', 'TIV_SSF', 'TO_ACLID', 'TO_BINARY_DOUBLE', 'TO_BINARY_FLOAT', 'TO_BLOB', 'TO_CLOB', 'TO_DSINTERVAL', 'TO_LOB', 'TO_MULTI_BYTE', 'TO_NCHAR', 'TO_NCLOB', 'TO_NUMBER', 'TOPLEVEL', 'TO_SINGLE_BYTE', 'TO_TIMESTAMP', 'TO_TIMESTAMP_TZ', 'TO_TIME', 'TO_TIME_TZ', 'TO_YMINTERVAL', 'TRACE', 'TRACING', 'TRACKING', 'TRAILING', 'TRANSACTION', 'TRANSFORM_DISTINCT_AGG', 'TRANSITIONAL', 'TRANSITION', 'TRANSLATE', 'TRANSLATION', 'TREAT', 'TRIGGERS', 'TRIGGER', 'TRUE', 'TRUNCATE', 'TRUNC', 'TRUSTED', 'TRUST', 'TUNING', 'TX', 'TYPES', 'TYPE', 'TZ_OFFSET', 'UB2', 'UBA', 'UCS2', 'UID', 'UNARCHIVED', 'UNBOUNDED', 'UNBOUND', 'UNCONDITIONAL', 'UNDER', 'UNDO', 'UNDROP', 'UNIFORM', 'UNISTR', 'UNLIMITED', 'UNLOAD', 'UNLOCK', 'UNMATCHED', 'UNNEST_INNERJ_DISTINCT_VIEW', 'UNNEST_NOSEMIJ_NODISTINCTVIEW', 'UNNEST_SEMIJ_VIEW', 'UNNEST', 'UNPACKED', 'UNPIVOT', 'UNPLUG', 'UNPROTECTED', 'UNQUIESCE', 'UNRECOVERABLE', 'UNRESTRICTED', 'UNSUBSCRIBE', 'UNTIL', 'UNUSABLE', 'UNUSED', 'UPDATABLE', 'UPDATED', 'UPDATE', 'UPDATEXML', 'UPD_INDEXES', 'UPD_JOININDEX', 'UPGRADE', 'UPPER', 'UPSERT', 'UROWID', 'USABLE', 'USAGE', 'USE_ANTI', 'USE_CONCAT', 'USE_CUBE', 'USE_HASH_AGGREGATION', 'USE_HASH_GBY_FOR_PUSHDOWN', 'USE_HASH', 'USE_HIDDEN_PARTITIONS', 'USE_INVISIBLE_INDEXES', 'USE_MERGE_CARTESIAN', 'USE_MERGE', 'USE_NL', 'USE_NL_WITH_INDEX', 'USE_PRIVATE_OUTLINES', 'USER_DATA', 'USER_DEFINED', 'USERENV', 'USERGROUP', 'USER_RECYCLEBIN', 'USERS', 'USER_TABLESPACES', 'USER', 'USE_SEMI', 'USE_STORED_OUTLINES', 'USE_TTT_FOR_GSETS', 'USE', 'USE_VECTOR_AGGREGATION', 'USE_WEAK_NAME_RESL', 'USING_NO_EXPAND', 'USING', 'UTF16BE', 'UTF16LE', 'UTF32', 'UTF8', 'V1', 'V2', 'VALIDATE', 'VALIDATION', 'VALID_TIME_END', 'VALUE', 'VARCHAR2', 'VARCHAR', 'VARIABLE', 'VAR_POP', 'VARRAYS', 'VARRAY', 'VAR_SAMP', 'VARYING', 'VECTOR_READ_TRACE', 'VECTOR_READ', 'VECTOR_TRANSFORM_DIMS', 'VECTOR_TRANSFORM_FACT', 'VECTOR_TRANSFORM', 'VERIFIER', 'VERIFY', 'VERSIONING', 'VERSIONS_ENDSCN', 'VERSIONS_ENDTIME', 'VERSIONS_OPERATION', 'VERSIONS_STARTSCN', 'VERSIONS_STARTTIME', 'VERSIONS', 'VERSIONS_XID', 'VERSION', 'VIOLATION', 'VIRTUAL', 'VISIBILITY', 'VISIBLE', 'VOLUME', 'VSIZE', 'WAIT', 'WALLET', 'WARNING', 'WEEKS', 'WEEK', 'WELLFORMED', 'WHENEVER', 'WHEN', 'WHILE', 'WHITESPACE', 'WIDTH_BUCKET', 'WITHIN', 'WITHOUT', 'WITH_PLSQL', 'WITH', 'WORK', 'WRAPPED', 'WRAPPER', 'WRITE', 'XDB_FASTPATH_INSERT', 'X_DYN_PRUNE', 'XID', 'XML2OBJECT', 'XMLAGG', 'XMLATTRIBUTES', 'XMLCAST', 'XMLCDATA', 'XMLCOLATTVAL', 'XMLCOMMENT', 'XMLCONCAT', 'XMLDIFF', 'XML_DML_RWT_STMT', 'XMLELEMENT', 'XMLEXISTS2', 'XMLEXISTS', 'XMLFOREST', 'XMLINDEX_REWRITE_IN_SELECT', 'XMLINDEX_REWRITE', 'XMLINDEX_SEL_IDX_TBL', 'XMLISNODE', 'XMLISVALID', 'XMLNAMESPACES', 'XMLPARSE', 'XMLPATCH', 'XMLPI', 'XMLQUERYVAL', 'XMLQUERY', 'XMLROOT', 'XMLSCHEMA', 'XMLSERIALIZE', 'XMLTABLE', 'XMLTRANSFORMBLOB', 'XMLTRANSFORM', 'XMLTYPE', 'XML', 'XPATHTABLE', 'XS_SYS_CONTEXT', 'XS', 'YEARS', 'YEAR', 'YES', 'YMINTERVAL_UNCONSTRAINED', 'ZONEMAP', 'ZONE', 'PREDICTION', 'PREDICTION_BOUNDS', 'PREDICTION_COST', 'PREDICTION_DETAILS', 'PREDICTION_PROBABILITY', 'PREDICTION_SET', 'CUME_DIST', 'DENSE_RANK', 'LISTAGG', 'PERCENT_RANK', 'PERCENTILE_CONT', 'PERCENTILE_DISC', 'RANK', 'AVG', 'CORR', 'COVAR_', 'LAG', 'LEAD', 'MAX', 'MEDIAN', 'MIN', 'NTILE', 'NVL', 'RATIO_TO_REPORT', 'REGR_', 'ROUND', 'ROW_NUMBER', 'SUBSTR', 'TO_CHAR', 'TRIM', 'SUM', 'STDDEV', 'VAR_', 'VARIANCE', 'LEAST', 'GREATEST', 'TO_DATE', '.', DELIMITED_ID, '(', '/', ';', '_', PROMPT_MESSAGE, START_CMD, REGULAR_ID}
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE "ZZJOBRUN_MDE" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "REPID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "VARNA" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "ZZ_MDE_INFO" VARCHAR2 (000075) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3TBLS NOCOMPRESS NO INMEMORY STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01);'
      mismatched input '01' expecting {<EOF>, 'ABORT', 'ABS', 'ACCESS', 'ACCESSED', 'ACCOUNT', 'ACL', 'ACOS', 'ACTION', 'ACTIONS', 'ACTIVATE', 'ACTIVE', 'ACTIVE_COMPONENT', 'ACTIVE_DATA', 'ACTIVE_FUNCTION', 'ACTIVE_TAG', 'ACTIVITY', 'ADAPTIVE_PLAN', 'ADD', 'ADD_COLUMN', 'ADD_GROUP', 'ADD_MONTHS', 'ADJ_DATE', 'ADMIN', 'ADMINISTER', 'ADMINISTRATOR', 'ADVANCED', 'ADVISE', 'ADVISOR', 'AFD_DISKSTRING', 'AFTER', 'AGENT', 'AGGREGATE', 'A', 'ALIAS', 'ALLOCATE', 'ALLOW', 'ALL_ROWS', 'ALTER', 'ALWAYS', 'ANALYZE', 'ANCILLARY', 'AND_EQUAL', 'ANOMALY', 'ANSI_REARCH', 'ANTIJOIN', 'ANYSCHEMA', 'APPEND', ...
      'GREATEST', 'TO_DATE', '.', DELIMITED_ID, '(', '/', ';', '_', PROMPT_MESSAGE, START_CMD, REGULAR_ID}
              at io.debezium.antlr.AntlrDdlParser.throwParsingException(AntlrDdlParser.java:368)
              at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:95)
              at io.debezium.connector.oracle.antlr.OracleDdlParser.parse(OracleDdlParser.java:63)
              at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:84)
              at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:305)
              at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleSchemaChange(AbstractLogMinerEventProcessor.java:265)
              at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.handleSchemaChange(MemoryLogMinerEventProcessor.java:318)
              at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:189)
              at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:161)
              at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.process(MemoryLogMinerEventProcessor.java:116)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:162)
              ... 8 more
      

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            simon.tenbusch Simon Tenbusch
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: