file is not a valid field name

[HK-hub]

problem

I add a table 'FL_TRANSPORT_FEEDER' to the capture list, and then there will be a subsequent change event, I don't know if the data row sent the change, but it will be executed here

And why get the field with the name 'file' here? None of the other tables I add will have this problem

om.ververica.cdc.connectors.shaded.org.apache.kafka.connect.errors.DataException: file is not a valid field name
	at com.ververica.cdc.connectors.shaded.org.apache.kafka.connect.data.Struct.lookupField(Struct.java:254) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.shaded.org.apache.kafka.connect.data.Struct.getCheckType(Struct.java:261) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.shaded.org.apache.kafka.connect.data.Struct.getString(Struct.java:158) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.base.relational.JdbcSourceEventDispatcher$SchemaChangeEventReceiver.schemaChangeRecordValue(JdbcSourceEventDispatcher.java:193) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.base.relational.JdbcSourceEventDispatcher$SchemaChangeEventReceiver.schemaChangeEvent(JdbcSourceEventDispatcher.java:223) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:122) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.base.relational.JdbcSourceEventDispatcher.dispatchSchemaChangeEvent(JdbcSourceEventDispatcher.java:147) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.base.relational.JdbcSourceEventDispatcher.dispatchSchemaChangeEvent(JdbcSourceEventDispatcher.java:62) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.dispatchSchemaChangeEventAndGetTableForNewCapturedTable(AbstractLogMinerEventProcessor.java:1018) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.getTableForDataEvent(AbstractLogMinerEventProcessor.java:913) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleDataEvent(AbstractLogMinerEventProcessor.java:835) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:321) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:262) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:198) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:247) ~[flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.oracle.source.reader.fetch.OracleStreamFetchTask$RedoLogSplitReadTask.execute(OracleStreamFetchTask.java:134) [flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.oracle.source.reader.fetch.OracleStreamFetchTask.execute(OracleStreamFetchTask.java:72) [flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at com.ververica.cdc.connectors.base.source.reader.external.IncrementalSourceStreamFetcher.lambda$submitTask$0(IncrementalSourceStreamFetcher.java:89) [flink-sql-connector-oracle-cdc-2.4.2.jar:2.4.2]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_401]
	at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) ~[na:1.8.0_401]
	at java.util.concurrent.FutureTask.run(FutureTask.java) ~[na:1.8.0_401]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_401]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_401]
	at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_401]

[HK-hub]

the table FL_TRANSPORT_FEEDER DDL:
Database: Oracle 19c

create table FL_TRANSPORT_FEEDER
(
    FP_NO               VARCHAR2(5) not null,
    FP_NAME             VARCHAR2(200),
    STRT_POSITION       VARCHAR2(60),
    STRT_STACK_BIN      VARCHAR2(500),
    STRT_DEVICE         VARCHAR2(30),
    FIN_TYPE            VARCHAR2(1),
    FIN_POSITION        VARCHAR2(60),
    FIN_STACK_BIN       VARCHAR2(20),
    FIN_DEVICE          VARCHAR2(30),
    MAT_CODE            VARCHAR2(30),
    MAT_NAME            VARCHAR2(60),
    NET_WGT             NUMBER(15, 3),
    FP_BEGINTIME        DATE,
    FP_FINTIME          DATE,
    FP_ANOTHER_SEQ2     NUMBER    default "NGYARD"."SQ_FL_TRANSPORT_ID"."NEXTVAL", 
    CREATE_TIME         DATE      default sysdate,
    SEQ_ID              NUMBER      not null
        primary key,
    BIN_UPDATE_STATUS   NUMBER
)

Starting the FP_ANOTHER_SEQ2 field throws a warning:

OracleDefaultValueConverter : Cannot parse column default value '"NGYARD"."SQ_FL_TRANSPORT_ID". "NEXTVAL"' to type '2'.
Expression evaluation is not supported.

[yuxiqian]

Hi @HK-hub, this problem should have been fixed in #2315. Could you please try upgrading to 3.1.0 or newer versions?