Estou enfrentando um erro no processo de popular a tabela fato_001, segui os passos do aula fazendo um Table Input com dados do SQL Server, e dando um Inser/Update no MySQL. Ao executar o processo recebo a seguinte mensagem de erro.
2021/06/14 11:58:00 - Insert / update.0 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Error in step, asking everyone to stop because of:
2021/06/14 11:58:00 - Insert / update.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/06/14 11:58:00 - Insert / update.0 - Error inserting/updating row
2021/06/14 11:58:00 - Insert / update.0 - Cannot add or update a child row: a foreign key constraint fails (`dwsucos`.`fato_001`, CONSTRAINT `dim_produto_fato_001_fk` FOREIGN KEY (`Cod_Produto`) REFERENCES `dim_produto` (`Cod_Produto`) ON DELETE NO ACTION ON UPDATE NO ACTION)
2021/06/14 11:58:00 - Insert / update.0 -
2021/06/14 11:58:00 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1331)
2021/06/14 11:58:00 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1255)
2021/06/14 11:58:00 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1243)
2021/06/14 11:58:00 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1231)
2021/06/14 11:58:00 - Insert / update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:114)
2021/06/14 11:58:00 - Insert / update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299)
2021/06/14 11:58:00 - Insert / update.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2021/06/14 11:58:00 - Insert / update.0 - at java.lang.Thread.run(Unknown Source)
2021/06/14 11:58:00 - Insert / update.0 - Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`dwsucos`.`fato_001`, CONSTRAINT `dim_produto_fato_001_fk` FOREIGN KEY (`Cod_Produto`) REFERENCES `dim_produto` (`Cod_Produto`) ON DELETE NO ACTION ON UPDATE NO ACTION)
2021/06/14 11:58:00 - Insert / update.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
2021/06/14 11:58:00 - Insert / update.0 - at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
2021/06/14 11:58:00 - Insert / update.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
2021/06/14 11:58:00 - Insert / update.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
2021/06/14 11:58:00 - Insert / update.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040)
2021/06/14 11:58:00 - Insert / update.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347)
2021/06/14 11:58:00 - Insert / update.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025)
2021/06/14 11:58:00 - Insert / update.0 - at org.pentaho.di.core.database.Database.insertRow(Database.java:1298)Alguém consegue me ajudar?
