Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Possible to step through the steps?

  1. #1

    Default Possible to step through the steps?

    Hi,

    Is it possible to step through the steps in the transformation?

    In the debugging level, I see an exception and transformation as such on the preview doesnt return any rows. so hoping to step through the steps and see if the problem is really data related or in the transformation itself.

  2. #2
    DEinspanjer Guest

    Default

    Not really. All the steps run in parallel, so there isn't really anything in the code that will allow that. There are a few things you could try, but it might be easier to post information about the exception or something first because I don't think that any of the methods I can think of would be for the faint-hearted.

  3. #3

    Default

    DEinspanjer,

    I dont understand why the comment about faint -hearted etc.

    This is a straightforward question - how to step through the transformation. Even if it was parallel execution, it still has to go in serial order or atleast in pairs since the previous step and the following steps are connected. I may be wrong since I havent looked at the code. or May be there is a way to force serialize steps processing.

    Anyway, the exception I get is in the calculator, looked at line 132 in Calculator.java, did not quite understand the code logic. - as far as I can tell, the 2nd argument should be 1.0 and not ProductCategoryId as the formula says below...

    11/03 18:33:10 - ProductCategoryId = current seq value + 1.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Unexpected error :
    2008/11/03 18:33:10 - ProductCategoryId = current seq value + 1.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : org.pentaho.di.core.exception.KettleStepException:
    2008/11/03 18:33:10 - ProductCategoryId = current seq value + 1.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Unable to find the second argument field 'ProductCategoryId for calculation #1
    2008/11/03 18:33:10 - ProductCategoryId = current seq value + 1.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) :
    2008/11/03 18:33:10 - ProductCategoryId = current seq value + 1.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.trans.steps.calculator.Calculator.processRow(Calculator.java:132)
    2008/11/03 18:33:10 - ProductCategoryId = current seq value + 1.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
    2008/11/03 18:33:10 - ProductCategoryId = current seq value + 1.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.trans.steps.calculator.Calculator.run(Calculator.java:524)
    2008/11/03 18:33:10 - Local Ofbiz - Statement canceled!

    Quote Originally Posted by DEinspanjer View Post
    Not really. All the steps run in parallel, so there isn't really anything in the code that will allow that. There are a few things you could try, but it might be easier to post information about the exception or something first because I don't think that any of the methods I can think of would be for the faint-hearted.
    Last edited by ritesht; 11-04-2008 at 03:25 AM.

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Try to run validation on the transformation first. If that fails attach your transformation.

    The message "Unable to find the second argument field 'ProductCategoryId for calculation #1" kinda means you forgot to fill in something

    For the stepping through the steps... I usually set a breakpoint on the processing function of 1 step... so the steps in front run completely free, and you can step through that steps row processing... you can set breakpoint on multiple steps, but then it becomes tricky to follow processing in complex transformations.

    Regards,
    Sven
    Last edited by sboden; 11-04-2008 at 03:57 AM.

  5. #5
    Join Date
    Jul 2007
    Posts
    2,498

    Default

    Quote Originally Posted by ritesht View Post
    DEinspanjer,

    I dont understand why the comment about faint -hearted etc.

    This is a straightforward question
    And Daniel gave you a straightforward answer. If you want community help in this forum I suggest being a little more polite to the ones helping you, or you'll start complaining of lack of answers.

    My 2 cents
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

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.