-
Bug
-
Resolution: Done
-
Major
-
1.7.0.Final
-
None
-
False
-
False
-
-
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
