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

DDL statement couldn't be parsed

    XMLWordPrintable

Details

    Description

      Version of Oracle:Oracle Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

      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:50)
          at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:198)
          at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57)
          at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:172)
          at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:139)
          at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108)
          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
          at java.util.concurrent.FutureTask.run(FutureTask.java:266)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
          at java.lang.Thread.run(Thread.java:748)
      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 "ODS_XMES_QY"."ORDER" 
         (    "Oid" CHAR(36), 
          "CONTRACT" CHAR(36), 
          "BU" CHAR(36), 
          "ORDERNUM" NVARCHAR2(100), 
          "ORDER_SELF_NUM" NVARCHAR2(100), 
          "OLD_CODE" NVARCHAR2(50), 
          "FROM_SYS" NVARCHAR2(50), 
          "OLD_SYS_ORD_NUM" NVARCHAR2(50), 
          "PRODUCE_DEPARTMENT" CHAR(36), 
          "SHIP_LINE_COMMENT" NVARCHAR2(50), 
          "SHIP_STATION_COMMENT" NVARCHAR2(100), 
          "OWE_MTL" NUMBER(1,0), 
          "ORDER_CLASS" NVARCHAR2(100), 
          "ORDER_TYPE" NVARCHAR2(100), 
          "PRODUCT_CLASS" NVARCHAR2(100), 
          "BRAND" NVARCHAR2(100), 
          "STYLE" NVARCHAR2(100), 
          "ORDER_DATE" DATE, 
          "REQDATE" DATE, 
          "DUE_DATE" DATE, 
          "ROOM_NUM" NVARCHAR2(100), 
          "BATCH_NUM" NVARCHAR2(100), 
          "BATCH_QTY" NUMBER(*,0), 
          "SOURCE_ORDER_NUM" NVARCHAR2(100), 
          "WHOLE" NUMBER(1,0), 
          "BANSIN_TYPE" NVARCHAR2(100), 
          "CREATE_TIME" DATE, 
          "FIRST_SCHEDULE_TIME" DATE, 
          "DESIGN_SOURCE" NVARCHAR2(100), 
          "LEAVE_BEHIND" NUMBER(1,0), 
          "NOTE" NVARCHAR2(1500), 
          "NON_STD_ITEM" NUMBER(1,0), 
          "URGENT" NUMBER(1,0), 
          "TECH_AUDITOR" NVARCHAR2(500), 
          "COMPARE_COLOR" NUMBER(1,0), 
          "EXCEPTION" NUMBER(1,0), 
          "PRODUCTION_DAYS" NUMBER(*,0), 
          "INNER_PRODUCTION_DAYS" NUMBER(*,0), 
          "BILL_STATUS" CHAR(36), 
          "OLD_BILL_STATUS" CHAR(36), 
          "COMPARE_COLOR_DAYS" NUMBER(*,0), 
          "PREPARE_MTL_LIST_NUM" NVARCHAR2(100), 
          "PREPARE_MTL_LIST_DATE" DATE, 
          "IS_MANUAL_PROGRAM" NUMBER(1,0), 
          "IS_SLIDING_DOOR" NUMBER(1,0), 
          "IS_TABLE" NUMBER(1,0), 
          "WCC_NUM" NVARCHAR2(20), 
          "PROJECT_NUM" NVARCHAR2(50), 
          "AREA" NVARCHAR2(50), 
          "BUILDING_NUM" NVARCHAR2(50), 
          "PROJECT_BASE" CHAR(36), 
          "SOURCE_ORDER" NUMBER(1,0), 
          "DESK_DUE_DATE" DATE, 
          "HOUSE_TYPE" NVARCHAR2(100), 
          "PROJECT_NOTE" NVARCHAR2(100), 
          "ORDER_SCHEDULE_PROPERTY" CHAR(36), 
          "MATING" NVARCHAR2(100), 
          "BIG_HOME" NUMBER(1,0), 
          "FINISH" NUMBER(1,0), 
          "ORDER_ITEM_RULE_VERSION" CHAR(36), 
          "CAPACITY_TYPE" NVARCHAR2(100), 
          "INSIGHT_DATA" DATE, 
          "RECEIVER" NVARCHAR2(30), 
          "ADDITIANAL" NUMBER(1,0), 
          "IS_IMPORTED" NUMBER(1,0), 
          "UNIT" NVARCHAR2(30), 
          "SERVICENUM" NVARCHAR2(50), 
          "SERVICE_ORDER_NUM" NVARCHAR2(200), 
          "LEADER" NVARCHAR2(50), 
          "LEADER_TEL" NVARCHAR2(50), 
          "IS_STANDARD" NUMBER(1,0), 
          "BATCH_ORDER_SEQ" NUMBER(*,0), 
          "BATCH_SECTION_NUM" NVARCHAR2(20), 
          "PLAN_INSTOR_EDATE" DATE, 
          "PLACE_ORDER_CATEGORY" CHAR(36), 
          "SEND_TIME" DATE, 
          "QC_RESULT" NUMBER(*,0), 
          "OptimisticLockField" NUMBER(*,0), 
          "STD_RATE" NVARCHAR2(10), 
          "MAIN_CONTRACT_NUM" NVARCHAR2(200), 
          "LIVE_PURCHASE_NUM" NVARCHAR2(100), 
          "LIVE_PURCHASE_LINE" NVARCHAR2(100), 
          "LIVE_PROJECT_NUM" NVARCHAR2(100), 
          "CHANNEL" NVARCHAR2(50), 
          "MULTI_NUM_REMARK" NVARCHAR2(200), 
          "DESIGN_CONTRACT_NO" NVARCHAR2(100), 
          "SPACE_PRODUCT" NVARCHAR2(100), 
          "BATCH_NUMBER_MIX" NVARCHAR2(50), 
          "MAIN_CONTRACT_BATCH_NO" NVARCHAR2(100), 
          "SALE_DEPT" NVARCHAR2(100), 
          "LINE_TYPE" NVARCHAR2(100), 
          "IS_FXM" NUMBER(1,0), 
          "SMALL_BATCH_NO" NVARCHAR2(100), 
          "ENTRUCK_NUM" NVARCHAR2(100), 
          "IS_ASSEMBLE" NUMBER(1,0), 
          "SHOW_LOGO" NUMBER(1,0), 
          "SHOW_MADEINCHINA" NUMBER(1,0), 
          "DRAWING_VARIABLE" NUMBER(1,0), 
          "RECEIVE_ADDRESS" NVARCHAR2(100), 
          "ORDER_SUPPORT_PROPERTY" NVARCHAR2(1000), 
          "RECEIVER_TEL" NVARCHAR2(30), 
          "ACTIVITY_TYPE" NVARCHAR2(100), 
          "ORDER_AUDIT_REMARK" NVARCHAR2(500), 
           CONSTRAINT "PK_ORDER" PRIMARY KEY ("Oid")
        USING INDEX  ENABLE, 
           SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS, 
           SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS, 
           SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, 
           SUPPLEMENTAL LOG GROUP "GGS_87678" ("Oid") ALWAYS, 
           CONSTRAINT "FK_ORDER_CONTRACT" FOREIGN KEY ("CONTRACT")
            REFERENCES "ODS_XMES_QY"."CONTRACT" ("Oid") DISABLE, 
           CONSTRAINT "FK_ORDER_BU" FOREIGN KEY ("BU")
            REFERENCES "ODS_XMES_QY"."BU" ("Oid") DISABLE, 
           CONSTRAINT "FK_ORDER_PRODUCE_DEPARTMENT" FOREIGN KEY ("PRODUCE_DEPARTMENT")
            REFERENCES "ODS_XMES_QY"."DEPARTMENT" ("Oid") DISABLE, 
           CONSTRAINT "FK_ORDER_BILL_STATUS" FOREIGN KEY ("BILL_STATUS")
            REFERENCES "ODS_XMES_QY"."BILL_STATUS" ("Oid") DISABLE, 
           CONSTRAINT "FK_ORDER_OLD_BILL_STATUS" FOREIGN KEY ("OLD_BILL_STATUS")
            REFERENCES "ODS_XMES_QY"."BILL_STATUS" ("Oid") DISABLE, 
           CONSTRAINT "FK_ORDER_ORDER_SCHEDU_B614B2D5" FOREIGN KEY ("ORDER_SCHEDULE_PROPERTY")
            REFERENCES "ODS_XMES_QY"."ORDER_SCHEDULE_PROPERTY" ("Oid") DISABLE, 
           CONSTRAINT "FK_ORDER_ORDER_ITEM_R_4F66A762" FOREIGN KEY ("ORDER_ITEM_RULE_VERSION")
            REFERENCES "ODS_XMES_QY"."ORDER_ITEM_RULE_VERSION" ("Oid") DISABLE, 
           CONSTRAINT "FK_ORDER_PLACE_ORDER_CATEGORY" FOREIGN KEY ("PLACE_ORDER_CATEGORY")
            REFERENCES "ODS_XMES_QY"."ORDER_PRODUCT" ("Oid") DISABLE
         ) 
        INMEMORY PRIORITY CRITICAL MEMCOMPRESS FOR QUERY LOW 
        DISTRIBUTE AUTO FOR SERVICE ALL NO DUPLICATE ;'
      mismatched input 'MEMCOMPRESS' expecting {'AS', 'USAGE', ';'} 

      Attachments

        Issue Links

          Activity

            People

              ccranfor@redhat.com Chris Cranford
              desctan90 zainc chou
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: