Boas..
O tópico anterior indicava trocar o mysql-connector-java-8.0.22.. Eu estava usando o 23, tentei o 22 e agora tentei novamente com o 24... Nada resolve isso:
Spoon - Running transformation using the Kettle execution engine
2021/04/29 09:29:17 - Spoon - Transformation opened.
2021/04/29 09:29:17 - Spoon - Launching transformation [DimensoesDataMart]...
2021/04/29 09:29:17 - Spoon - Started the transformation execution.
2021/04/29 09:29:17 - Spoon - The transformation has finished!!
2021/04/29 09:29:23 - Spoon - The transformation has finished!!
2021/04/29 09:29:53 - Spoon - The transformation has finished!!
2021/04/29 09:30:56 - /DimensoesDataMart - Dispatching started for transformation [/DimensoesDataMart]
2021/04/29 09:30:56 - Dimensão Tempo DW.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
2021/04/29 09:30:56 - Dimensão Tempo DW.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.KettleDatabaseException:
2021/04/29 09:30:56 - Dimensão Tempo DW.0 - Couldn't get row from result set
2021/04/29 09:30:56 - Dimensão Tempo DW.0 -
2021/04/29 09:30:56 - Dimensão Tempo DW.0 - Unable to get value 'Date' from database resultset, index 1
2021/04/29 09:30:56 - Dimensão Tempo DW.0 - HOUR_OF_DAY: 0 -> 1
Será que seria problema de conexão ? parece que não testá conseguindo pegar o valor do campo tipo data do DW