We run into the ParsingException: DDL statement couldn't be parsed. See attached trace file for detailed message. The TT-table is a temporary table. This table should never be mined by the logger at all.
The connector is configured as follows:
{
"name": "src-ase1-22041",
"config":
{
"connector.class": "io.debezium.connector.oracle.OracleConnector",
"key.converter": "io.confluent.connect.avro.AvroConverter",
"key.converter.schema.registry.url": "http://swwkafi01c1.suvanet.ch:8081",
"value.converter": "io.confluent.connect.avro.AvroConverter",
"value.converter.schema.registry.url": "http://swwkafi01c1.suvanet.ch:8081",
"database.url": "jdbc:oracle:thin:@//H50L160.suvanet.ch:1521/ASEI01A.suvanet.ch",
"database.user": "DSL_RO",
"database.password": "ENC[AES256_GCM,data:SX8H8wgaQWvqJw==,iv:D2XO64g455zV27Xo5dJy4TNy+lEzDyFKcgBe/gUBrFY=,tag:wwJz1ylVyYJHbBYtIaer/Q==,type:str]",
"database.dbname": "ASEI01A",
"database.server.name": "ASE1",
"table.include.list": "ASEDBUSR.ABRDVRS,ASEDBUSR.ABRDVRSUNT,ASEDBUSR.ACTIVITY,ASEDBUSR.ADRESSE,ASEDBUSR.ADRESSEROLE,ASEDBUSR.ANTRFRAGENANTW,ASEDBUSR.ARBUN,ASEDBUSR.BANK,ASEDBUSR.BEZIEHUNG,ASEDBUSR.BILANZAUSGLEICH,ASEDBUSR.BUCHSTOFFV,ASEDBUSR.BUCHUNGSTOFF",
"snapshot.fetch.size": "10000",
"event.processing.failure.handling.mode": "fail",
"tombstones.on.delete": true,
"message.key.columns": "ASEDBUSR.ABRDVRS:PKEY;ASEDBUSR.ABRDVRSUNT:PKEY;ASEDBUSR.ACTIVITY:PKEY;ASEDBUSR.ADRESSE:PKEY;ASEDBUSR.ADRESSEROLE:PKEY;ASEDBUSR.ANTRFRAGENANTW:PKEY;ASEDBUSR.ARBUN:PKEY;ASEDBUSR.BANK:PKEY;ASEDBUSR.BEZIEHUNG:PKEY;ASEDBUSR.BILANZAUSGLEICH:PKEY;ASEDBUSR.BUCHSTOFFV:PKEY;ASEDBUSR.BUCHUNGSTOFF:PKEY",
"log.mining.strategy": "online_catalog",
"log.mining.archive.destination.name": "LOG_ARCHIVE_DEST_10",
"lob.enabled": true,
"time.precision.mode": "connect",
"tasks.max": "1",
"database.history.kafka.bootstrap.servers": "swwkafi01.suvanet.ch:9092",
"database.history.kafka.topic": "ase.schema-changes.asedbusr",
"database.history.consumer.security.protocol": "SASL_SSL",
"database.history.producer.security.protocol": "SASL_SSL",
"database.history.consumer.sasl.mechanism": "SCRAM-SHA-512",
"database.history.producer.sasl.mechanism": "SCRAM-SHA-512",
"database.history.consumer.sasl.jaas.config": "ENC[AES256_GCM,data:S0ndo7TOp2KhWyQe1MlaFxN/nPUtM66n66Q2irEqfqpHp3U+8dvFPXPksDrCdAtB5EmoGXwdoQ/ImVZLpXBZ97HJXl1muALnTwFiQB//xFYcab/zOj6JiPoKC0E8t3n0YTDhUsNgiO9MqyH4FmGSgFb6Mg==,iv:I/1ELyacwL8CZWcdVe1O+Ng5wdLMu514DhRSlus8A7k=,tag:K+6lIFDkJSYJN92F9IAHWw==,type:str]",
"database.history.producer.sasl.jaas.config": "ENC[AES256_GCM,data:vyf0G9/CbHUEE+P09d2PXgxnBKpCVgbPHbM9t0tKKKbiWu7au5x/4iCCAeS1V5YTRxGt2E1inSXCl6kA6qFLR5eYWeRt6NY6dJrj0SoPkqUki1ekh5n6Wy+CH2WvoTFOluG/qMfZ/t+peqN6skEJ1Tl95g==,iv:670rbvcYVeKtxCFO3aiJaxNcskZLx9Yd91248m5CZGc=,tag:HyRCBFjS6wtGKEsHZvox2Q==,type:str]",
"transforms": "unwrap",
"transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState",
"transforms.unwrap.add.fields": "source.table:META_SRC_TABLENAME,source.ts_ms:META_SRC_TS,op:META_SRC_OP,source.scn:META_SRC_SCN,source.snapshot:META_SRC_SNAPSHOT",
"transforms.unwrap.delete.handling.mode": "rewrite",
"transforms.unwrap.drop.tombstones": false
}
,
"sops": {
"kms": null,
"gcp_kms": null,
"azure_kv": null,
"hc_vault": null,
"age": null,
"lastmodified": "2022-01-31T15:41:07Z",
"mac": "ENC[AES256_GCM,data:5wKnJVDKMvEkBt59Aa816D3JWvGgwvrLuXo7sLMg/vrKlpIuMHoyInvMkPyebJJ26Jgd9dPiR8+kvXCbApCxsJhqGOtJ6Ufluuint0oBHVK6+DoqqJTw+voF0fKSjPYuZLyuGcQkj5HKmI3TCKnuSvs9ZaxINARqAHKSBJty/X8=,iv:k/pvfDDnpSSbpZ0S00qAZ/SOt3/dvqvPh7OudvP0t5g=,tag:4VyrlAiNBGxE79/NHeBRDw==,type:str]",
"pgp": [
{
"created_at": "2022-01-31T15:40:37Z",
"enc": "-----BEGIN PGP MESSAGE-----\n\nhQEMA243CXYlIAr3AQf/e3LH81rHhZOAGucef5Wt/JaVmWJLeykh3NZ1FwGf/Nw/\nzjzXi/HyE5l3j8erOiDR5UgCrtrFS44HH9QkS48Z4l+WZ+VnDOEu9/ONokpYQcyZ\n79KcYxPPp2CiAIVfm6VxKtPoxMxoUwIyrewIK6R88TROwBK5mQvsF2ba9bouADJz\ngOP4Vc4CVAgOhtCH0KsUvTUAmORbl3EbM9V4mbEoXGdpYKNcYgzxUlSbVXQO7zdQ\nA0r4G8tmejn7VixgBjisK3ka6wv8YStY89TVavlM6xMyC6ae9kobKlchb35Ak8xs\n4q4a+3va23aOm6BT7HMB70zGfmCelnywoMQ37/8X39JcAaIrqzSBvlUg0K8eap3m\ntlW/5uD/bAV54UYWF/On/1GYQPNAP7UGv3443qj+xbbW7343eHd3+IpR5BAdE5HI\nXDZD+WKBCG8u6pFcDbO8tb3NERQd2fTqakk2A5k=\n=EXmG\n-----END PGP MESSAGE-----\n",
"fp": "F7067DB106402AABEBEF13F8C6E64E19DC477D85"
}
],
"encrypted_regex": "(database.password|database.history.consumer.sasl.jaas.config|database.history.producer.sasl.jaas.config)",
"version": "3.7.1"
}
}