一、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为空的判断