1
resposta

Problema na Gravação da Dimensão Tempo

Olá,

Alguém pode me auxiliar? Estou com esse problema no momento da carga para a dim_data (tempo), já tentei e refiz as aulas mas não conaegui resolver.

2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Error in step, asking everyone to stop because of: 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.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.KettleDatabaseException: 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - Error inserting/updating row 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"Data", Numero_dia_semana, Numero_Mes, Numero_Ano, Nome_Mes, Numero_Trimestre, N' at line 1 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1319) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1243) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1231) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1219) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:114) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at java.lang.Thread.run(Unknown Source) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"Data", Numero_dia_semana, Numero_Mes, Numero_Ano, Nome_Mes, Numero_Trimestre, N' at line 1 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1348) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1286) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - ... 7 more 2021/07/08 09:21:23 - Exclui Colunas.0 - Finished processing (I=0, O=0, R=3900, W=3900, U=0, E=0) 2021/07/08 09:21:23 - Acha o nome do Mes.0 - Finished processing (I=0, O=0, R=4012, W=4000, U=0, E=0) 2021/07/08 09:21:23 - Gravacao da Dimensao Tempo.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=1) 2021/07/08 09:21:23 - DimensaoTempo - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Errors detected! 2021/07/08 09:21:23 - Spoon - The transformation has finished!! 2021/07/08 09:21:23 - DimensaoTempo - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Errors detected! 2021/07/08 09:21:23 - DimensaoTempo - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Errors detected! 2021/07/08 09:21:23 - DimensaoTempo - Transformation detected one or more steps with errors. 2021/07/08 09:21:23 - DimensaoTempo - Transformation is killing the other steps!

1 resposta

Oii Mikhail, tudo bom?

O erro é esse: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"Data", Numero_dia_semana, Numero_Mes, Numero_Ano, Nome_Mes, Numero_Trimestre, N' at line 1

Isso quer dizer que é um erro de sintaxe do SQL. Você poderia compartilhar o código SQL utilizado, por gentileza?

Fico aguardando :)