一、kettle程序报错如下
2021/03/05 10:17:58 - 设备通道最后上报时间更新.0 - Finished processing (I=0, O=0, R=17253, W=17253, U=0, E=0)
2021/03/05 10:17:58 - 记录集连接 3.0 - Finished processing (I=0, O=0, R=38614, W=50469, U=0, E=0)
2021/03/05 10:17:58 - 字段选择11 2 2 2 2.0 - Finished processing (I=0, O=0, R=50469, W=50469, U=0, E=0)
2021/03/05 10:17:58 - JavaScript代码.0 - Optimization level set to 9.
org.pentaho.di.core.exception.KettleValueException:
Javascript error:
TypeError: Cannot call method "trim" of null (script#3)
at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:475)
at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:541)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.mozilla.javascript.EcmaError: TypeError: Cannot call method "trim" of null (script#3)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3785)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3763)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3791)
at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3810)
at org.mozilla.javascript.ScriptRuntime.undefCallError(ScriptRuntime.java:3829)
at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThisHelper(ScriptRuntime.java:2334)
at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis(ScriptRuntime.java:2327)
at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:117)
at org.mozilla.javascript.gen.script_3._c_script_0(script:3)
at org.mozilla.javascript.gen.script_3.call(script)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:426)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3178)
at org.mozilla.javascript.gen.script_3.call(script)
at org.mozilla.javascript.gen.script_3.exec(script)
at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:388)
... 3 more
2021/03/05 10:17:58 - JavaScript代码.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unexpected error
2021/03/05 10:17:58 - 排序记录 2 2 3.0 - Finished processing (I=0, O=0, R=50469, W=50469, U=0, E=0)
2021/03/05 10:17:58 - JavaScript代码.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.pentaho.di.core.exception.KettleValueException:
2021/03/05 10:17:58 - JavaScript代码.0 - Javascript error:
2021/03/05 10:17:58 - JavaScript代码.0 - TypeError: Cannot call method "trim" of null (script#3)
2021/03/05 10:17:58 - JavaScript代码.0 -
二、解决
原来是kettle 程序IP没有 判断 null
加了 IP为空的判断
