数据库连接是没有问题的,如下报错
2023/08/04 17:01:55 - 表输出.0 - Connected to database [172.100.125.12] (commit=500)
2023/08/04 17:02:18 - 表输出.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Because of an error, this step can't continue:
2023/08/04 17:02:18 - 表输出.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : org.pentaho.di.core.exception.KettleException:
2023/08/04 17:02:18 - 表输出.0 - Error batch inserting rows into table [crucinfo].
2023/08/04 17:02:18 - 表输出.0 - Errors encountered (first 10):
2023/08/04 17:02:18 - 表输出.0 -
2023/08/04 17:02:18 - 表输出.0 -
2023/08/04 17:02:18 - 表输出.0 - Error updating batch
2023/08/04 17:02:18 - 表输出.0 - INSERT command denied to user 'mes'@'172.18.2.202' for table 'crucinfo'
2023/08/04 17:02:18 - 表输出.0 -
2023/08/04 17:02:18 - 表输出.0 -
2023/08/04 17:02:18 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:348)
2023/08/04 17:02:18 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:125)
2023/08/04 17:02:18 - 表输出.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2023/08/04 17:02:18 - 表输出.0 - at java.base/java.lang.Thread.run(Thread.java:833)
2023/08/04 17:02:18 - 表输出.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException:
2023/08/04 17:02:18 - 表输出.0 - Error updating batch
2023/08/04 17:02:18 - 表输出.0 - INSERT command denied to user 'mes'@'172.18.2.202' for table 'crucinfo'
2023/08/04 17:02:18 - 表输出.0 -
2023/08/04 17:02:18 - 表输出.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1440)
2023/08/04 17:02:18 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:295)
2023/08/04 17:02:18 - 表输出.0 - ... 3 more
2023/08/04 17:02:18 - 表输出.0 - Caused by: java.sql.BatchUpdateException: INSERT command denied to user 'mes'@'172.18.2.202' for table 'crucinfo'
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:816)
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:418)
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:795)
2023/08/04 17:02:18 - 表输出.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:291)
2023/08/04 17:02:18 - 表输出.0 - ... 3 more
2023/08/04 17:02:18 - 表输出.0 - Caused by: java.sql.SQLSyntaxErrorException: INSERT command denied to user 'mes'@'172.18.2.202' for table 'crucinfo'
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
2023/08/04 17:02:18 - 表输出.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:795)
2023/08/04 17:02:18 - 表输出.0 - ... 6 more
2023/08/04 17:02:19 - 表输出.0 - 完成处理 (I=0, O=499, R=500, W=0, U=0, E=1)
2023/08/04 17:02:19 - H - 转换被检测
2023/08/04 17:02:19 - H - 转换正在杀死其他步骤!
2023/08/04 17:02:20 - 表输入.0 - Finished reading query, closing connection
2023/08/04 17:02:32 - 表输入.0 - 完成处理 (I=3594, O=0, R=0, W=3592, U=0, E=0)
2023/08/04 17:02:32 - H - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : 错误被检测到!
2023/08/04 17:02:32 - Spoon - 转换完成!!
2023/08/04 17:02:32 - H - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : 错误被检测到!
2023/08/04 17:02:32 - H - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : 错误被检测到!