org.pentaho.di.core.exception.KettleValueException: Javascript error: ReferenceError: "result" is not defined. (script#4) ```

Solutions on the web

GitHub comment 34#194014252

via GitHub by levyj

, 9 months ago

Javascript error: ReferenceError: "result" is not defined. (script#4) ```

INFO 06-12 14:00:28,703 - Get max AUDIT_IDs - Finished reading query, closing connection. INFO 06-12 14:00:28,705 - Get min AUDIT_IDs - Finished reading query, closing connection. INFO 06-12 14:00:28,705 - Get max AUDIT_IDs - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0) INFO 06-12 14:00:28,707 - Get min AUDIT_IDs - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0) INFO 06-12 14:00:28,708 - add_default_tracker_ID - Finished processing (I=0, O=0, R=1, W=1, U=0, E= 0) INFO 06-12 14:00:28,715 - add_default_tracker_ID 2 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0) INFO 06-12 14:00:28,869 - conv null to zero - Optimization level not specified. Using default of 9 . org.pentaho.di.core.exception.KettleValueException: Javascript error: ReferenceError: "MAX_AUDIT_ID" is not defined. (script#3) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.jav a:458) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.ja va:689) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:54) at java.lang.Thread.run(Thread.java:662) Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "MAX_AUDIT_ID" is not defined. (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.notFoundError(ScriptRuntime.java:3848) at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1781) at org.mozilla.javascript.gen.script_5._c_script_0(script:3) at org.mozilla.javascript.gen.script_5.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_5.call(script) at org.mozilla.javascript.gen.script_5.exec(script) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.jav a:377) ... 3 more ERROR 06-12 14:00:28,931 - conv null to zero - Unexpected error ERROR 06-12 14:00:28,932 - conv null to zero - org.pentaho.di.core.exception.KettleValueException: Javascript error: ReferenceError: "MAX_AUDIT_ID" is not defined. (script#3) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.jav a:458) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.ja va:689) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:54) at java.lang.Thread.run(Thread.java:662) Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "MAX_AUDIT_ID" is not defined. (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.notFoundError(ScriptRuntime.java:3848) at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1781) at org.mozilla.javascript.gen.script_5._c_script_0(script:3) at org.mozilla.javascript.gen.script_5.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_5.call(script) at org.mozilla.javascript.gen.script_5.exec(script) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.jav a:377) ... 3 more INFO 06-12 14:00:28,935 - conv null to zero - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) INFO 06-12 14:00:28,936 - PreAuditTransform - PreAuditTransform ERROR 06-12 14:00:28,935 - PreAuditTransform - Errors detected! ERROR 06-12 14:00:28,940 - PreAuditTransform - Errors detected! INFO 06-12 14:00:28,939 - PreAuditTransform - PreAuditTransform INFO 06-12 14:00:28,970 - Join Rows (cartesian product) - Finished processing (I=0, O=0, R=2, W=1, U=0, E=0) INFO 06-12 14:00:29,129 - AuditTransform - Finished job entry [PreAuditTransform.ktr] (result=[fals e]) INFO 06-12 14:00:29,131 - AuditTransform - Job execution finished 14:00:29,162 ERROR [ActionAdapterQuartzJob] ActionAdapterQuartzJob.ERROR_0004 - Action "com.pentaho. repository.audit.AuditJobAction" failed to run as a quartz job java.lang.RuntimeException: java.lang.RuntimeException: Error executing a pdi job 11 at com.pentaho.repository.audit.AuditJobAction.execute(AuditJobAction.java:62) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJ ob.java:147) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:145) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:136) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQ uartzJob.java:157) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartz Job.java:101) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546) Caused by: java.lang.RuntimeException: Error executing a pdi job 11 at com.pentaho.repository.audit.AuditJobAction.execute(AuditJobAction.java:59) ... 7 morevia Pentaho BI Platform Tracking by Ramaiz Mansoor, 10 months ago

Javascript error: ReferenceError: "MAX_AUDIT_ID" is not defined. (script#3)

Error Cannot call method "substring" of null in Script Values - PDI

via Stack Overflow by thiagofred

, 1 year ago

Javascript error: TypeError: Cannot call method "substring" of null (script#12)

Base transaction does a mapping to a sub-transaction. In a java script in the subtransaction is a boolean variable declared and exported as field. This field is returned to the calling transaction through mapping (output). In a java script in the calling transaction the value of the boolean is changed. You get the following error: 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unexpected error 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Javascript error: 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Javascript error: 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.mozilla.javascript.NativeBoolean cannot be cast to java.lang.Boolean 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:457) 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:688) 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: via Pentaho BI Platform Tracking by Thomas Bednarz, 1 year ago

Javascript error: Javascript error: org.mozilla.javascript.NativeBoolean cannot be cast to java.lang.Boolean

Base transaction does a mapping to a sub-transaction. In a java script in the subtransaction is a boolean variable declared and exported as field. This field is returned to the calling transaction through mapping (output). In a java script in the calling transaction the value of the boolean is changed. You get the following error: 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unexpected error 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Javascript error: 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Javascript error: 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.mozilla.javascript.NativeBoolean cannot be cast to java.lang.Boolean 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:457) 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:688) 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at java.lang.Thread.run(Thread.java:662) 2012/02/01 10:44:05 - Modified Java Script Value.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: via Pentaho BI Platform Tracking by Thomas Bednarz, 1 year ago

Javascript error: Javascript error: org.mozilla.javascript.NativeBoolean cannot be cast to java.lang.Boolean

I am using a sub-transformation to replace values if found in another table otherwise I am keeping the old value. This works fine, if I only use it once in a transformation. If I have to replace more than value, I am always getting errors. The following error is from the attached example: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Unexpected error : Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : org.pentaho.di.core.exception.KettleValueException: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Javascript error: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:409) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:640) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2677) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:703) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3557) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3535) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3620) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1652) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3._c0(script:4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.call(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.call(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.exec(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:332) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : ... 3 more via Pentaho BI Platform Tracking by Holger Hymmen, 1 year ago

Javascript error: ReferenceError: "SBID" is not defined. (script#4)

I have now worked for days to find a workaround for this, but it is getting absurd. I started out with a transformation that sends data from an input table to an output table and uses a sub-transformation once for different columns from the input table. Each column has a different name and the number of rows from the input table is as high, that the first instance of the sub-transformation is still running, when the second starts. I recorded the transformations etc. with http://forums.pentaho.org/showthread.php?t=68539. The error is: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Unexpected error : Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : org.pentaho.di.core.exception.KettleValueException: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Javascript error: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:409) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:640) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2677) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:703) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3557) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3535) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3620) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1652) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3._c0(script:4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.call(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.call(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.exec(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:332) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : ... 3 more Then I thought it would help to create a transformation for each substitution and have job coordinate them. So, the first takes the input table transforms the first row and writes to the final table. The later transformations work on the final table substitute the next row and update the final table. That produced no error, but looking at the data we found, that the later substitutions did not really do their own work, since they replaced the next rows value with the value from the first substitution, which is absolutely incorrect. It seems that the first sub-transformation is leaving data somewhere, which the later sub-transformations reuse. You can find the transformations in http://forums.pentaho.org/showthread.php?t=68694 . I am now trying the transformations with numerous substitutions with as many copies of the sub-transformation as there are replacements. Each copy has unique names for the columns. I am still running the transformations and we have not checked the data yet. Hopefully this works. If not it is time to look for a different product. I do not say this to be mean, but I need something working correctly if I am migrating data from a customer.via Pentaho BI Platform Tracking by Holger Hymmen, 1 year ago

Javascript error: ReferenceError: "SBID" is not defined. (script#4)

I have now worked for days to find a workaround for this, but it is getting absurd. I started out with a transformation that sends data from an input table to an output table and uses a sub-transformation once for different columns from the input table. Each column has a different name and the number of rows from the input table is as high, that the first instance of the sub-transformation is still running, when the second starts. I recorded the transformations etc. with http://forums.pentaho.org/showthread.php?t=68539. The error is: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Unexpected error : Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : org.pentaho.di.core.exception.KettleValueException: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Javascript error: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:409) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:640) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2677) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:703) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3557) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3535) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3620) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1652) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3._c0(script:4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.call(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.call(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.exec(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:332) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : ... 3 more Then I thought it would help to create a transformation for each substitution and have job coordinate them. So, the first takes the input table transforms the first row and writes to the final table. The later transformations work on the final table substitute the next row and update the final table. That produced no error, but looking at the data we found, that the later substitutions did not really do their own work, since they replaced the next rows value with the value from the first substitution, which is absolutely incorrect. It seems that the first sub-transformation is leaving data somewhere, which the later sub-transformations reuse. You can find the transformations in http://forums.pentaho.org/showthread.php?t=68694 . I am now trying the transformations with numerous substitutions with as many copies of the sub-transformation as there are replacements. Each copy has unique names for the columns. I am still running the transformations and we have not checked the data yet. Hopefully this works. If not it is time to look for a different product. I do not say this to be mean, but I need something working correctly if I am migrating data from a customer.via Pentaho BI Platform Tracking by Holger Hymmen, 10 months ago

1 from 2009/03/16 09:37:38) : ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) :

I am using a sub-transformation to replace values if found in another table otherwise I am keeping the old value. This works fine, if I only use it once in a transformation. If I have to replace more than value, I am always getting errors. The following error is from the attached example: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Unexpected error : Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : org.pentaho.di.core.exception.KettleValueException: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Javascript error: Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:409) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:640) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2677) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:703) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3557) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3535) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3620) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1652) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3._c0(script:4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.call(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.call(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.mozilla.javascript.gen.c3.exec(script) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:332) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) : ... 3 more via Pentaho BI Platform Tracking by Holger Hymmen, 10 months ago

1 from 2009/03/16 09:37:38) : ReferenceError: "SBID" is not defined. (script#4) Modified Java Script Value.0 - ERROR (version 3.1.3, build 1 from 2009/03/16 09:37:38) :

create generate rows in transformation with one text field. then modified java script value step and select the field setValue(var) from left tree. leave compatibiliy mode off (default) and click test script or run transformation: Unexpected error : org.pentaho.di.core.exception.KettleValueException: Javascript error: TypeError: Cannot find function setValue in object test value test value. (script#1) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:436) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:667) at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:731) Caused by: org.mozilla.javascript.EcmaError: TypeError: Cannot find function setValue in object test value test value. (script#1) at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3557) at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3535) at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3563) at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3582) at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:3646) at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis(ScriptRuntime.java:2186) at org.mozilla.javascript.gen.c3._c0(script:1) at org.mozilla.javascript.gen.c3.call(script) at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) at org.mozilla.javascript.gen.c3.call(script) at org.mozilla.javascript.gen.c3.exec(script) at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:355) 2010/05/28 11:09:59 - Modified Java Script Value.0 - ERROR (version 3.2.3, build 11502 from 2010-01-05 14.46.36 by tomcat) : ... 3 more via Pentaho BI Platform Tracking by Rutger Deterd Oude Weme, 1 year ago

Javascript error: TypeError: Cannot find function setValue in object test value test value. (script#1)

Stack trace

org.pentaho.di.core.exception.KettleValueException: Javascript error:
ReferenceError: "result" is not defined. (script#4)

```
	at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:458)
	at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:689)
	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
	at java.lang.Thread.run(Thread.java:722)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Unknown user

Once, 1 year ago