-
Bug
-
Resolution: Done
-
Major
-
1.9.0.Alpha2
-
None
-
False
-
False
-
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', ';'}
- is duplicated by
-
DBZ-4769 oracle-connector DDL statement couldn't be parsed
- Closed