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

DDL statement couldn't be parsed

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.9.0.CR1
    • None
    • oracle-connector
    • None

    Description

      This DDL couldn't be parsed.

      [2022-03-11 03:50:15,604] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:111)
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE WBXCRLOG
          (
            CRID              NUMBER not null,
            CONFLICTTIME      DATE default SYSDATE,
            CONFLICTRESOLVED  VARCHAR2(1) not null,
            CONFLICTCHECKED   VARCHAR2(1) not null,
            ORACLEERR         NUMBER,
              SRCHOST           VARCHAR2(32),
               SRCORASID         VARCHAR2(32),
              SOURCEROWID       VARCHAR2(20),
              TARGETROWID       VARCHAR2(20),
              CONFLICTTABLE     VARCHAR2(100),
              CONFLICTTYPE      VARCHAR2(1),
              PRIMARYKEYS       VARCHAR2(4000),
             MESSAGE           VARCHAR2(600),
            ERRSQLCODE        VARCHAR2(200),
              ERROMESSAGE       VARCHAR2(500),
              SQLSTATEMENT      CLOB,
            COMMENTS          VARCHAR2(200),
               CONSTRAINT        PK_WBXCRLOG PRIMARY KEY(CONFLICTTIME,CRID) USING INDEX TABLESPACE SPLEX_INDX LOCAL
            ) PARTITION BY RANGE(CONFLICTTIME)
            INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
            STORE IN (SPLEX_DATA)
          (
           PARTITION P201805 VALUES LESS THAN (TO_DATE('2018-06-01', 'YYYY-MM-DD')) TABLESPACE SPLEX_DATA,
           PARTITION P201806 VALUES LESS THAN (TO_DATE('2018-07-01', 'YYYY-MM-DD')) TABLESPACE SPLEX_DATA
          );'
      extraneous input 'LOCAL' expecting {')', ','} 

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            zouxinyu0328 Ethan Zou (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: