XML

Word

Printable

Details

Type: Bug
Resolution: Not a Bug
Priority: Blocker
Fix Version/s: None
Affects Version/s: 1.9.2.Final
Component/s: oracle-connector
Labels:
None

Blocked:
False
Blocked Reason:
None
Ready:
False
Steps to Reproduce:
Hide

// code placeholder
Show
// code placeholder

SFDC Cases Counter:
SFDC Cases Links:

Description

In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

Bug report

For bug reports, provide this information, please:

I'm trying to upgrade DBZ 1.8.1.Final to 1.9.2.Final to address an issue in ~~DBZ-5086~~.

The connector connector configuration works in 1.8.1 but not in 1.9.2. I got the following error when i start the connector to 1.9.2.Final.

connect            | [2022-05-09 09:40:08,131] ERROR The 'database.out.server.name' value is invalid: A value is required (io.debezium.connector.common.BaseSourceTask)
connect            | [2022-05-09 09:40:08,133] WARN Using configuration property "table.blacklist" is deprecated and will be removed in future versions. Please use "table.exclude.list" instead. (io.debezium.config.Configuration)
connect            | [2022-05-09 09:40:08,133] WARN Using configuration property "table.blacklist" is deprecated and will be removed in future versions. Please use "table.exclude.list" instead. (io.debezium.config.Configuration)
connect            | [2022-05-09 09:40:08,134] INFO [Producer clientId=connector-producer-star-custom-connector-v3-0] Cluster ID: bM7mrwQaSDKvpOWMPuOY6A (org.apache.kafka.clients.Metadata)
connect            | [2022-05-09 09:40:08,152] ERROR The 'message.key.columns' value 'ENERGOVSERVER.APPLICATIONALLOWED:APPLICATIONALLOWEDID; ENERGOVSERVER.ATTACHMENT:ATTACHMENTID; ENERGOVSERVER.ATTACHMENTGROUP:ATTACHMENTGROUPID; ENERGOVSERVER.BCSASOZONEXREF:PARCEL; ENERGOVSERVER.BCSA_CITY_TO_REGION:CITYNAME; ENERGOVSERVER.BLCONTACTTYPE:BLCONTACTTYPEID; ENERGOVSERVER.BLEXTCOMPANYTYPE:BLEXTCOMPANYTYPEID; ENERGOVSERVER.BLEXTLOCATION:BLEXTLOCATIONID; ENERGOVSERVER.BLEXTSTATUS:BLEXTSTATUSID; ENERGOVSERVER.BLGLOBALENTITYEXTENSION:BLGLOBALENTITYEXTENSIONID; ENERGOVSERVER.BLGLOBALENTITYEXTENSIONADDRESS:BLGLOBALENTITYEXTADDRESSID; ENERGOVSERVER.BLLICENSE:BLLICENSEID; ENERGOVSERVER.BLLICENSEADDRESS:BLLICENSEADDRESSID; ENERGOVSERVER.BLLICENSEBOND:BLLICENSEBONDID; ENERGOVSERVER.BLLICENSECLASS:BLLICENSECLASSID; ENERGOVSERVER.BLLICENSECONTACT:BLLICENSECONTACTID; ENERGOVSERVER.BLLICENSEFEE:BLLICENSEFEEID; ENERGOVSERVER.BLLICENSEHOLD:BLLICENSEHOLDID; ENERGOVSERVER.BLLICENSENOTE:BLLICENSENOTEID; ENERGOVSERVER.BLLICENSEPARCEL:BLLICENSEPARCELID; ENERGOVSERVER.BLLICENSESTATUS:BLLICENSESTATUSID; ENERGOVSERVER.BLLICENSESTATUSSYSTEM:BLLICENSESTATUSSYSTEMID; ENERGOVSERVER.BLLICENSETYPE:BLLICENSETYPEID; ENERGOVSERVER.BLLICENSETYPECLASS:BLLICENSETYPECLASSID; ENERGOVSERVER.BOND:BONDID; ENERGOVSERVER.BONDNOTE:BONDNOTEID; ENERGOVSERVER.BONDSTATUS:BONDSTATUSID; ENERGOVSERVER.BONDTYPE:BONDTYPEID; ENERGOVSERVER.CAACCOUNTACTION:CAACCOUNTACTIONID; ENERGOVSERVER.CACOMPUTEDFEE:CACOMPUTEDFEEID; ENERGOVSERVER.CACOMPUTEDFEEXREF:CACOMPUTEDFEEXREFID; ENERGOVSERVER.CAFEE:CAFEEID; ENERGOVSERVER.CAFEEADJUSTMENT:CAFEEADJUSTMENTID; ENERGOVSERVER.CAFEEADJUSTREASON:CAFEEADJUSTREASONID; ENERGOVSERVER.CAFEEDELETION:CAFEEDELETIONID; ENERGOVSERVER.CAFEETEMPLATE:CAFEETEMPLATEID; ENERGOVSERVER.CAFEETEMPLATEFEE:CAFEETEMPLATEFEEID; ENERGOVSERVER.CAINVOICE:CAINVOICEID; ENERGOVSERVER.CAINVOICECONTACT:CAINVOICECONTACTID; ENERGOVSERVER.CAINVOICEFEE:CAINVOICEFEEID; ENERGOVSERVER.CAINVOICEMISCFEE:CAINVOICEMISCFEEID; ENERGOVSERVER.CAINVOICENOTE:CAINVOICENOTEID; ENERGOVSERVER.CAMISCFEE:CAMISCFEEID; ENERGOVSERVER.CAMISCFEEADJUSTMENT:CAMISCFEEADJUSTMENTID; ENERGOVSERVER.CAPAYMENTMETHOD:CAPAYMENTMETHODID; ENERGOVSERVER.CAPAYMENTSTATUS:CAPAYMENTSTATUSID; ENERGOVSERVER.CAPAYMENTTYPE:CAPAYMENTTYPEID; ENERGOVSERVER.CASTATUS:CASTATUSID; ENERGOVSERVER.CATILLGROUP:TILLGROUPID; ENERGOVSERVER.CATILLSESSION:CATILLSESSIONID; ENERGOVSERVER.CATRANSACTION:CATRANSACTIONID; ENERGOVSERVER.CATRANSACTIONACCOUNT:CATRANSACTIONACCOUNTID; ENERGOVSERVER.CATRANSACTIONFEE:CATRANSACTIONFEEID; ENERGOVSERVER.CATRANSACTIONINVOICE:CATRANSACTIONINVOICEID; ENERGOVSERVER.CATRANSACTIONMISCFEE:CATRANSACTIONMISCFEEID; ENERGOVSERVER.CATRANSACTIONPAYMENT:CATRANSACTIONPAYMENTID; ENERGOVSERVER.CATRANSACTIONSTATUS:CATRANSACTIONSTATUSID; ENERGOVSERVER.CATRANSACTIONTYPE:CATRANSACTIONTYPEID; ENERGOVSERVER.CMCODECASECONTACTTYPE:CMCODECASECONTACTTYPEID; ENERGOVSERVER.CONTACTCONFIRMSTATUS:CONTACTCONFIRMSTATUSID; ENERGOVSERVER.CUSTOMFIELD:GCUSTOMFIELD; ENERGOVSERVER.CUSTOMFIELDLAYOUT:GCUSTOMFIELDLAYOUTS; ENERGOVSERVER.CUSTOMFIELDLAYOUTCONTROLTYPE:ICUSTOMFIELDLAYOUTCONTROLTYPE; ENERGOVSERVER.CUSTOMFIELDMODULES:CUSTOMFIELDMODULEID; ENERGOVSERVER.CUSTOMFIELDOBJECT:GCUSTOMFIELD; ENERGOVSERVER.CUSTOMFIELDPICKLIST:GCUSTOMFIELDPICKLIST; ENERGOVSERVER.CUSTOMFIELDPICKLISTITEM:GCUSTOMFIELDPICKLISTITEM; ENERGOVSERVER.CUSTOMFIELDTYPE:ICUSTOMFIELDTYPE; ENERGOVSERVER.CUSTOMSAVERINDLICENSE:ID; ENERGOVSERVER.CUSTOMSAVERINSPECTIONS:ID; ENERGOVSERVER.CUSTOMSAVERLICENSEMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVEROBJECTMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVERPERMITMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVERSYSTEMSETUP:ID; ENERGOVSERVER.DISTRICT:DISTRICTID; ENERGOVSERVER.GISZONEEXTERNALVALUE:GISZONEEXTERNALVALUEID; ENERGOVSERVER.GISZONETOINSPECTORDESIG:GISZONETOINSPECTORDESIGID; ENERGOVSERVER.GLOBALENTITY:GLOBALENTITYID; ENERGOVSERVER.GLOBALENTITYACCOUNT:GLOBALENTITYACCOUNTID; ENERGOVSERVER.GLOBALENTITYACCOUNTENTITY:GLOBALENTITYACCOUNTENTITYID; ENERGOVSERVER.GLOBALENTITYACCOUNTTYPE:GLOBALENTITYACCOUNTTYPEID; ENERGOVSERVER.GLOBALENTITYHOLD:GLOBALENTITYHOLDID; ENERGOVSERVER.GLOBALPREFFERCOMM:GLOBALPREFFERCOMMID; ENERGOVSERVER.HISTORYPERMITMANAGEMENT:HISTORYPERMITMANAGEMENTID; ENERGOVSERVER.HISTORYSYSTEMSETUP:HISTORYSYSTEMSETUPID; ENERGOVSERVER.HOLDTYPE:HOLDTYPEID; ENERGOVSERVER.HOLDTYPESETUPS:HOLDSETUPID; ENERGOVSERVER.ILLICENSE:ILLICENSEID; ENERGOVSERVER.ILLICENSEADDRESS:ILLICENSEADDRESSID; ENERGOVSERVER.ILLICENSEBOND:ILLICENSEBONDID; ENERGOVSERVER.ILLICENSECLASSIFICATION:ILLICENSECLASSIFICATIONID; ENERGOVSERVER.ILLICENSECONTACT:ILLICENSECONTACTID; ENERGOVSERVER.ILLICENSEFEE:ILLICENSEFEEID; ENERGOVSERVER.ILLICENSEGROUP:ILLICENSEGROUPID; ENERGOVSERVER.ILLICENSEHOLD:ILLICENSEHOLDID; ENERGOVSERVER.ILLICENSENOTE:ILLICENSENOTEID; ENERGOVSERVER.ILLICENSEPARCEL:ILLICENSEPARCELID; ENERGOVSERVER.ILLICENSESTATUS:ILLICENSESTATUSID; ENERGOVSERVER.ILLICENSESTATUSSYSTEM:ILLICENSESTATUSSYSTEMID; ENERGOVSERVER.ILLICENSETYPE:ILLICENSETYPEID; ENERGOVSERVER.ILLICENSETYPELICENSECLASS:ILLICENSETYPELICENSECLASSID; ENERGOVSERVER.IMCHECKLIST:IMCHECKLISTID; ENERGOVSERVER.IMCHECKLISTCATEGORY:IMCHECKLISTCATEGORYID; ENERGOVSERVER.IMINSPECTION:IMINSPECTIONID; ENERGOVSERVER.IMINSPECTIONADDRESS:INSPECTIONADDRESSID; ENERGOVSERVER.IMINSPECTIONCASE:IMINSPECTIONCASEID; ENERGOVSERVER.IMINSPECTIONCASEADDRESS:IMINSPECTIONCASEADDRESSID; ENERGOVSERVER.IMINSPECTIONCASENOTE:IMINSPECTIONCASENOTEID; ENERGOVSERVER.IMINSPECTIONCASESTATUS:IMINSPECTIONCASESTATUSID; ENERGOVSERVER.IMINSPECTIONCASETYPE:IMINSPECTIONCASETYPEID; ENERGOVSERVER.IMINSPECTIONCHECKLISTXREF:IMINSPECTIONCHECKLISTXREFID; ENERGOVSERVER.IMINSPECTIONCONTACT:IMINSPECTIONCONTACTID; ENERGOVSERVER.IMINSPECTIONFEE:IMINSPECTIONFEEID; ENERGOVSERVER.IMINSPECTIONGISASSIGNMENT:IMINSPECTIONGISASSIGNMENTID; ENERGOVSERVER.IMINSPECTIONLINK:IMINSPECTIONLINKID; ENERGOVSERVER.IMINSPECTIONNOTE:IMINSPECTIONNOTEID; ENERGOVSERVER.IMINSPECTIONPARCEL:INSPECTIONPARCELID; ENERGOVSERVER.IMINSPECTIONREQUESTEDSOURCE:IMINSPECTIONREQUESTEDSOURCEID; ENERGOVSERVER.IMINSPECTIONSCHEDULETYPE:IMINSPECTIONSCHEDULETYPEID; ENERGOVSERVER.IMINSPECTIONSTATUS:IMINSPECTIONSTATUSID; ENERGOVSERVER.IMINSPECTIONTYPE:IMINSPECTIONTYPEID; ENERGOVSERVER.IMINSPECTIONTYPEGROUP:IMINSPECTIONTYPEGROUPID; ENERGOVSERVER.IMINSPECTIONZONE:IMINSPECTIONZONEID; ENERGOVSERVER.IMINSPECTORREF:IMINSPECTORREFID; ENERGOVSERVER.LANDMANAGEMENTCONTACTTYPE:LANDMANAGEMENTCONTACTTYPEID; ENERGOVSERVER.LICENSECYCLE:LICENSECYCLEID; ENERGOVSERVER.LICENSECYCLERECURRENCESETUP:LICENSECYCLERECURRENCESETUPID; ENERGOVSERVER.MAILINGADDRESS:MAILINGADDRESSID; ENERGOVSERVER.MAILINGADDRESSCOUNTRYTYPE:MAILINGADDRESSCOUNTRYTYPEID; ENERGOVSERVER.OFFICE:OFFICEID; ENERGOVSERVER.OMOBJECT:OMOBJECTID; ENERGOVSERVER.OMOBJECTADDRESS:OMOBJECTADDRESSID; ENERGOVSERVER.OMOBJECTCLASSIFICATION:OMOBJECTCLASSIFICATIONID; ENERGOVSERVER.OMOBJECTNOTE:OMOBJECTNOTEID; ENERGOVSERVER.OMOBJECTPARCEL:OMOBJECTPARCELID; ENERGOVSERVER.OMOBJECTSTATUS:OMOBJECTSTATUSID; ENERGOVSERVER.OMOBJECTSTATUSSYSTEM:OMOBJECTSTATUSSYSTEMID; ENERGOVSERVER.OMOBJECTTYPE:OMOBJECTTYPEID; ENERGOVSERVER.OMOBJECTTYPECLASS:OMOBJECTTYPECLASSID; ENERGOVSERVER.PARCEL:PARCELID; ENERGOVSERVER.PARCELADDRESS:ADDRESSID; ENERGOVSERVER.PMPERMIT:PMPERMITID; ENERGOVSERVER.PMPERMITADDRESS:PMPERMITADDRESSID; ENERGOVSERVER.PMPERMITBOND:PMPERMITBONDID; ENERGOVSERVER.PMPERMITCONTACT:PMPERMITCONTACTID; ENERGOVSERVER.PMPERMITFEE:PMPERMITFEEID; ENERGOVSERVER.PMPERMITHOLD:PMPERMITHOLDID; ENERGOVSERVER.PMPERMITNOTE:PMPERMITNOTEID; ENERGOVSERVER.PMPERMITOBJECT:PMPERMITOBJECTID; ENERGOVSERVER.PMPERMITPARCEL:PMPERMITPARCELID; ENERGOVSERVER.PMPERMITSTATUS:PMPERMITSTATUSID; ENERGOVSERVER.PMPERMITTYPE:PMPERMITTYPEID; ENERGOVSERVER.PMPERMITTYPEWORKCLASS:PMPERMITTYPEWORKCLASSID; ENERGOVSERVER.PMPERMITWFACTIONSTEP:PMPERMITWFACTIONSTEPID; ENERGOVSERVER.PMPERMITWORKCLASS:PMPERMITWORKCLASSID; ENERGOVSERVER.PMRENEWALCASE:PMRENEWALCASEID; ENERGOVSERVER.PMRENEWALCASEINVOICE:PMRENEWALCASEINVOICEID; ENERGOVSERVER.PMRENEWALCASENOTE:PMRENEWALCASENOTEID; ENERGOVSERVER.PMRENEWALCASETYPE:PMRENEWALCASETYPEID; ENERGOVSERVER.RECURRENCE:RECURRENCEID; ENERGOVSERVER.ROLES:SROLEGUID; ENERGOVSERVER.TIMETRACKING:TIMETRACKINGID; ENERGOVSERVER.USERS:SUSERGUID;ENERGOVSERVER.CUSTOMSAVERPERMITMANAGEMENTMS:ID,CUSTOMFIELDID,CUSTOMFIELDPICKLISTITEMID; ENERGOVSERVER.GLOBALENTITYMAILINGADDRESS:GLOBALENTITYID,MAILINGADDRESSID; ENERGOVSERVER.IMINSPECTIONACTREF:OBJECTID,IMINSPECTIONID; ENERGOVSERVER.OFFICEADDRESS:OFFICEID,MAILLINGADDRESSID;  ENERGOVSERVER.PMRENEWALCASEPERMIT:PMPERMITID,PMRENEWALCASEID;' is invalid: message.key.columns has an invalid format (expecting '^(([^:]+):([^:;\s]+))+[^;]$') (io.debezium.connector.common.BaseSourceTask)
connect            | [2022-05-09 09:40:08,153] INFO WorkerSourceTask{id=star-custom-connector-v3-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask)
connect            | [2022-05-09 09:40:08,153] ERROR WorkerSourceTask{id=star-custom-connector-v3-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask)
connect            | org.apache.kafka.connect.errors.ConnectException: Error configuring an instance of OracleConnectorTask; check the logs for details
connect            |    at io.debezium.connector.common.BaseSourceTask.start(BaseSourceTask.java:96)
connect            |    at org.apache.kafka.connect.runtime.WorkerSourceTask.execute(WorkerSourceTask.java:225)
connect            |    at org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:182)
connect            |    at org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:231)
connect            |    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
connect            |    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
connect            |    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
connect            |    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
connect            |    at java.base/java.lang.Thread.run(Thread.java:829)

What Debezium connector do you use and what version?

DBZ Oracle Connector 1.9.2.Final

What is the connector configuration?

{ "name": "star-custom-connector-v3", "config": \{ "query.fetch.size": "0", "tombstones.on.delete": "true", "decimal.handling.mode": "double", "internal.database.oracle.version": "v1", "database.history.skip.unparseable.ddl": "true", "log.mining.archive.log.only.mode": "false", "sanitize.field.names": "true", "time.precision.mode": "connect", "snapshot.max.threads": "10", "column.exclude.list": "ENERGOVSERVER.GLOBALENTITY.IMAGE, ENERGOVSERVER.PMPERMITWFACTIONSTEP.ICON, ENERGOVSERVER.CUSTOMFIELDOBJECT.CUSTOMIMAGE", "name": "star-custom-connector-v3", "connector.class": "io.debezium.connector.oracle.OracleConnector", "tasks.max": "1", "transforms": "changeTopicCase", "transforms.changeTopicCase.type": "com.github.jcustenborder.kafka.connect.transform.common.ChangeTopicCase", "transforms.changeTopicCase.from": "UPPER_UNDERSCORE", "transforms.changeTopicCase.to": "LOWER_UNDERSCORE", "database.hostname": "10.90.30.83", "database.port": "1521", "database.user": "kminer", "database.password": "**********", "database.server.name": "star", "database.dbname": "stardw", "snapshot.mode": "initial", "database.connection.adapter": "logminer", "log.mining.strategy": "online_catalog", "database.history.kafka.bootstrap.servers": "broker:29092", "database.history.kafka.topic": "dbhistory.star", "table.include.list": "ENERGOVSERVER.APPLICATIONALLOWED, ENERGOVSERVER.ATTACHMENT, ENERGOVSERVER.ATTACHMENTGROUP, ENERGOVSERVER.BCSASOZONEXREF, ENERGOVSERVER.BCSA_CITY_TO_REGION, ENERGOVSERVER.BLCONTACTTYPE, ENERGOVSERVER.BLEXTCOMPANYTYPE, ENERGOVSERVER.BLEXTLOCATION, ENERGOVSERVER.BLEXTSTATUS, ENERGOVSERVER.BLGLOBALENTITYEXTENSION, ENERGOVSERVER.BLGLOBALENTITYEXTENSIONADDRESS, ENERGOVSERVER.BLLICENSE, ENERGOVSERVER.BLLICENSEADDRESS, ENERGOVSERVER.BLLICENSEBOND, ENERGOVSERVER.BLLICENSECLASS, ENERGOVSERVER.BLLICENSECONTACT, ENERGOVSERVER.BLLICENSEFEE, ENERGOVSERVER.BLLICENSEHOLD, ENERGOVSERVER.BLLICENSENOTE, ENERGOVSERVER.BLLICENSEPARCEL, ENERGOVSERVER.BLLICENSESTATUS, ENERGOVSERVER.BLLICENSESTATUSSYSTEM, ENERGOVSERVER.BLLICENSETYPE, ENERGOVSERVER.BLLICENSETYPECLASS, ENERGOVSERVER.BOND, ENERGOVSERVER.BONDNOTE, ENERGOVSERVER.BONDSTATUS, ENERGOVSERVER.BONDTYPE, ENERGOVSERVER.CAACCOUNTACTION, ENERGOVSERVER.CACOMPUTEDFEE, ENERGOVSERVER.CACOMPUTEDFEEXREF, ENERGOVSERVER.CAFEE, ENERGOVSERVER.CAFEEADJUSTMENT, ENERGOVSERVER.CAFEEADJUSTREASON, ENERGOVSERVER.CAFEEDELETION, ENERGOVSERVER.CAFEETEMPLATE, ENERGOVSERVER.CAFEETEMPLATEFEE, ENERGOVSERVER.CAINVOICE, ENERGOVSERVER.CAINVOICECONTACT, ENERGOVSERVER.CAINVOICEFEE, ENERGOVSERVER.CAINVOICEMISCFEE, ENERGOVSERVER.CAINVOICENOTE, ENERGOVSERVER.CAMISCFEE, ENERGOVSERVER.CAMISCFEEADJUSTMENT, ENERGOVSERVER.CAPAYMENTMETHOD, ENERGOVSERVER.CAPAYMENTSTATUS, ENERGOVSERVER.CAPAYMENTTYPE, ENERGOVSERVER.CASTATUS, ENERGOVSERVER.CATILLGROUP, ENERGOVSERVER.CATILLSESSION, ENERGOVSERVER.CATRANSACTION, ENERGOVSERVER.CATRANSACTIONACCOUNT, ENERGOVSERVER.CATRANSACTIONFEE, ENERGOVSERVER.CATRANSACTIONINVOICE, ENERGOVSERVER.CATRANSACTIONMISCFEE, ENERGOVSERVER.CATRANSACTIONPAYMENT, ENERGOVSERVER.CATRANSACTIONSTATUS, ENERGOVSERVER.CATRANSACTIONTYPE, ENERGOVSERVER.CMCODECASECONTACTTYPE, ENERGOVSERVER.CONTACTCONFIRMSTATUS, ENERGOVSERVER.CUSTOMFIELD, ENERGOVSERVER.CUSTOMFIELDLAYOUT, ENERGOVSERVER.CUSTOMFIELDLAYOUTCONTROLTYPE, ENERGOVSERVER.CUSTOMFIELDMODULES, ENERGOVSERVER.CUSTOMFIELDOBJECT, ENERGOVSERVER.CUSTOMFIELDPICKLIST, ENERGOVSERVER.CUSTOMFIELDPICKLISTITEM, ENERGOVSERVER.CUSTOMFIELDTYPE, ENERGOVSERVER.CUSTOMSAVERINDLICENSE, ENERGOVSERVER.CUSTOMSAVERINSPECTIONS, ENERGOVSERVER.CUSTOMSAVERLICENSEMANAGEMENT, ENERGOVSERVER.CUSTOMSAVEROBJECTMANAGEMENT, ENERGOVSERVER.CUSTOMSAVERPERMITMANAGEMENT, ENERGOVSERVER.CUSTOMSAVERPERMITMANAGEMENTMS, ENERGOVSERVER.CUSTOMSAVERSYSTEMSETUP, ENERGOVSERVER.DISTRICT, ENERGOVSERVER.GISZONEEXTERNALVALUE, ENERGOVSERVER.GISZONETOINSPECTORDESIG, ENERGOVSERVER.GLOBALENTITY, ENERGOVSERVER.GLOBALENTITYACCOUNT, ENERGOVSERVER.GLOBALENTITYACCOUNTENTITY, ENERGOVSERVER.GLOBALENTITYACCOUNTTYPE, ENERGOVSERVER.GLOBALENTITYHOLD, ENERGOVSERVER.GLOBALENTITYMAILINGADDRESS, ENERGOVSERVER.GLOBALPREFFERCOMM, ENERGOVSERVER.HISTORYPERMITMANAGEMENT, ENERGOVSERVER.HISTORYSYSTEMSETUP, ENERGOVSERVER.HOLDTYPE, ENERGOVSERVER.HOLDTYPESETUPS, ENERGOVSERVER.ILLICENSE, ENERGOVSERVER.ILLICENSEADDRESS, ENERGOVSERVER.ILLICENSEBOND, ENERGOVSERVER.ILLICENSECLASSIFICATION, ENERGOVSERVER.ILLICENSECONTACT, ENERGOVSERVER.ILLICENSEFEE, ENERGOVSERVER.ILLICENSEGROUP, ENERGOVSERVER.ILLICENSEHOLD, ENERGOVSERVER.ILLICENSENOTE, ENERGOVSERVER.ILLICENSEPARCEL, ENERGOVSERVER.ILLICENSESTATUS, ENERGOVSERVER.ILLICENSESTATUSSYSTEM, ENERGOVSERVER.ILLICENSETYPE, ENERGOVSERVER.ILLICENSETYPELICENSECLASS, ENERGOVSERVER.IMCHECKLIST, ENERGOVSERVER.IMCHECKLISTCATEGORY, ENERGOVSERVER.IMINSPECTION, ENERGOVSERVER.IMINSPECTIONACTREF, ENERGOVSERVER.IMINSPECTIONADDRESS, ENERGOVSERVER.IMINSPECTIONCASE, ENERGOVSERVER.IMINSPECTIONCASEADDRESS, ENERGOVSERVER.IMINSPECTIONCASENOTE, ENERGOVSERVER.IMINSPECTIONCASESTATUS, ENERGOVSERVER.IMINSPECTIONCASETYPE, ENERGOVSERVER.IMINSPECTIONCHECKLISTXREF, ENERGOVSERVER.IMINSPECTIONCONTACT, ENERGOVSERVER.IMINSPECTIONFEE, ENERGOVSERVER.IMINSPECTIONGISASSIGNMENT, ENERGOVSERVER.IMINSPECTIONLINK, ENERGOVSERVER.IMINSPECTIONNOTE, ENERGOVSERVER.IMINSPECTIONPARCEL, ENERGOVSERVER.IMINSPECTIONREQUESTEDSOURCE, ENERGOVSERVER.IMINSPECTIONSCHEDULETYPE, ENERGOVSERVER.IMINSPECTIONSTATUS, ENERGOVSERVER.IMINSPECTIONTYPE, ENERGOVSERVER.IMINSPECTIONTYPEGROUP, ENERGOVSERVER.IMINSPECTIONZONE, ENERGOVSERVER.IMINSPECTORREF, ENERGOVSERVER.LANDMANAGEMENTCONTACTTYPE, ENERGOVSERVER.LICENSECYCLE, ENERGOVSERVER.LICENSECYCLERECURRENCESETUP, ENERGOVSERVER.MAILINGADDRESS, ENERGOVSERVER.MAILINGADDRESSCOUNTRYTYPE, ENERGOVSERVER.OFFICE, ENERGOVSERVER.OFFICEADDRESS, ENERGOVSERVER.OMOBJECT, ENERGOVSERVER.OMOBJECTADDRESS, ENERGOVSERVER.OMOBJECTCLASSIFICATION, ENERGOVSERVER.OMOBJECTNOTE, ENERGOVSERVER.OMOBJECTPARCEL, ENERGOVSERVER.OMOBJECTSTATUS, ENERGOVSERVER.OMOBJECTSTATUSSYSTEM, ENERGOVSERVER.OMOBJECTTYPE, ENERGOVSERVER.OMOBJECTTYPECLASS, ENERGOVSERVER.PARCEL, ENERGOVSERVER.PARCELADDRESS, ENERGOVSERVER.PMPERMIT, ENERGOVSERVER.PMPERMITADDRESS, ENERGOVSERVER.PMPERMITBOND, ENERGOVSERVER.PMPERMITCONTACT, ENERGOVSERVER.PMPERMITFEE, ENERGOVSERVER.PMPERMITHOLD, ENERGOVSERVER.PMPERMITNOTE, ENERGOVSERVER.PMPERMITOBJECT, ENERGOVSERVER.PMPERMITPARCEL, ENERGOVSERVER.PMPERMITSTATUS, ENERGOVSERVER.PMPERMITTYPE, ENERGOVSERVER.PMPERMITTYPEWORKCLASS, ENERGOVSERVER.PMPERMITWFACTIONSTEP, ENERGOVSERVER.PMPERMITWORKCLASS, ENERGOVSERVER.PMRENEWALCASE, ENERGOVSERVER.PMRENEWALCASEINVOICE, ENERGOVSERVER.PMRENEWALCASENOTE, ENERGOVSERVER.PMRENEWALCASEPERMIT, ENERGOVSERVER.PMRENEWALCASETYPE, ENERGOVSERVER.RECURRENCE, ENERGOVSERVER.ROLES, ENERGOVSERVER.TIMETRACKING, ENERGOVSERVER.TMP, ENERGOVSERVER.USERS", "message.key.columns": "ENERGOVSERVER.APPLICATIONALLOWED:APPLICATIONALLOWEDID; ENERGOVSERVER.ATTACHMENT:ATTACHMENTID; ENERGOVSERVER.ATTACHMENTGROUP:ATTACHMENTGROUPID; ENERGOVSERVER.BCSASOZONEXREF:PARCEL; ENERGOVSERVER.BCSA_CITY_TO_REGION:CITYNAME; ENERGOVSERVER.BLCONTACTTYPE:BLCONTACTTYPEID; ENERGOVSERVER.BLEXTCOMPANYTYPE:BLEXTCOMPANYTYPEID; ENERGOVSERVER.BLEXTLOCATION:BLEXTLOCATIONID; ENERGOVSERVER.BLEXTSTATUS:BLEXTSTATUSID; ENERGOVSERVER.BLGLOBALENTITYEXTENSION:BLGLOBALENTITYEXTENSIONID; ENERGOVSERVER.BLGLOBALENTITYEXTENSIONADDRESS:BLGLOBALENTITYEXTADDRESSID; ENERGOVSERVER.BLLICENSE:BLLICENSEID; ENERGOVSERVER.BLLICENSEADDRESS:BLLICENSEADDRESSID; ENERGOVSERVER.BLLICENSEBOND:BLLICENSEBONDID; ENERGOVSERVER.BLLICENSECLASS:BLLICENSECLASSID; ENERGOVSERVER.BLLICENSECONTACT:BLLICENSECONTACTID; ENERGOVSERVER.BLLICENSEFEE:BLLICENSEFEEID; ENERGOVSERVER.BLLICENSEHOLD:BLLICENSEHOLDID; ENERGOVSERVER.BLLICENSENOTE:BLLICENSENOTEID; ENERGOVSERVER.BLLICENSEPARCEL:BLLICENSEPARCELID; ENERGOVSERVER.BLLICENSESTATUS:BLLICENSESTATUSID; ENERGOVSERVER.BLLICENSESTATUSSYSTEM:BLLICENSESTATUSSYSTEMID; ENERGOVSERVER.BLLICENSETYPE:BLLICENSETYPEID; ENERGOVSERVER.BLLICENSETYPECLASS:BLLICENSETYPECLASSID; ENERGOVSERVER.BOND:BONDID; ENERGOVSERVER.BONDNOTE:BONDNOTEID; ENERGOVSERVER.BONDSTATUS:BONDSTATUSID; ENERGOVSERVER.BONDTYPE:BONDTYPEID; ENERGOVSERVER.CAACCOUNTACTION:CAACCOUNTACTIONID; ENERGOVSERVER.CACOMPUTEDFEE:CACOMPUTEDFEEID; ENERGOVSERVER.CACOMPUTEDFEEXREF:CACOMPUTEDFEEXREFID; ENERGOVSERVER.CAFEE:CAFEEID; ENERGOVSERVER.CAFEEADJUSTMENT:CAFEEADJUSTMENTID; ENERGOVSERVER.CAFEEADJUSTREASON:CAFEEADJUSTREASONID; ENERGOVSERVER.CAFEEDELETION:CAFEEDELETIONID; ENERGOVSERVER.CAFEETEMPLATE:CAFEETEMPLATEID; ENERGOVSERVER.CAFEETEMPLATEFEE:CAFEETEMPLATEFEEID; ENERGOVSERVER.CAINVOICE:CAINVOICEID; ENERGOVSERVER.CAINVOICECONTACT:CAINVOICECONTACTID; ENERGOVSERVER.CAINVOICEFEE:CAINVOICEFEEID; ENERGOVSERVER.CAINVOICEMISCFEE:CAINVOICEMISCFEEID; ENERGOVSERVER.CAINVOICENOTE:CAINVOICENOTEID; ENERGOVSERVER.CAMISCFEE:CAMISCFEEID; ENERGOVSERVER.CAMISCFEEADJUSTMENT:CAMISCFEEADJUSTMENTID; ENERGOVSERVER.CAPAYMENTMETHOD:CAPAYMENTMETHODID; ENERGOVSERVER.CAPAYMENTSTATUS:CAPAYMENTSTATUSID; ENERGOVSERVER.CAPAYMENTTYPE:CAPAYMENTTYPEID; ENERGOVSERVER.CASTATUS:CASTATUSID; ENERGOVSERVER.CATILLGROUP:TILLGROUPID; ENERGOVSERVER.CATILLSESSION:CATILLSESSIONID; ENERGOVSERVER.CATRANSACTION:CATRANSACTIONID; ENERGOVSERVER.CATRANSACTIONACCOUNT:CATRANSACTIONACCOUNTID; ENERGOVSERVER.CATRANSACTIONFEE:CATRANSACTIONFEEID; ENERGOVSERVER.CATRANSACTIONINVOICE:CATRANSACTIONINVOICEID; ENERGOVSERVER.CATRANSACTIONMISCFEE:CATRANSACTIONMISCFEEID; ENERGOVSERVER.CATRANSACTIONPAYMENT:CATRANSACTIONPAYMENTID; ENERGOVSERVER.CATRANSACTIONSTATUS:CATRANSACTIONSTATUSID; ENERGOVSERVER.CATRANSACTIONTYPE:CATRANSACTIONTYPEID; ENERGOVSERVER.CMCODECASECONTACTTYPE:CMCODECASECONTACTTYPEID; ENERGOVSERVER.CONTACTCONFIRMSTATUS:CONTACTCONFIRMSTATUSID; ENERGOVSERVER.CUSTOMFIELD:GCUSTOMFIELD; ENERGOVSERVER.CUSTOMFIELDLAYOUT:GCUSTOMFIELDLAYOUTS; ENERGOVSERVER.CUSTOMFIELDLAYOUTCONTROLTYPE:ICUSTOMFIELDLAYOUTCONTROLTYPE; ENERGOVSERVER.CUSTOMFIELDMODULES:CUSTOMFIELDMODULEID; ENERGOVSERVER.CUSTOMFIELDOBJECT:GCUSTOMFIELD; ENERGOVSERVER.CUSTOMFIELDPICKLIST:GCUSTOMFIELDPICKLIST; ENERGOVSERVER.CUSTOMFIELDPICKLISTITEM:GCUSTOMFIELDPICKLISTITEM; ENERGOVSERVER.CUSTOMFIELDTYPE:ICUSTOMFIELDTYPE; ENERGOVSERVER.CUSTOMSAVERINDLICENSE:ID; ENERGOVSERVER.CUSTOMSAVERINSPECTIONS:ID; ENERGOVSERVER.CUSTOMSAVERLICENSEMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVEROBJECTMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVERPERMITMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVERSYSTEMSETUP:ID; ENERGOVSERVER.DISTRICT:DISTRICTID; ENERGOVSERVER.GISZONEEXTERNALVALUE:GISZONEEXTERNALVALUEID; ENERGOVSERVER.GISZONETOINSPECTORDESIG:GISZONETOINSPECTORDESIGID; ENERGOVSERVER.GLOBALENTITY:GLOBALENTITYID; ENERGOVSERVER.GLOBALENTITYACCOUNT:GLOBALENTITYACCOUNTID; ENERGOVSERVER.GLOBALENTITYACCOUNTENTITY:GLOBALENTITYACCOUNTENTITYID; ENERGOVSERVER.GLOBALENTITYACCOUNTTYPE:GLOBALENTITYACCOUNTTYPEID; ENERGOVSERVER.GLOBALENTITYHOLD:GLOBALENTITYHOLDID; ENERGOVSERVER.GLOBALPREFFERCOMM:GLOBALPREFFERCOMMID; ENERGOVSERVER.HISTORYPERMITMANAGEMENT:HISTORYPERMITMANAGEMENTID; ENERGOVSERVER.HISTORYSYSTEMSETUP:HISTORYSYSTEMSETUPID; ENERGOVSERVER.HOLDTYPE:HOLDTYPEID; ENERGOVSERVER.HOLDTYPESETUPS:HOLDSETUPID; ENERGOVSERVER.ILLICENSE:ILLICENSEID; ENERGOVSERVER.ILLICENSEADDRESS:ILLICENSEADDRESSID; ENERGOVSERVER.ILLICENSEBOND:ILLICENSEBONDID; ENERGOVSERVER.ILLICENSECLASSIFICATION:ILLICENSECLASSIFICATIONID; ENERGOVSERVER.ILLICENSECONTACT:ILLICENSECONTACTID; ENERGOVSERVER.ILLICENSEFEE:ILLICENSEFEEID; ENERGOVSERVER.ILLICENSEGROUP:ILLICENSEGROUPID; ENERGOVSERVER.ILLICENSEHOLD:ILLICENSEHOLDID; ENERGOVSERVER.ILLICENSENOTE:ILLICENSENOTEID; ENERGOVSERVER.ILLICENSEPARCEL:ILLICENSEPARCELID; ENERGOVSERVER.ILLICENSESTATUS:ILLICENSESTATUSID; ENERGOVSERVER.ILLICENSESTATUSSYSTEM:ILLICENSESTATUSSYSTEMID; ENERGOVSERVER.ILLICENSETYPE:ILLICENSETYPEID; ENERGOVSERVER.ILLICENSETYPELICENSECLASS:ILLICENSETYPELICENSECLASSID; ENERGOVSERVER.IMCHECKLIST:IMCHECKLISTID; ENERGOVSERVER.IMCHECKLISTCATEGORY:IMCHECKLISTCATEGORYID; ENERGOVSERVER.IMINSPECTION:IMINSPECTIONID; ENERGOVSERVER.IMINSPECTIONADDRESS:INSPECTIONADDRESSID; ENERGOVSERVER.IMINSPECTIONCASE:IMINSPECTIONCASEID; ENERGOVSERVER.IMINSPECTIONCASEADDRESS:IMINSPECTIONCASEADDRESSID; ENERGOVSERVER.IMINSPECTIONCASENOTE:IMINSPECTIONCASENOTEID; ENERGOVSERVER.IMINSPECTIONCASESTATUS:IMINSPECTIONCASESTATUSID; ENERGOVSERVER.IMINSPECTIONCASETYPE:IMINSPECTIONCASETYPEID; ENERGOVSERVER.IMINSPECTIONCHECKLISTXREF:IMINSPECTIONCHECKLISTXREFID; ENERGOVSERVER.IMINSPECTIONCONTACT:IMINSPECTIONCONTACTID; ENERGOVSERVER.IMINSPECTIONFEE:IMINSPECTIONFEEID; ENERGOVSERVER.IMINSPECTIONGISASSIGNMENT:IMINSPECTIONGISASSIGNMENTID; ENERGOVSERVER.IMINSPECTIONLINK:IMINSPECTIONLINKID; ENERGOVSERVER.IMINSPECTIONNOTE:IMINSPECTIONNOTEID; ENERGOVSERVER.IMINSPECTIONPARCEL:INSPECTIONPARCELID; ENERGOVSERVER.IMINSPECTIONREQUESTEDSOURCE:IMINSPECTIONREQUESTEDSOURCEID; ENERGOVSERVER.IMINSPECTIONSCHEDULETYPE:IMINSPECTIONSCHEDULETYPEID; ENERGOVSERVER.IMINSPECTIONSTATUS:IMINSPECTIONSTATUSID; ENERGOVSERVER.IMINSPECTIONTYPE:IMINSPECTIONTYPEID; ENERGOVSERVER.IMINSPECTIONTYPEGROUP:IMINSPECTIONTYPEGROUPID; ENERGOVSERVER.IMINSPECTIONZONE:IMINSPECTIONZONEID; ENERGOVSERVER.IMINSPECTORREF:IMINSPECTORREFID; ENERGOVSERVER.LANDMANAGEMENTCONTACTTYPE:LANDMANAGEMENTCONTACTTYPEID; ENERGOVSERVER.LICENSECYCLE:LICENSECYCLEID; ENERGOVSERVER.LICENSECYCLERECURRENCESETUP:LICENSECYCLERECURRENCESETUPID; ENERGOVSERVER.MAILINGADDRESS:MAILINGADDRESSID; ENERGOVSERVER.MAILINGADDRESSCOUNTRYTYPE:MAILINGADDRESSCOUNTRYTYPEID; ENERGOVSERVER.OFFICE:OFFICEID; ENERGOVSERVER.OMOBJECT:OMOBJECTID; ENERGOVSERVER.OMOBJECTADDRESS:OMOBJECTADDRESSID; ENERGOVSERVER.OMOBJECTCLASSIFICATION:OMOBJECTCLASSIFICATIONID; ENERGOVSERVER.OMOBJECTNOTE:OMOBJECTNOTEID; ENERGOVSERVER.OMOBJECTPARCEL:OMOBJECTPARCELID; ENERGOVSERVER.OMOBJECTSTATUS:OMOBJECTSTATUSID; ENERGOVSERVER.OMOBJECTSTATUSSYSTEM:OMOBJECTSTATUSSYSTEMID; ENERGOVSERVER.OMOBJECTTYPE:OMOBJECTTYPEID; ENERGOVSERVER.OMOBJECTTYPECLASS:OMOBJECTTYPECLASSID; ENERGOVSERVER.PARCEL:PARCELID; ENERGOVSERVER.PARCELADDRESS:ADDRESSID; ENERGOVSERVER.PMPERMIT:PMPERMITID; ENERGOVSERVER.PMPERMITADDRESS:PMPERMITADDRESSID; ENERGOVSERVER.PMPERMITBOND:PMPERMITBONDID; ENERGOVSERVER.PMPERMITCONTACT:PMPERMITCONTACTID; ENERGOVSERVER.PMPERMITFEE:PMPERMITFEEID; ENERGOVSERVER.PMPERMITHOLD:PMPERMITHOLDID; ENERGOVSERVER.PMPERMITNOTE:PMPERMITNOTEID; ENERGOVSERVER.PMPERMITOBJECT:PMPERMITOBJECTID; ENERGOVSERVER.PMPERMITPARCEL:PMPERMITPARCELID; ENERGOVSERVER.PMPERMITSTATUS:PMPERMITSTATUSID; ENERGOVSERVER.PMPERMITTYPE:PMPERMITTYPEID; ENERGOVSERVER.PMPERMITTYPEWORKCLASS:PMPERMITTYPEWORKCLASSID; ENERGOVSERVER.PMPERMITWFACTIONSTEP:PMPERMITWFACTIONSTEPID; ENERGOVSERVER.PMPERMITWORKCLASS:PMPERMITWORKCLASSID; ENERGOVSERVER.PMRENEWALCASE:PMRENEWALCASEID; ENERGOVSERVER.PMRENEWALCASEINVOICE:PMRENEWALCASEINVOICEID; ENERGOVSERVER.PMRENEWALCASENOTE:PMRENEWALCASENOTEID; ENERGOVSERVER.PMRENEWALCASETYPE:PMRENEWALCASETYPEID; ENERGOVSERVER.RECURRENCE:RECURRENCEID; ENERGOVSERVER.ROLES:SROLEGUID; ENERGOVSERVER.TIMETRACKING:TIMETRACKINGID; ENERGOVSERVER.USERS:SUSERGUID;ENERGOVSERVER.CUSTOMSAVERPERMITMANAGEMENTMS:ID,CUSTOMFIELDID,CUSTOMFIELDPICKLISTITEMID; ENERGOVSERVER.GLOBALENTITYMAILINGADDRESS:GLOBALENTITYID,MAILINGADDRESSID; ENERGOVSERVER.IMINSPECTIONACTREF:OBJECTID,IMINSPECTIONID; ENERGOVSERVER.OFFICEADDRESS:OFFICEID,MAILLINGADDRESSID; ENERGOVSERVER.PMRENEWALCASEPERMIT:PMPERMITID,PMRENEWALCASEID;", "poll.interval.ms": "1000", "max.batch.size": "2048", "snapshot.fetch.size": "10000" }

}

What is the captured database version and mode of depoyment?

I'm running Oracle 11.2.0.4 on premise.

What behaviour do you expect?

I would expect the new version can handle the previous configuration properly.

What behaviour do you see?

I'm seeing the below error in the console log

connect            | [2022-05-09 09:40:08,131] ERROR The 'database.out.server.name' value is invalid: A value is required (io.debezium.connector.common.BaseSourceTask)
connect            | [2022-05-09 09:40:08,133] WARN Using configuration property "table.blacklist" is deprecated and will be removed in future versions. Please use "table.exclude.list" instead. (io.debezium.config.Configuration)
connect            | [2022-05-09 09:40:08,133] WARN Using configuration property "table.blacklist" is deprecated and will be removed in future versions. Please use "table.exclude.list" instead. (io.debezium.config.Configuration)
connect            | [2022-05-09 09:40:08,134] INFO [Producer clientId=connector-producer-star-custom-connector-v3-0] Cluster ID: bM7mrwQaSDKvpOWMPuOY6A (org.apache.kafka.clients.Metadata)
connect            | [2022-05-09 09:40:08,152] ERROR The 'message.key.columns' value 'ENERGOVSERVER.APPLICATIONALLOWED:APPLICATIONALLOWEDID; ENERGOVSERVER.ATTACHMENT:ATTACHMENTID; ENERGOVSERVER.ATTACHMENTGROUP:ATTACHMENTGROUPID; ENERGOVSERVER.BCSASOZONEXREF:PARCEL; ENERGOVSERVER.BCSA_CITY_TO_REGION:CITYNAME; ENERGOVSERVER.BLCONTACTTYPE:BLCONTACTTYPEID; ENERGOVSERVER.BLEXTCOMPANYTYPE:BLEXTCOMPANYTYPEID; ENERGOVSERVER.BLEXTLOCATION:BLEXTLOCATIONID; ENERGOVSERVER.BLEXTSTATUS:BLEXTSTATUSID; ENERGOVSERVER.BLGLOBALENTITYEXTENSION:BLGLOBALENTITYEXTENSIONID; ENERGOVSERVER.BLGLOBALENTITYEXTENSIONADDRESS:BLGLOBALENTITYEXTADDRESSID; ENERGOVSERVER.BLLICENSE:BLLICENSEID; ENERGOVSERVER.BLLICENSEADDRESS:BLLICENSEADDRESSID; ENERGOVSERVER.BLLICENSEBOND:BLLICENSEBONDID; ENERGOVSERVER.BLLICENSECLASS:BLLICENSECLASSID; ENERGOVSERVER.BLLICENSECONTACT:BLLICENSECONTACTID; ENERGOVSERVER.BLLICENSEFEE:BLLICENSEFEEID; ENERGOVSERVER.BLLICENSEHOLD:BLLICENSEHOLDID; ENERGOVSERVER.BLLICENSENOTE:BLLICENSENOTEID; ENERGOVSERVER.BLLICENSEPARCEL:BLLICENSEPARCELID; ENERGOVSERVER.BLLICENSESTATUS:BLLICENSESTATUSID; ENERGOVSERVER.BLLICENSESTATUSSYSTEM:BLLICENSESTATUSSYSTEMID; ENERGOVSERVER.BLLICENSETYPE:BLLICENSETYPEID; ENERGOVSERVER.BLLICENSETYPECLASS:BLLICENSETYPECLASSID; ENERGOVSERVER.BOND:BONDID; ENERGOVSERVER.BONDNOTE:BONDNOTEID; ENERGOVSERVER.BONDSTATUS:BONDSTATUSID; ENERGOVSERVER.BONDTYPE:BONDTYPEID; ENERGOVSERVER.CAACCOUNTACTION:CAACCOUNTACTIONID; ENERGOVSERVER.CACOMPUTEDFEE:CACOMPUTEDFEEID; ENERGOVSERVER.CACOMPUTEDFEEXREF:CACOMPUTEDFEEXREFID; ENERGOVSERVER.CAFEE:CAFEEID; ENERGOVSERVER.CAFEEADJUSTMENT:CAFEEADJUSTMENTID; ENERGOVSERVER.CAFEEADJUSTREASON:CAFEEADJUSTREASONID; ENERGOVSERVER.CAFEEDELETION:CAFEEDELETIONID; ENERGOVSERVER.CAFEETEMPLATE:CAFEETEMPLATEID; ENERGOVSERVER.CAFEETEMPLATEFEE:CAFEETEMPLATEFEEID; ENERGOVSERVER.CAINVOICE:CAINVOICEID; ENERGOVSERVER.CAINVOICECONTACT:CAINVOICECONTACTID; ENERGOVSERVER.CAINVOICEFEE:CAINVOICEFEEID; ENERGOVSERVER.CAINVOICEMISCFEE:CAINVOICEMISCFEEID; ENERGOVSERVER.CAINVOICENOTE:CAINVOICENOTEID; ENERGOVSERVER.CAMISCFEE:CAMISCFEEID; ENERGOVSERVER.CAMISCFEEADJUSTMENT:CAMISCFEEADJUSTMENTID; ENERGOVSERVER.CAPAYMENTMETHOD:CAPAYMENTMETHODID; ENERGOVSERVER.CAPAYMENTSTATUS:CAPAYMENTSTATUSID; ENERGOVSERVER.CAPAYMENTTYPE:CAPAYMENTTYPEID; ENERGOVSERVER.CASTATUS:CASTATUSID; ENERGOVSERVER.CATILLGROUP:TILLGROUPID; ENERGOVSERVER.CATILLSESSION:CATILLSESSIONID; ENERGOVSERVER.CATRANSACTION:CATRANSACTIONID; ENERGOVSERVER.CATRANSACTIONACCOUNT:CATRANSACTIONACCOUNTID; ENERGOVSERVER.CATRANSACTIONFEE:CATRANSACTIONFEEID; ENERGOVSERVER.CATRANSACTIONINVOICE:CATRANSACTIONINVOICEID; ENERGOVSERVER.CATRANSACTIONMISCFEE:CATRANSACTIONMISCFEEID; ENERGOVSERVER.CATRANSACTIONPAYMENT:CATRANSACTIONPAYMENTID; ENERGOVSERVER.CATRANSACTIONSTATUS:CATRANSACTIONSTATUSID; ENERGOVSERVER.CATRANSACTIONTYPE:CATRANSACTIONTYPEID; ENERGOVSERVER.CMCODECASECONTACTTYPE:CMCODECASECONTACTTYPEID; ENERGOVSERVER.CONTACTCONFIRMSTATUS:CONTACTCONFIRMSTATUSID; ENERGOVSERVER.CUSTOMFIELD:GCUSTOMFIELD; ENERGOVSERVER.CUSTOMFIELDLAYOUT:GCUSTOMFIELDLAYOUTS; ENERGOVSERVER.CUSTOMFIELDLAYOUTCONTROLTYPE:ICUSTOMFIELDLAYOUTCONTROLTYPE; ENERGOVSERVER.CUSTOMFIELDMODULES:CUSTOMFIELDMODULEID; ENERGOVSERVER.CUSTOMFIELDOBJECT:GCUSTOMFIELD; ENERGOVSERVER.CUSTOMFIELDPICKLIST:GCUSTOMFIELDPICKLIST; ENERGOVSERVER.CUSTOMFIELDPICKLISTITEM:GCUSTOMFIELDPICKLISTITEM; ENERGOVSERVER.CUSTOMFIELDTYPE:ICUSTOMFIELDTYPE; ENERGOVSERVER.CUSTOMSAVERINDLICENSE:ID; ENERGOVSERVER.CUSTOMSAVERINSPECTIONS:ID; ENERGOVSERVER.CUSTOMSAVERLICENSEMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVEROBJECTMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVERPERMITMANAGEMENT:ID; ENERGOVSERVER.CUSTOMSAVERSYSTEMSETUP:ID; ENERGOVSERVER.DISTRICT:DISTRICTID; ENERGOVSERVER.GISZONEEXTERNALVALUE:GISZONEEXTERNALVALUEID; ENERGOVSERVER.GISZONETOINSPECTORDESIG:GISZONETOINSPECTORDESIGID; ENERGOVSERVER.GLOBALENTITY:GLOBALENTITYID; ENERGOVSERVER.GLOBALENTITYACCOUNT:GLOBALENTITYACCOUNTID; ENERGOVSERVER.GLOBALENTITYACCOUNTENTITY:GLOBALENTITYACCOUNTENTITYID; ENERGOVSERVER.GLOBALENTITYACCOUNTTYPE:GLOBALENTITYACCOUNTTYPEID; ENERGOVSERVER.GLOBALENTITYHOLD:GLOBALENTITYHOLDID; ENERGOVSERVER.GLOBALPREFFERCOMM:GLOBALPREFFERCOMMID; ENERGOVSERVER.HISTORYPERMITMANAGEMENT:HISTORYPERMITMANAGEMENTID; ENERGOVSERVER.HISTORYSYSTEMSETUP:HISTORYSYSTEMSETUPID; ENERGOVSERVER.HOLDTYPE:HOLDTYPEID; ENERGOVSERVER.HOLDTYPESETUPS:HOLDSETUPID; ENERGOVSERVER.ILLICENSE:ILLICENSEID; ENERGOVSERVER.ILLICENSEADDRESS:ILLICENSEADDRESSID; ENERGOVSERVER.ILLICENSEBOND:ILLICENSEBONDID; ENERGOVSERVER.ILLICENSECLASSIFICATION:ILLICENSECLASSIFICATIONID; ENERGOVSERVER.ILLICENSECONTACT:ILLICENSECONTACTID; ENERGOVSERVER.ILLICENSEFEE:ILLICENSEFEEID; ENERGOVSERVER.ILLICENSEGROUP:ILLICENSEGROUPID; ENERGOVSERVER.ILLICENSEHOLD:ILLICENSEHOLDID; ENERGOVSERVER.ILLICENSENOTE:ILLICENSENOTEID; ENERGOVSERVER.ILLICENSEPARCEL:ILLICENSEPARCELID; ENERGOVSERVER.ILLICENSESTATUS:ILLICENSESTATUSID; ENERGOVSERVER.ILLICENSESTATUSSYSTEM:ILLICENSESTATUSSYSTEMID; ENERGOVSERVER.ILLICENSETYPE:ILLICENSETYPEID; ENERGOVSERVER.ILLICENSETYPELICENSECLASS:ILLICENSETYPELICENSECLASSID; ENERGOVSERVER.IMCHECKLIST:IMCHECKLISTID; ENERGOVSERVER.IMCHECKLISTCATEGORY:IMCHECKLISTCATEGORYID; ENERGOVSERVER.IMINSPECTION:IMINSPECTIONID; ENERGOVSERVER.IMINSPECTIONADDRESS:INSPECTIONADDRESSID; ENERGOVSERVER.IMINSPECTIONCASE:IMINSPECTIONCASEID; ENERGOVSERVER.IMINSPECTIONCASEADDRESS:IMINSPECTIONCASEADDRESSID; ENERGOVSERVER.IMINSPECTIONCASENOTE:IMINSPECTIONCASENOTEID; ENERGOVSERVER.IMINSPECTIONCASESTATUS:IMINSPECTIONCASESTATUSID; ENERGOVSERVER.IMINSPECTIONCASETYPE:IMINSPECTIONCASETYPEID; ENERGOVSERVER.IMINSPECTIONCHECKLISTXREF:IMINSPECTIONCHECKLISTXREFID; ENERGOVSERVER.IMINSPECTIONCONTACT:IMINSPECTIONCONTACTID; ENERGOVSERVER.IMINSPECTIONFEE:IMINSPECTIONFEEID; ENERGOVSERVER.IMINSPECTIONGISASSIGNMENT:IMINSPECTIONGISASSIGNMENTID; ENERGOVSERVER.IMINSPECTIONLINK:IMINSPECTIONLINKID; ENERGOVSERVER.IMINSPECTIONNOTE:IMINSPECTIONNOTEID; ENERGOVSERVER.IMINSPECTIONPARCEL:INSPECTIONPARCELID; ENERGOVSERVER.IMINSPECTIONREQUESTEDSOURCE:IMINSPECTIONREQUESTEDSOURCEID; ENERGOVSERVER.IMINSPECTIONSCHEDULETYPE:IMINSPECTIONSCHEDULETYPEID; ENERGOVSERVER.IMINSPECTIONSTATUS:IMINSPECTIONSTATUSID; ENERGOVSERVER.IMINSPECTIONTYPE:IMINSPECTIONTYPEID; ENERGOVSERVER.IMINSPECTIONTYPEGROUP:IMINSPECTIONTYPEGROUPID; ENERGOVSERVER.IMINSPECTIONZONE:IMINSPECTIONZONEID; ENERGOVSERVER.IMINSPECTORREF:IMINSPECTORREFID; ENERGOVSERVER.LANDMANAGEMENTCONTACTTYPE:LANDMANAGEMENTCONTACTTYPEID; ENERGOVSERVER.LICENSECYCLE:LICENSECYCLEID; ENERGOVSERVER.LICENSECYCLERECURRENCESETUP:LICENSECYCLERECURRENCESETUPID; ENERGOVSERVER.MAILINGADDRESS:MAILINGADDRESSID; ENERGOVSERVER.MAILINGADDRESSCOUNTRYTYPE:MAILINGADDRESSCOUNTRYTYPEID; ENERGOVSERVER.OFFICE:OFFICEID; ENERGOVSERVER.OMOBJECT:OMOBJECTID; ENERGOVSERVER.OMOBJECTADDRESS:OMOBJECTADDRESSID; ENERGOVSERVER.OMOBJECTCLASSIFICATION:OMOBJECTCLASSIFICATIONID; ENERGOVSERVER.OMOBJECTNOTE:OMOBJECTNOTEID; ENERGOVSERVER.OMOBJECTPARCEL:OMOBJECTPARCELID; ENERGOVSERVER.OMOBJECTSTATUS:OMOBJECTSTATUSID; ENERGOVSERVER.OMOBJECTSTATUSSYSTEM:OMOBJECTSTATUSSYSTEMID; ENERGOVSERVER.OMOBJECTTYPE:OMOBJECTTYPEID; ENERGOVSERVER.OMOBJECTTYPECLASS:OMOBJECTTYPECLASSID; ENERGOVSERVER.PARCEL:PARCELID; ENERGOVSERVER.PARCELADDRESS:ADDRESSID; ENERGOVSERVER.PMPERMIT:PMPERMITID; ENERGOVSERVER.PMPERMITADDRESS:PMPERMITADDRESSID; ENERGOVSERVER.PMPERMITBOND:PMPERMITBONDID; ENERGOVSERVER.PMPERMITCONTACT:PMPERMITCONTACTID; ENERGOVSERVER.PMPERMITFEE:PMPERMITFEEID; ENERGOVSERVER.PMPERMITHOLD:PMPERMITHOLDID; ENERGOVSERVER.PMPERMITNOTE:PMPERMITNOTEID; ENERGOVSERVER.PMPERMITOBJECT:PMPERMITOBJECTID; ENERGOVSERVER.PMPERMITPARCEL:PMPERMITPARCELID; ENERGOVSERVER.PMPERMITSTATUS:PMPERMITSTATUSID; ENERGOVSERVER.PMPERMITTYPE:PMPERMITTYPEID; ENERGOVSERVER.PMPERMITTYPEWORKCLASS:PMPERMITTYPEWORKCLASSID; ENERGOVSERVER.PMPERMITWFACTIONSTEP:PMPERMITWFACTIONSTEPID; ENERGOVSERVER.PMPERMITWORKCLASS:PMPERMITWORKCLASSID; ENERGOVSERVER.PMRENEWALCASE:PMRENEWALCASEID; ENERGOVSERVER.PMRENEWALCASEINVOICE:PMRENEWALCASEINVOICEID; ENERGOVSERVER.PMRENEWALCASENOTE:PMRENEWALCASENOTEID; ENERGOVSERVER.PMRENEWALCASETYPE:PMRENEWALCASETYPEID; ENERGOVSERVER.RECURRENCE:RECURRENCEID; ENERGOVSERVER.ROLES:SROLEGUID; ENERGOVSERVER.TIMETRACKING:TIMETRACKINGID; ENERGOVSERVER.USERS:SUSERGUID;ENERGOVSERVER.CUSTOMSAVERPERMITMANAGEMENTMS:ID,CUSTOMFIELDID,CUSTOMFIELDPICKLISTITEMID; ENERGOVSERVER.GLOBALENTITYMAILINGADDRESS:GLOBALENTITYID,MAILINGADDRESSID; ENERGOVSERVER.IMINSPECTIONACTREF:OBJECTID,IMINSPECTIONID; ENERGOVSERVER.OFFICEADDRESS:OFFICEID,MAILLINGADDRESSID;  ENERGOVSERVER.PMRENEWALCASEPERMIT:PMPERMITID,PMRENEWALCASEID;' is invalid: message.key.columns has an invalid format (expecting '^(([^:]+):([^:;\s]+))+[^;]$') (io.debezium.connector.common.BaseSourceTask)
connect            | [2022-05-09 09:40:08,153] INFO WorkerSourceTask{id=star-custom-connector-v3-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask)
connect            | [2022-05-09 09:40:08,153] ERROR WorkerSourceTask{id=star-custom-connector-v3-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask)
connect            | org.apache.kafka.connect.errors.ConnectException: Error configuring an instance of OracleConnectorTask; check the logs for details
connect            |    at io.debezium.connector.common.BaseSourceTask.start(BaseSourceTask.java:96)
connect            |    at org.apache.kafka.connect.runtime.WorkerSourceTask.execute(WorkerSourceTask.java:225)
connect            |    at org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:182)
connect            |    at org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:231)
connect            |    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
connect            |    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
connect            |    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
connect            |    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
connect            |    at java.base/java.lang.Thread.run(Thread.java:829)

Do you see the same behaviour using the latest relesead Debezium version?

(Ideally, also verify with latest Alpha/Beta/CR version)

I'm using the 1.9.2.Final version

Do you have the connector logs, ideally from start till finish?

(You might be asked later to provide DEBUG/TRACE level log)

How to reproduce the issue using our tutorial deployment?

Feature request or enhancement

For feature requests or enhancements, provide this information, please:

Which use case/requirement will be addressed by the proposed feature?

Implementation ideas (optional)

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

~WRD0002.jpg
0.8 kB
2022/05/11 11:35 PM
connect.log
271 kB
2022/05/11 5:35 PM
connector_star-custom-connector-v4_config.json
15 kB
2022/05/11 5:37 PM

Activity

People

Assignee:: Unassigned

Reporter:: Thomas Cheung (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2022/05/09 5:54 PM

Updated:: 2022/05/12 4:59 AM

Resolved:: 2022/05/12 4:59 AM