Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: Unknown column 'ID_STEP_ATTRIBUTE. v3.0.1

  1. #1
    Join Date
    Jan 2008
    Posts
    3

    Default Unknown column 'ID_STEP_ATTRIBUTE. v3.0.1

    Hello,

    I get an error when opening a transformation. In version Kettle 3.0.1 (frensch version).

    This is the error message:
    PDI a rencontré une erreur durant la lecture d'une transformation depuis le référentiel
    Unknown column 'ID_STEP_ATTRIBUTE'


    the detail is :
    org.pentaho.di.core.exception.KettleException:
    PDI a rencontré une erreur durant la lecture d'une transformation depuis le référentiel
    Unknown column 'ID_STEP_ATTRIBUTE'

    at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2418)
    at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2229)
    at org.pentaho.di.ui.spoon.job.JobGraph.openTransformation(JobGraph.java:1587)
    at org.pentaho.di.ui.spoon.job.JobGraph.openTransformation(JobGraph.java:1057)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:42)
    at org.pentaho.xul.swt.menu.PopupMenu.handleMenuEvent(PopupMenu.java:40)
    at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77)
    at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:841)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5589)
    at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5685)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:371)
    Caused by: org.pentaho.di.core.exception.KettleValueException:
    Unknown column 'ID_STEP_ATTRIBUTE'
    at org.pentaho.di.core.RowMetaAndData.getInteger(RowMetaAndData.java:147)
    at org.pentaho.di.repository.Repository.findStepAttributeID(Repository.java:3262)
    at org.pentaho.di.trans.steps.calculator.CalculatorMetaFunction.<init>(CalculatorMetaFunction.java:295)
    at org.pentaho.di.trans.steps.calculator.CalculatorMeta.readRep(CalculatorMeta.java:136)
    at org.pentaho.di.trans.step.StepMeta.<init>(StepMeta.java:626)
    at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2326)
    ... 19 more

    I make an update of the referentiel but the probleme is stay.
    I look after the ID_STEP_ATTRIBUTE in R_STEP_ATTRIBUTE an find the culum.

    I just find a similar problem post by sboden on 12-15-2007 06:39 PM. (Unknown column 'ID_STEP_ATTRIBUTE'). It seems to be a default from the step 'calculator'.


    Can someone help me.
    Thanks
    Last edited by Wilfried; 01-04-2008 at 07:19 AM.

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

    Default

    It's fixed (will be fixed) in 3.0.2/3.1... if you're feeling adventurous you can build from SVN.

    Regards,
    Sven

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

  4. #4
    Join Date
    Jan 2008
    Posts
    3

    Default

    Thanks for this answer.

  5. #5
    Join Date
    Feb 2008
    Posts
    2

    Default

    Quote Originally Posted by MattCasters View Post
    I've got exactly the same problem but I can't dowload your built : the link doesn't work ...

    Another solution ?
    Pi-R
    Rennes - France

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

    Default

    Well someone moved/erased PDI at ftp://download.pentaho.org/client

    Wait till Matt comes around... also the 3.0.2 would be released end of the week or so.

    Regards,
    Sven

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

    Default

    We don't do nightly builds for released software (3.0.1GA in this case).

    As far as the trunk or 3.0.2 is concerned, our new build manager in Orlando is setting up the nightly builds for 2.5.3, 3.0.2 and trunk (3.1.0-M1), probably as we speak.

    You simply have to wait a little bit I guess ;-)

    Matt

  8. #8
    Join Date
    Feb 2008
    Posts
    2

    Default

    Thanks for answers

    So I will wait
    Pi-R
    Rennes - France

  9. #9
    Join Date
    Feb 2008
    Posts
    2

    Default

    Hello,

    Am getting the error while running transformation.
    But am getting this error only when i add calculator step in transformation.

    Error log:
    Transformation was unable to open [tr_HourlyEvent]

    An error occured reading a transformation from the repository

    Unknown column 'ID_STEP_ATTRIBUTE'


    please help me.

    Thanks
    Vira

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

    Default

    Well... are you using 3.0.2 or higher?

    Regards,
    Sven

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.