使用数据同步组件,把源数据库的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
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