Solucionado (ver solução)
Solucionado
(ver solução)
1
resposta

Erro na Execução do Job Fato

Boa noite, na execução da JobFatosParalelo estou tomando o seguinte erro:

2022/03/22 21:32:45 - Leitura Tabela Fato 001 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : !TableInput.Log.ErrorOccurred!
2022/03/22 21:32:45 - Leitura Tabela Fato 002 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : !TableInput.Log.ErrorOccurred!
2022/03/22 21:32:45 - Leitura Tabela Fato 001 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Error initializing step [Leitura Tabela Fato 001 (SQL Server)]
2022/03/22 21:32:45 - Leitura Tabela Fato 002 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Error initializing step [Leitura Tabela Fato 002 (SQL Server)]
2022/03/22 21:32:45 - Leitura Tabela Fato 005 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : !TableInput.Log.ErrorOccurred!
2022/03/22 21:32:45 - Leitura Tabela Fato 004 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : !TableInput.Log.ErrorOccurred!
2022/03/22 21:32:45 - Leitura Tabela Fato 005 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Error initializing step [Leitura Tabela Fato 005 (SQL Server)]
2022/03/22 21:32:45 - Leitura Tabela Fato 004 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Error initializing step [Leitura Tabela Fato 004 (SQL Server)]
2022/03/22 21:32:45 - Leitura Tabela Fato 003 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : !TableInput.Log.ErrorOccurred!
2022/03/22 21:32:45 - Leitura Tabela Fato 003 (SQL Server).0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Error initializing step [Leitura Tabela Fato 003 (SQL Server)]
2022/03/22 21:32:45 - Fato - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Step [Leitura Tabela Fato 001 (SQL Server).0] failed to initialize!
2022/03/22 21:32:45 - Fato - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Step [Leitura Tabela Fato 002 (SQL Server).0] failed to initialize!
2022/03/22 21:32:45 - Fato - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Step [Leitura Tabela Fato 003 (SQL Server).0] failed to initialize!
2022/03/22 21:32:45 - Fato - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Step [Leitura Tabela Fato 004 (SQL Server).0] failed to initialize!
2022/03/22 21:32:45 - Fato - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Step [Leitura Tabela Fato 005 (SQL Server).0] failed to initialize!
2022/03/22 21:32:45 - Leitura Tabela Fato 001 (SQL Server).0 - !TableInput.Log.FinishedReadingQuery!
2022/03/22 21:32:45 - Leitura Tabela Fato 002 (SQL Server).0 - !TableInput.Log.FinishedReadingQuery!
2022/03/22 21:32:45 - Leitura Tabela Fato 003 (SQL Server).0 - !TableInput.Log.FinishedReadingQuery!
2022/03/22 21:32:45 - Leitura Tabela Fato 004 (SQL Server).0 - !TableInput.Log.FinishedReadingQuery!
2022/03/22 21:32:45 - Leitura Tabela Fato 005 (SQL Server).0 - !TableInput.Log.FinishedReadingQuery!
2022/03/22 21:32:45 - Carga Fato - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Unable to prepare for execution of the transformation
2022/03/22 21:32:45 - Carga Fato - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : org.pentaho.di.core.exception.KettleException: 
2022/03/22 21:32:45 - Carga Fato - We failed to initialize at least one step.  Execution can not begin!

Se tento executar a transformação Fato, dá na mesma, mesmo preenchendo corretamente as variáveis. Prints: https://imgur.com/a/6XPOITS Na outra aula, na qual montamos a transformação Fato, não tive problemas na execução. O que pode ser isso? Obrigada.

1 resposta
solução!

Consegui resolver, o problema estava na conexão com o Banco de Dados. Bastou alterar no arquivo jdbc.properties de

databaseName=fontes_db?useTimezone=true&serverTimezone=UTC

para:

databaseName=fontes_db

Quer mergulhar em tecnologia e aprendizagem?

Receba a newsletter que o nosso CEO escreve pessoalmente, com insights do mercado de trabalho, ciência e desenvolvimento de software