This question was originally posted on DCIM Support by DataCenterServices on 2019-01-28
After upgrading to 8.2.7 my ETL export database is no longer functioning.
The initial ETL export was successful. The error only appears when merging/updating data. The below is the error received:
2019-01-28 10:00:02,769 ERROR [0CGZi4oBRhy0fy8dpYeBAQ] [datacenterservices] [org.pentaho.di] (swoAsset_v2.0.0 - Merge) Merge - Unexpected error
2019-01-28 10:00:02,769 ERROR [0CGZi4oBRhy0fy8dpYeBAQ] [datacenterservices] [org.pentaho.di] (swoAsset_v2.0.0 - Merge) Merge - org.pentaho.di.core.exception.KettleException:
Invalid layout detected in input streams, keys and values to merge have to be of identical structure and be in the same place in the rows
The data type of field #16 is not the same as the first row received: you're mixing rows with different layout. Field [ci_max_power_draw Number(15)] does not have the same data type as field [ci_max_power_draw BigNumber(17, 17)].
at org.pentaho.di.trans.steps.mergerows.MergeRows.processRow(MergeRows.java:92)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.pentaho.di.core.exception.KettleRowException:
The data type of field #16 is not the same as the first row received: you're mixing rows with different layout. Field [ci_max_power_draw Number(15)] does not have the same data type as field [ci_max_power_draw BigNumber(17, 17)].
at org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:1861)
at org.pentaho.di.trans.steps.mergerows.MergeRows.checkInputLayoutValid(MergeRows.java:265)
at org.pentaho.di.trans.steps.mergerows.MergeRows.processRow(MergeRows.java:88)
... 2 more
2019-01-28 10:00:02,769 INFO [0CGZi4oBRhy0fy8dpYeBAQ] [datacenterservices] [org.pentaho.di] (swoAsset_v2.0.0 - Merge) Merge - Finished processing (I=0, O=0, R=2, W=0, U=0, E=1)
2019-01-28 10:00:02,769 INFO [0CGZi4oBRhy0fy8dpYeBAQ] [datacenterservices] [org.pentaho.di] (swoAsset_v2.0.0 - Merge) swoAsset_v2.0.0 - swoAsset_v2.0.0
2019-01-28 10:00:02,769 INFO [0CGZi4oBRhy0fy8dpYeBAQ] [datacenterservices] [org.pentaho.di] (swoAsset_v2.0.0 - Merge) swoAsset_v2.0.0 - swoAsset_v2.0.0
2019-01-28 10:00:02,769 ERROR [0CGZi4oBRhy0fy8dpYeBAQ] [datacenterservices] [org.pentaho.di] (QuartzSharedThreadPool-1 M/Mur0csSGqQjTGc1EWLlw) swoAsset_v2.0.0 - Errors detected!
2019-01-28 10:00:02,770 ERROR [0CGZi4oBRhy0fy8dpYeBAQ] [datacenterservices] [org.pentaho.di] (QuartzSharedThreadPool-1 M/Mur0csSGqQjTGc1EWLlw) swoAsset_v2.0.0 - Errors detected!
DCO updated from 8.0.2 to 8.2.7.
Database Driver: net.sourceforge.jtds.jdbc.Driver
Dialect: org.hibernate.dialect.PostgreSQL94Dialect / SQLServerUnicodeDialect
DB Destination: MS SQL Server 2017
(CID:138810569)
