René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Field [starttime Date] does not have the same data type as field [starttime String(10)].","articleBody":"When running `kitchen.sh -file=incremental.kjb` I get an error on one of my tables. Running kettle with `migration.kjb` works without an error.\r\n\r\nFull error output:\r\n```\r\n2022/11/15 09:55:48 - Migration - Starting entry [Meter_TariffTime]\r\n2022/11/15 09:55:48 - Meter_TariffTime - Running transformation using the Kettle execution engine\r\n2022/11/15 09:55:48 - migration[Meter].[TariffTime] - Dispatching started for transformation [migration[Meter].[TariffTime]]\r\n2022/11/15 09:55:49 - Table input 2.0 - Finished reading query, closing connection.\r\n2022/11/15 09:55:49 - Table input.0 - Finished reading query, closing connection.\r\n2022/11/15 09:55:49 - User Defined Java Class.5 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - User Defined Java Class.3 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - User Defined Java Class.4 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - User Defined Java Class.1 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - User Defined Java Class.0 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - User Defined Java Class.6 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - User Defined Java Class.2 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - User Defined Java Class.7 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows.1 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows.7 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows.2 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows 2.1 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows.4 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows 2.7 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows 2.4 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows 2.5 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows 2.6 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows 2.0 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows.6 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows.0 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows 2.3 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows 2.2 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Sort rows.5 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - Table input.0 - Finished processing (I=624, O=0, R=0, W=624, U=0, E=0)\r\norg.pentaho.di.core.exception.KettleException: \r\nInvalid 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\r\n\r\nThe data type of field #4 is not the same as the first row received: you're mixing rows with different layout. Field [starttime Date] does not have the same data type as field [starttime String(10)].\r\n\r\n\r\n\tat org.pentaho.di.trans.steps.mergerows.MergeRows.processRow(MergeRows.java:101)\r\n\tat org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)\r\n\tat java.lang.Thread.run(Thread.java:750)\r\nCaused by: org.pentaho.di.core.exception.KettleRowException: \r\nThe data type of field #4 is not the same as the first row received: you're mixing rows with different layout. Field [starttime Date] does not have the same data type as field [starttime String(10)].\r\n\r\n\tat org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:2190)2022/11/15 09:55:49 - Table input 2.0 - Finished processing (I=624, O=0, R=0, W=624, U=0, E=0)\r\n\r\n\tat org.pentaho.di.trans.steps.mergerows.MergeRows.checkInputLayoutValid(MergeRows.java:265)\r\n\tat org.pentaho.di.trans.steps.mergerows.MergeRows.processRow(MergeRows.java:99)\r\n\t... 2 more\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Unexpected error\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : org.pentaho.di.core.exception.KettleException: \r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - 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\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - The data type of field #4 is not the same as the first row received: you're mixing rows with different layout. Field [starttime Date] does not have the same data type as field [starttime String(10)].\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \tat org.pentaho.di.trans.steps.mergerows.MergeRows.processRow(MergeRows.java:101)\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \tat org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \tat java.lang.Thread.run(Thread.java:750)\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - Caused by: org.pentaho.di.core.exception.KettleRowException: \r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - The data type of field #4 is not the same as the first row received: you're mixing rows with different layout. Field [starttime Date] does not have the same data type as field [starttime String(10)].\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \tat org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:2190)\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \tat org.pentaho.di.trans.steps.mergerows.MergeRows.checkInputLayoutValid(MergeRows.java:265)\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \tat org.pentaho.di.trans.steps.mergerows.MergeRows.processRow(MergeRows.java:99)\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - \t... 2 more\r\n2022/11/15 09:55:49 - Sort rows.3 - Finished processing (I=0, O=0, R=78, W=78, U=0, E=0)\r\n2022/11/15 09:55:49 - migration[Meter].[TariffTime] - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Errors detected!\r\n2022/11/15 09:55:49 - Merge Rows (diff).0 - Finished processing (I=0, O=0, R=2, W=0, U=0, E=1)\r\n2022/11/15 09:55:49 - migration[Meter].[TariffTime] - Transformation detected one or more steps with errors.\r\n2022/11/15 09:55:49 - migration[Meter].[TariffTime] - Transformation is killing the other steps!\r\n2022/11/15 09:55:49 - Sorted Merge 2.0 - Finished processing (I=0, O=0, R=210, W=202, U=0, E=0)\r\n2022/11/15 09:55:49 - Sorted Merge.0 - Finished processing (I=0, O=0, R=210, W=202, U=0, E=0)\r\n2022/11/15 09:55:49 - migration[Meter].[TariffTime] - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Errors detected!\r\n2022/11/15 09:55:49 - Migration - Finished job entry [Meter_TariffTime] (result=[false])\r\n```\r\n\r\nMeter.TariffTime schema in SQL Server:\r\n```\r\ncreate table Meter.TariffTime\r\n(\r\n    ID           int identity\r\n        constraint PK_TariffTime\r\n            primary key,\r\n    TariffDayID  int     not null,\r\n    TariffID     int     not null,\r\n    StartTime    time(1) not null,\r\n    EndTime      time(1) not null,\r\n    TariffRateID int     not null\r\n)\r\ngo\r\n```\r\n\r\ntables-before.sql:\r\n```\r\nCREATE TABLE \"meter\".\"tarifftime\"( \r\n\t\"id\" int NOT NULL,\r\n\t\"tariffdayid\" int NOT NULL,\r\n\t\"tariffid\" int NOT NULL,\r\n\t\"starttime\" time(1) NOT NULL,\r\n\t\"endtime\" time(1) NOT NULL,\r\n\t\"tariffrateid\" int NOT NULL);\r\n```\r\n\r\nPostgreSQL:\r\n```\r\ncreate table meter.tarifftime\r\n(\r\n    id           integer not null,\r\n    tariffdayid  integer not null,\r\n    tariffid     integer not null,\r\n    starttime    time(1) not null,\r\n    endtime      time(1) not null,\r\n    tariffrateid integer not null\r\n);\r\n\r\nalter table meter.tarifftime\r\n    owner to postgres;\r\n```","author":{"url":"https://github.com/jpmeijers","@type":"Person","name":"jpmeijers"},"datePublished":"2022-11-15T11:39:46.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/169/sqlserver2pgsql/issues/169"}