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

Failed to properly convert data value for type NUMBER

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 1.7.2.Final
    • None
    • None
    • False
    • None
    • False
    • Hide

      1. run a debezium task, this task monitors table.include.list: tablea,tableb,tablec. this task would be running fine.
      2. when the above task is running well, add another table test_001 into it.
      3. update the table test_001 , and the exception occurs.

      create table test_001(id varchar2(32), status integer, state number);
insert into test_001 values ('1234', 3330,3333);
update test_001 set state = 6666 where id = '1234';
      Show
      1. run a debezium task, this task monitors table.include.list: tablea,tableb,tablec. this task would be running fine. 2. when the above task is running well, add another table test_001 into it. 3. update the table test_001 , and the exception occurs. create table test_001(id varchar2 (32), status integer , state number ); insert into test_001 values ( '1234' , 3330,3333); update test_001 set state = 6666 where id = '1234' ; 

      [2022-04-20 10:12:30,407] ERROR Failed to properly convert data value for 'ORCL.TESTTABLE.COL.XH' of type NUMBER for row [060220221002002013, 3269, null, null, null, null, null, null, null, 0, 436186, 0, null, null, TO_DATE('2022-04-20 10:07:10', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null, null, null, null, null, 09_ZX0019-1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, 0, null, null, null, null, null, null, null, null, null, null, 0, 09_05080-5, null, null, null, null, null, null, 0, null, 0, 0, null, null, null, null, null, null, null, null, null, null, null, 5cf7b9eddb454feabeebb4f48205a023, null, null, null, null, 2, 0, 0, 0, null, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: (io.debezium.relational.TableSchemaBuilder:269)
java.lang.NumberFormatException: Value out of range. Value:"3269" Radix:10
	at java.lang.Byte.parseByte(Byte.java:151)
	at java.lang.Byte.parseByte(Byte.java:175)
	at io.debezium.connector.oracle.OracleValueConverters.lambda$convertTinyInt$14(OracleValueConverters.java:529)
	at io.debezium.jdbc.JdbcValueConverters.convertValue(JdbcValueConverters.java:1297)
	at io.debezium.connector.oracle.OracleValueConverters.convertTinyInt(OracleValueConverters.java:517)
	at io.debezium.connector.oracle.OracleValueConverters.convertNumericAsTinyInt(OracleValueConverters.java:445)
	at io.debezium.connector.oracle.OracleValueConverters.lambda$getNumericConverter$8(OracleValueConverters.java:237)
	at io.debezium.relational.TableSchemaBuilder.lambda$createValueGenerator$5(TableSchemaBuilder.java:264)
	at io.debezium.relational.TableSchema.valueFromColumnData(TableSchema.java:141)
	at io.debezium.relational.RelationalChangeRecordEmitter.emitUpdateRecord(RelationalChangeRecordEmitter.java:101)
	at io.debezium.relational.RelationalChangeRecordEmitter.emitChangeRecords(RelationalChangeRecordEmitter.java:52)
	at io.debezium.pipeline.EventDispatcher.dispatchDataChangeEvent(EventDispatcher.java:218)
	at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor$1.accept(MemoryLogMinerEventProcessor.java:278)
	at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor$1.accept(MemoryLogMinerEventProcessor.java:258)
	at io.debezium.connector.oracle.logminer.processor.TransactionCommitConsumer.dispatchChangeEvent(TransactionCommitConsumer.java:144)
	at io.debezium.connector.oracle.logminer.processor.TransactionCommitConsumer.accept(TransactionCommitConsumer.java:133)
	at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.handleCommit(MemoryLogMinerEventProcessor.java:299)
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:200)
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:178)
	at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.process(MemoryLogMinerEventProcessor.java:134)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:173)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      1.7.2.Final & oracle 11g

              Unassigned Unassigned
              jian.zhu.86 jian zhu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: