Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error using sub-transformation twice in a flow

  1. #1

    Default Error using sub-transformation twice in a flow

    Hi,

    I am using a sub-transformation to replace values if found in another table.
    This works fine, if I only use it once in a transformation. If I use it twice or more I am always getting errors:
    Code:
    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
    Bye

    Holger
    Attached Files Attached Files
    Last edited by Hymmen; 03-18-2009 at 12:14 PM.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    We obviously can't tell from that transformation. You rename your field to SBID_ALT, that's all I can say.

    Try to set up a use-case and file a bug report.
    That JavaScript error seems eerily familiar though. Mmm.

  3. #3

    Default

    Sorry, I have now added the missing sub-transformation. I also opened a bug report. http://jira.pentaho.com/browse/PDI-2203
    Last edited by Hymmen; 03-18-2009 at 12:47 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.