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

DML statement couldn't be parsed

    XMLWordPrintable

Details

    • Hide
      create table PUB_SERVICE_AREAS (
       ID NUMBER not null
       constraint PUB_SERVICE_AREAS_PK
       primary key,
       CODE VARCHAR2(30 char) not null,
       DESCRIPTION VARCHAR2(200 char) not null,
       AREA CLOB,
       AREA_GEOM SDO_GEOMETRY,
       START_DATE DATE not null,
       END_DATE DATE,
       ENABLED VARCHAR2(1 char) default 'Y' not null,
       VERSION NUMBER not null,
       CREATED_BY NUMBER default 0 not null,
       CREATION_DATE DATE default SYSDATE not null,
       LAST_UPDATED_BY NUMBER default 0 not null,
       LAST_UPDATE_DATE DATE default SYSDATE not null,
       PUBLISHED VARCHAR2(1 char) default 'Y' not null,
       ORG_ID NUMBER constraint PUB_SERVICE_AREAS_FK1 references COR_ORGANIZATIONS,
       INTERNAL_DESCRIPTION VARCHAR2(4000 char),
       PUBLIC_DESCRIPTION VARCHAR2(4000 char),
       MARKER_ICON VARCHAR2(100 char),
       STROKE_COLOR VARCHAR2(30 char),
       STROKE_WIDTH NUMBER,
       FILL_COLOR VARCHAR2(30 char),
       GPS_LONG NUMBER,
       GPS_LAT NUMBER
      )
      /
      
      create unique index PUB_SERVICE_AREAS_U1
       on PUB_SERVICE_AREAS(CODE)
      /
      
      create unique index PUB_SERVICE_AREAS_U2
       on PUB_SERVICE_AREAS(DESCRIPTION)
      /
      
      create index PUB_SERVICE_AREAS_S1
       on PUB_SERVICE_AREAS(AREA_GEOM)
       indextype is MDSYS.SPATIAL_INDEX
      /
      
      create index PUB_SERVICE_AREAS_N1
       on PUB_SERVICE_AREAS(ORG_ID)
      /
      
      Show
      create table PUB_SERVICE_AREAS ( ID NUMBER not null constraint PUB_SERVICE_AREAS_PK primary key, CODE VARCHAR2(30 char ) not null , DESCRIPTION VARCHAR2(200 char ) not null , AREA CLOB, AREA_GEOM SDO_GEOMETRY, START_DATE DATE not null , END_DATE DATE, ENABLED VARCHAR2(1 char ) default 'Y' not null , VERSION NUMBER not null , CREATED_BY NUMBER default 0 not null , CREATION_DATE DATE default SYSDATE not null , LAST_UPDATED_BY NUMBER default 0 not null , LAST_UPDATE_DATE DATE default SYSDATE not null , PUBLISHED VARCHAR2(1 char ) default 'Y' not null , ORG_ID NUMBER constraint PUB_SERVICE_AREAS_FK1 references COR_ORGANIZATIONS, INTERNAL_DESCRIPTION VARCHAR2(4000 char ), PUBLIC_DESCRIPTION VARCHAR2(4000 char ), MARKER_ICON VARCHAR2(100 char ), STROKE_COLOR VARCHAR2(30 char ), STROKE_WIDTH NUMBER, FILL_COLOR VARCHAR2(30 char ), GPS_LONG NUMBER, GPS_LAT NUMBER ) / create unique index PUB_SERVICE_AREAS_U1 on PUB_SERVICE_AREAS(CODE) / create unique index PUB_SERVICE_AREAS_U2 on PUB_SERVICE_AREAS(DESCRIPTION) / create index PUB_SERVICE_AREAS_S1 on PUB_SERVICE_AREAS(AREA_GEOM) indextype is MDSYS.SPATIAL_INDEX / create index PUB_SERVICE_AREAS_N1 on PUB_SERVICE_AREAS(ORG_ID) /

    Description

      We receive the following error at table update. Debezium 1.6.3 is not affected with the same configuration.

       

      	Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF8
      __  ____  __  _____   ___  __ ____  ______ 
       --/ __ \/ / / / _ | / _ \/ //_/ / / / __/ 
       -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \   
      --\___\_\____/_/ |_/_/|_/_/|_|\____/___/   
      2021-10-22 14:48:48,474 INFO  [io.deb.ser.BaseChangeConsumer] (main) Using 'io.debezium.server.BaseChangeConsumer$$Lambda$204/0x0000000840255040@48bfb884' stream name mapper
      2021-10-22 14:48:48,569 INFO  [io.deb.ser.red.RedisStreamChangeConsumer] (main) Using default Jedis 'redis.clients.jedis.Jedis@27b22f74'
      2021-10-22 14:48:48,569 INFO  [io.deb.ser.DebeziumServer] (main) Consumer 'io.debezium.server.redis.RedisStreamChangeConsumer' instantiated
      2021-10-22 14:48:48,869 INFO  [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: 
      	converter.type = key
      	decimal.format = BASE64
      	schemas.cache.size = 1000
      	schemas.enable = true
      
      2021-10-22 14:48:48,872 INFO  [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: 
      	converter.type = value
      	decimal.format = BASE64
      	schemas.cache.size = 1000
      	schemas.enable = false
      
      2021-10-22 14:48:48,882 INFO  [io.deb.emb.EmbeddedEngine$EmbeddedConfig] (main) EmbeddedConfig values: 
      	access.control.allow.methods = 
      	access.control.allow.origin = 
      	admin.listeners = null
      	bootstrap.servers = [localhost:9092]
      	client.dns.lookup = use_all_dns_ips
      	config.providers = []
      	connector.client.config.override.policy = None
      	header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter
      	internal.key.converter = class org.apache.kafka.connect.json.JsonConverter
        internal.value.converter = class org.apache.kafka.connect.json.JsonConverter
      	key.converter = class org.apache.kafka.connect.json.JsonConverter
      	listeners = null
      	metric.reporters = []
      	metrics.num.samples = 2
      	metrics.recording.level = INFO
      	metrics.sample.window.ms = 30000
      	offset.flush.interval.ms = 0
      	offset.flush.timeout.ms = 5000
      	offset.storage.file.filename = data/offsets.dat
      	offset.storage.partitions = null
      	offset.storage.replication.factor = null
      	offset.storage.topic = 
      	plugin.path = null
      	response.http.headers.config = 
      	rest.advertised.host.name = null
      	rest.advertised.listener = null
      	rest.advertised.port = null
      	rest.extension.classes = []
      	rest.host.name = null
      	rest.port = 8083
      	ssl.cipher.suites = null
      	ssl.client.auth = none
      	ssl.enabled.protocols = [TLSv1.2, TLSv1.3]
      	ssl.endpoint.identification.algorithm = https
      	ssl.engine.factory.class = null
      	ssl.key.password = null
      	ssl.keymanager.algorithm = SunX509
      	ssl.keystore.certificate.chain = null
      	ssl.keystore.key = null
      	ssl.keystore.location = null
      	ssl.keystore.password = null
      	ssl.keystore.type = JKS
      	ssl.protocol = TLSv1.3
      	ssl.provider = null
      	ssl.secure.random.implementation = null
      	ssl.trustmanager.algorithm = PKIX
      	ssl.truststore.certificates = null
      	ssl.truststore.location = null
      	ssl.truststore.password = null
      	ssl.truststore.type = JKS
      	task.shutdown.graceful.timeout.ms = 5000
      	topic.creation.enable = true
      	topic.tracking.allow.reset = true
      	topic.tracking.enable = true
      	value.converter = class org.apache.kafka.connect.json.JsonConverter
      
      2021-10-22 14:48:48,883 INFO  [org.apa.kaf.con.run.WorkerConfig] (main) Worker configuration property 'internal.key.converter' is deprecated and may be removed in an upcoming release. The specified value 'org.apache.kafka.connect.json.JsonConverter' matches the default, so this property can be safely removed from the worker configuration.
      2021-10-22 14:48:48,883 INFO  [org.apa.kaf.con.run.WorkerConfig] (main) Worker configuration property 'internal.value.converter' is deprecated and may be removed in an upcoming release. The specified value 'org.apache.kafka.connect.json.JsonConverter' matches the default, so this property can be safely removed from the worker configuration.
      2021-10-22 14:48:48,884 WARN  [org.apa.kaf.con.run.WorkerConfig] (main) Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.
      2021-10-22 14:48:48,886 INFO  [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: 
      	converter.type = key
      	decimal.format = BASE64
      	schemas.cache.size = 1000
      	schemas.enable = true
      2021-10-22 14:48:48,887 INFO  [org.apa.kaf.con.jso.JsonConverterConfig] (main) JsonConverterConfig values: 
      	converter.type = value
      	decimal.format = BASE64
      	schemas.cache.size = 1000
      	schemas.enable = true
      
      2021-10-22 14:48:48,889 INFO  [io.deb.ser.DebeziumServer] (main) Engine executor started
      2021-10-22 14:48:48,987 INFO  [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Starting FileOffsetBackingStore with file data/offsets.dat
      2021-10-22 14:48:49,474 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Starting OracleConnectorTask with configuration:
      2021-10-22 14:48:49,476 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    connector.class = io.debezium.connector.oracle.OracleConnector
      2021-10-22 14:48:49,477 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    database.history.file.filename = data/db_history.dat
      2021-10-22 14:48:49,483 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    database.user = ...
      2021-10-22 14:48:49,483 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    database.dbname = ...
      2021-10-22 14:48:49,484 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    tasks.max = 1
      2021-10-22 14:48:49,484 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    database.pdb.name = PDB1
      2021-10-22 14:48:49,484 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    database.url = jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS_LIST=(FAILOVER = on)(LOAD_BALANCE = off)(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.22.12)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.22.13)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = xxpdb1.eunetuat.eunet.oraclevcn.com)))
      2021-10-22 14:48:49,484 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    database.server.name = xxpdb1.eunetuat.eunet.oraclevcn.com
      2021-10-22 14:48:49,485 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    event.processing.failure.handling.mode = warn
      2021-10-22 14:48:49,485 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    internal.log.mining.dml.parser = legacy
      2021-10-22 14:48:49,485 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    log.mining.strategy = online_catalog
      2021-10-22 14:48:49,485 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    offset.flush.interval.ms = 0
      2021-10-22 14:48:49,485 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    tombstones.on.delete = false
      2021-10-22 14:48:49,488 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    offset.storage.file.filename = data/offsets.dat
      2021-10-22 14:48:49,489 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    column.exclude.list = PROJECT.PUB_SERVICE_AREAS.AREA_GEOM,PROJECT.PUB_PARKING_PLACES.AREA_GEOM
      2021-10-22 14:48:49,489 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    database.password = ********
      2021-10-22 14:48:49,489 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    name = redis
      2021-10-22 14:48:49,489 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    lob.enabled = true
      2021-10-22 14:48:49,489 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    table.include.list = PROJECT.PUB_VEHICLES,PROJECT.PUB_VEHICLE_TYPES,PROJECT.PUB_SERVICE_AREAS,PROJECT.PUB_PARKING_PLACES,PROJECT.PUB_CHARGERS,PROJECT.PUB_PARTNERS,PROJECT.COR_PARAMETER_VALUES,PROJECT.COM_INBOXES,PROJECT.PAY_BALANCES,PROJECT.PUB_PARTNER_BANK_CARDS,PROJECT.SAL_BALANCES,PROJECT.SAL_CONTRACT_PERSONS,PROJECT.SAL_CONTRACTS,PROJECT.SAL_RADAR,PROJECT.SAL_RENTAL_CANCELLATIONS,PROJECT.PUB_PARTNER_DOCUMENTS,PROJECT.SAL_CONTRACT_VEHICLES,PROJECT.COR_LOOKUP_VALUES,PROJECT.PUB_PARTNER_ADDRESSES,PROJECT.PUB_PARTNER_ACCEPTANCES
      2021-10-22 14:48:49,490 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    database.history = io.debezium.relational.history.FileDatabaseHistory
      2021-10-22 14:48:49,490 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1)    snapshot.mode = schema_only
      2021-10-22 14:48:49,890 INFO  [io.quarkus] (main) debezium-server-dist 1.7.0.Final on JVM (powered by Quarkus 2.0.0.Final) started in 8.191s. Listening on: http://0.0.0.0:8080
      2021-10-22 14:48:49,891 INFO  [io.quarkus] (main) Profile prod activated. 
      2021-10-22 14:48:49,891 INFO  [io.quarkus] (main) Installed features: [cdi, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health]
      2021-10-22 14:48:53,682 INFO  [io.deb.con.ora.OracleConnection] (pool-7-thread-1) Database Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
      2021-10-22 14:48:54,169 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) No previous offsets found
      2021-10-22 14:48:54,184 INFO  [io.deb.uti.Threads] (pool-7-thread-1) Requested thread factory for connector OracleConnector, id = xxpdb1.eunetuat.eunet.oraclevcn.com named = change-event-source-coordinator
      2021-10-22 14:48:54,186 INFO  [io.deb.uti.Threads] (pool-7-thread-1) Creating thread debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator
      2021-10-22 14:48:54,193 INFO  [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Metrics registered
      2021-10-22 14:48:54,195 INFO  [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Context created
      2021-10-22 14:48:54,271 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot step 1 - Preparing
      2021-10-22 14:48:54,271 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot step 2 - Determining captured tables
      2021-10-22 14:48:54,869 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot step 3 - Locking captured tables [PDB1.PROJECT.PUB_VEHICLES, PDB1.PROJECT.PUB_VEHICLE_TYPES, PDB1.PROJECT.PUB_SERVICE_AREAS, PDB1.PROJECT.PUB_PARKING_PLACES, PDB1.PROJECT.PUB_CHARGERS, PDB1.PROJECT.PUB_PARTNERS, PDB1.PROJECT.COR_PARAMETER_VALUES, PDB1.PROJECT.COM_INBOXES, PDB1.PROJECT.PAY_BALANCES, PDB1.PROJECT.PUB_PARTNER_BANK_CARDS, PDB1.PROJECT.SAL_BALANCES, PDB1.PROJECT.SAL_CONTRACT_PERSONS, PDB1.PROJECT.SAL_CONTRACTS, PDB1.PROJECT.SAL_RADAR, PDB1.PROJECT.SAL_RENTAL_CANCELLATIONS, PDB1.PROJECT.PUB_PARTNER_DOCUMENTS, PDB1.PROJECT.SAL_CONTRACT_VEHICLES, PDB1.PROJECT.COR_LOOKUP_VALUES, PDB1.PROJECT.PUB_PARTNER_ADDRESSES, PDB1.PROJECT.PUB_PARTNER_ACCEPTANCES]
      2021-10-22 14:48:54,903 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot step 4 - Determining snapshot offset
      2021-10-22 14:48:55,109 INFO  [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) No latest table SCN could be resolved, defaulting to current SCN
      2021-10-22 14:48:55,142 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot step 5 - Reading structure of captured tables
      2021-10-22 14:48:56,388 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot step 6 - Persisting schema history
      2021-10-22 14:48:57,202 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 1 records sent during previous 00:00:08.109, last recorded offset: {snapshot=true, scn=19515608845, snapshot_completed=false}
      2021-10-22 14:49:04,273 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) 14 records sent during previous 00:00:07.073, last recorded offset: {snapshot=true, scn=19515608845, snapshot_completed=false}
      2021-10-22 14:49:06,476 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot step 7 - Skipping snapshotting of data
      2021-10-22 14:49:06,478 INFO  [io.deb.pip.sou.AbstractSnapshotChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot - Final stage
      2021-10-22 14:49:06,482 INFO  [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=19515608845]]
      2021-10-22 14:49:06,491 INFO  [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Connected metrics set to 'true'
      2021-10-22 14:49:06,492 INFO  [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Starting streaming
      ...
      2021-10-22 14:52:04,784 INFO  [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Oracle Session UGA 0.01MB (max = 1.66MB), PGA 73.16MB (max = 93.72MB)
      2021-10-22 14:52:12,949 INFO  [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Oracle Session UGA 0.01MB (max = 1.66MB), PGA 75.16MB (max = 95.72MB)
      2021-10-22 14:52:21,015 INFO  [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Oracle Session UGA 0.01MB (max = 1.66MB), PGA 77.16MB (max = 97.72MB)
      2021-10-22 14:52:30,685 INFO  [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Oracle Session UGA 0.01MB (max = 1.66MB), PGA 79.16MB (max = 99.78MB)
      2021-10-22 14:52:38,545 ERROR [io.deb.con.ora.log.LogMinerHelper] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Mining session stopped due to the {}: io.debezium.connector.oracle.logminer.parser.DmlParserException: DML statement couldn't be parsed. Please open a Jira issue with the statement 'update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'AUDI' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;'.
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:567)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleDataEvent(AbstractLogMinerEventProcessor.java:413)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:203)
      	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)
      	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:54)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127)
      	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
      	at java.base/java.lang.Thread.run(Thread.java:829)
      Caused by: io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse update DML: 'update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'AUDI' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;'
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:153)
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:75)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:561)
      	... 13 more
      Caused by: io.debezium.DebeziumException: Failed to parse DML: update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'AUDI' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseSetClause(LogMinerDmlParser.java:333)
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:130)
      	... 15 more
      
      2021-10-22 14:52:38,547 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Producer failure: io.debezium.connector.oracle.logminer.parser.DmlParserException: DML statement couldn't be parsed. Please open a Jira issue with the statement 'update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'AUDI' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;'.
      
        at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:567)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleDataEvent(AbstractLogMinerEventProcessor.java:413)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:203)
      	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)
      	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:54)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127)
      	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
      	at java.base/java.lang.Thread.run(Thread.java:829)
      Caused by: io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse update DML: 'update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'TEST' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;'
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:153)
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:75)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:561)
      	... 13 more
      Caused by: io.debezium.DebeziumException: Failed to parse DML: update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'AUDI' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseSetClause(LogMinerDmlParser.java:333)
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:130)
      	... 15 more
      
      2021-10-22 14:52:38,548 INFO  [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) startScn=19515612178, endScn=19515612329
      2021-10-22 14:52:38,551 INFO  [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=19515612329, oldestScn=-1, committedScn=19515612217, offsetScn=19515612178, logMinerQueryCount=51, totalProcessedRows=885, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT2M26.036633S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT5.026196S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT10.573308S, totalBatchProcessingDuration=PT0S, lastBatchProcessingDuration=PT0S, maxBatchProcessingDuration=PT0S, maxBatchProcessingThroughput=0, currentLogFileName=null, minLogFilesMined=0, maxLogFilesMined=0, redoLogStatus=null, switchCounter=0, batchSize=20000, millisecondToSleepBetweenMiningQuery=3000, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT0.194839S, lastStartLogMiningSessionDuration=PT0.006503S, maxStartLogMiningSessionDuration=PT0.016267S, totalProcessTime=PT2M22.286425S, minBatchProcessTime=PT0S, maxBatchProcessTime=PT0S, totalResultSetNextTime=PT0.000797S, lagFromTheSource=DurationPT12.545363S, maxLagFromTheSourceDuration=PT21.381719S, minLagFromTheSourceDuration=PT0S, lastCommitDuration=PT0.000008S, maxCommitDuration=PT0.069301S, activeTransactions=1, rolledBackTransactions=0, committedTransactions=441, abandonedTransactionIds=[], rolledbackTransactionIds=[], registeredDmlCount=0, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=9728, miningSessionUserGlobalAreaMaxMemory=1741024, miningSessionProcessGlobalAreaMemory=83001336, miningSessionProcessGlobalAreaMaxMemory=83001336}
      2021-10-22 14:52:38,552 INFO  [io.deb.con.ora.log.LogMinerStreamingChangeEventSource] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Offsets: OracleOffsetContext [scn=19515612178]
      2021-10-22 14:52:38,552 INFO  [io.deb.pip.ChangeEventSourceCoordinator] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Finished streaming
      2021-10-22 14:52:38,552 INFO  [io.deb.pip.met.StreamingChangeEventSourceMetrics] (debezium-oracleconnector-xxpdb1.eunetuat.eunet.oraclevcn.com-change-event-source-coordinator) Connected metrics set to 'false'
      2021-10-22 14:52:38,724 INFO  [io.deb.con.com.BaseSourceTask] (pool-7-thread-1) Stopping down connector2021-10-22 14:52:38,742 INFO  [io.deb.jdb.JdbcConnection] (pool-8-thread-1) Connection gracefully closed
      2021-10-22 14:52:38,743 INFO  [org.apa.kaf.con.sto.FileOffsetBackingStore] (pool-7-thread-1) Stopped FileOffsetBackingStore
      2021-10-22 14:52:38,744 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:166)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127)
      	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
      	at java.base/java.lang.Thread.run(Thread.java:829)
      Caused by: io.debezium.connector.oracle.logminer.parser.DmlParserException: DML statement couldn't be parsed. Please open a Jira issue with the statement 'update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'AUDI' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;'.
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:567)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleDataEvent(AbstractLogMinerEventProcessor.java:413)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:203)
      	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
      Caused by: io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse update DML: 'update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'AUDI' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;'
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:153)
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:75)
      	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:561)
      	... 13 more
      Caused by: io.debezium.DebeziumException: Failed to parse DML: update "PROJECT"."PUB_SERVICE_AREAS" a set a."CODE" = 'AUDI', a."DESCRIPTION" = 'Test factory', a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), a."ENABLED" = 'Y', a."VERSION" = '2', a."CREATED_BY" = '1008', a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS'), a."LAST_UPDATED_BY" = '1000', a."LAST_UPDATE_DATE" = TO_DATE('2021-10-22 16:52:26', 'YYYY-MM-DD HH24:MI:SS'), a."PUBLISHED" = 'Y', a."ORG_ID" = '3', a."INTERNAL_DESCRIPTION" = NULL, a."PUBLIC_DESCRIPTION" = NULL, a."MARKER_ICON" = NULL, a."STROKE_COLOR" = NULL, a."STROKE_WIDTH" = NULL, a."FILL_COLOR" = NULL, a."GPS_LONG" = NULL, a."GPS_LAT" = NULL where a."ID" = '1012' and a."CODE" = 'AUDI' and a."DESCRIPTION" = 'Test factory' and a."START_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."END_DATE" = TO_DATE('2017-06-28 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and a."ENABLED" = 'Y' and a."VERSION" = '1' and a."CREATED_BY" = '1008' and a."CREATION_DATE" = TO_DATE('2017-06-28 13:33:09', 'YYYY-MM-DD HH24:MI:SS') and a."LAST_UPDATED_BY" = '0' and a."LAST_UPDATE_DATE" = TO_DATE('2019-09-18 22:11:55', 'YYYY-MM-DD HH24:MI:SS') and a."PUBLISHED" = 'Y' and a."ORG_ID" = '3' and a."INTERNAL_DESCRIPTION" IS NULL and a."PUBLIC_DESCRIPTION" IS NULL and a."MARKER_ICON" IS NULL and a."STROKE_COLOR" IS NULL and a."STROKE_WIDTH" IS NULL and a."FILL_COLOR" IS NULL and a."GPS_LONG" IS NULL and a."GPS_LAT" IS NULL;
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseSetClause(LogMinerDmlParser.java:333)
      	at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:130)
      	... 15 more
      
      2021-10-22 14:52:38,754 INFO  [io.deb.ser.DebeziumServer] (main) Received request to stop the engine
      2021-10-22 14:52:38,754 INFO  [io.deb.emb.EmbeddedEngine] (main) Stopping the embedded engine
      2021-10-22 14:52:38,778 INFO  [io.quarkus] (main) debezium-server-dist stopped in 0.034s
       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            offsitesolutions László Bánfalvi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: