1.问题描述
在用Kettle做job的时候,报如下的错
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - Error looking up row in database
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - ORA-00942: 表或视图不存在
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 -
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:3127)
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:3103)
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:3099)
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:89)
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299)
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - at java.lang.Thread.run(Unknown Source)
2019/11/18 14:28:42 - OUT FICP_PARAM_DATA 2.0 - Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
说表或视图不存在不存在,数据库里面我创建了呀,咋报这个错呢?
2.解决方案
经过了一番的排查,找到了原因,如下,
红色部分,多了一个空格,删掉就行了,因为是直接双击,复制步骤名称的表名的,可能默认多了空格,无语。。。。。