kettle吧 关注:826贴子:2,272
  • 8回复贴,共1

请教一下kettle的数据同步组件问题

只看楼主收藏回复

使用数据同步组件,把源数据库的oracle表同步到mysql中,首次同步成功,第二次同步就提示报错了,提示字段的类型不一致,请教如何解决呢?
2020/04/14 09:37:10 - 合并记录.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Unexpected error
2020/04/14 09:37:10 - 合并记录.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleException:
2020/04/14 09:37:10 - 合并记录.0 - 不正确的数据格式,不同数据流中要合并的字段的结构和位置都应该相同.
2020/04/14 09:37:10 - 合并记录.0 -
2020/04/14 09:37:10 - 合并记录.0 - The data storage of field #1 is not the same as the first row received: you're mixing rows with different storage types. Field [ID String<binary-string>] does not have the same storage type as field [ID String(64)].
2020/04/14 09:37:10 - 合并记录.0 -
2020/04/14 09:37:10 - 合并记录.0 -
2020/04/14 09:37:10 - 合并记录.0 - at org.pentaho.di.trans.steps.mergerows.MergeRows.processRow(MergeRows.java:101)
2020/04/14 09:37:10 - 合并记录.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2020/04/14 09:37:10 - 合并记录.0 - at java.lang.Thread.run(Unknown Source)
2020/04/14 09:37:10 - 合并记录.0 - Caused by: org.pentaho.di.core.exception.KettleRowException:
2020/04/14 09:37:10 - 合并记录.0 - The data storage of field #1 is not the same as the first row received: you're mixing rows with different storage types. Field [ID String<binary-string>] does not have the same storage type as field [ID String(64)].
2020/04/14 09:37:10 - 合并记录.0 -
2020/04/14 09:37:10 - 合并记录.0 - at org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:2196)
2020/04/14 09:37:10 - 合并记录.0 - at org.pentaho.di.trans.steps.mergerows.MergeRows.checkInputLayoutValid(MergeRows.java:265)
2020/04/14 09:37:10 - 合并记录.0 - at org.pentaho.di.trans.steps.mergerows.MergeRows.processRow(MergeRows.java:99)
2020/04/14 09:37:10 - 合并记录.0 - ... 2 more
2020/04/14 09:37:10 - 合并记录.0 - child index = 2, logging object : org.pentaho.di.core.logging.LoggingObject@2f6a0cb1 parent=3df45227-57f5-4081-8331-b5a41628fa38
2020/04/14 09:37:10 - 目标.0 - Stopped while putting a row on the buffer


IP属地:广东1楼2020-04-14 10:53回复
    不正确的数据格式,不同数据流中要合并的字段的结构和位置都应该相同.;
    合并的两张表字段位置不同;要相同字段才能合并


    IP属地:福建2楼2020-04-24 15:57
    回复
      2025-06-10 19:42:34
      广告
      我为什么用这个数据同步组件,没报错,数据也没更新


      IP属地:浙江来自Android客户端3楼2020-09-05 18:22
      收起回复
        遇到同样的问题,请问解决了吗?


        4楼2022-07-19 16:17
        回复
          [ID String<binary-string>] 和 [ID String(64)]不一致,在对应的输入步骤后添加【选择字段】进行调整


          IP属地:浙江6楼2023-12-21 16:16
          回复
            同步前清空目标表,执行就可以了


            IP属地:广东7楼2024-06-13 17:33
            收起回复