Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Error Reading transofrmation from previous version

  1. #1
    Join Date
    Oct 2007
    Posts
    10

    Default Error Reading transofrmation from previous version

    Hi,

    i have been using v 3.0 (before GA) for creating a set of transformations and jobs.
    Being hit by some of the bugs of 3.0ga, i have been updating to the .jar files which have been posted here.
    No i face the following issue - a couple of the transformations i wrote will not be correctly saved by the 3.0.1 ga version.

    Please try the attached file - is one of said transformations: if you import from xml, save in the repository, and try to load it again from the repository, you will receive the following message:

    An error occured reading a transformation from the repository

    Unknown column 'ID_STEP_ATTRIBUTE'

    Any hint?

    EDIT- the issue will be present both with an updated repository and a totally new repository.
    Attached Files Attached Files

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

    Default

    Works fine for me. Try the 3.0.1 GA version we released today to make sure you upgrade the repository. (it will perform a check at login)

    Matt

  3. #3
    Join Date
    Oct 2007
    Posts
    10

    Default Not working

    Hi Matt,
    thanks for the reply - but it does not work for me - i am using the 3.0.1ga and, as said, i tried both upgrading a repository and creating a new one.

    I use MySQL for repository.

    here is the detailed log:

    2007/12/14 00:11:43 - VGI_Import_Catalog_Item - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : A database error occured reading a transformation from the repository
    2007/12/14 00:11:43 - VGI_Import_Catalog_Item - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    org.pentaho.di.core.exception.KettleValueException:
    2007/12/14 00:11:43 - VGI_Import_Catalog_Item - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Unknown column 'ID_STEP_ATTRIBUTE'
    2007/12/14 00:12:37 - User preferences - Save properties for Spoon...


    the whole exception:

    java.lang.reflect.InvocationTargetException: Error loading transformation
    at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:81)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)
    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495)
    at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:89)
    at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:2946)
    at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:2913)
    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.toolbar.Toolbar.handleMenuEvent(Toolbar.java:92)
    at org.pentaho.xul.swt.toolbar.ToolbarButton.widgetSelected(ToolbarButton.java:53)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    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.KettleException:
    An error occured reading a transformation from the repository

    Unknown column 'ID_STEP_ATTRIBUTE'


    at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2418)
    at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2254)
    at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:77)
    ... 22 more
    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)
    ... 24 more
    Last edited by lucabotti; 12-13-2007 at 07:29 PM.

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

    Default

    Well, check in MySQL if the table R_STEP_ATTRIBUTE has the column ID_STEP_ATTRIBUTE.
    See if you didn't set any weird options in the Database dialog or anything as well.

    Matt

  5. #5
    Join Date
    Oct 2007
    Posts
    10

    Default

    Hi Matt,

    the table structure seems to be correct, also the data is in there. No strange options on MySQL for the repository connection.


    Quote Originally Posted by MattCasters View Post
    Well, check in MySQL if the table R_STEP_ATTRIBUTE has the column ID_STEP_ATTRIBUTE.
    See if you didn't set any weird options in the Database dialog or anything as well.

    Matt

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

    Default

    Bug report at http://jira.pentaho.org/browse/PDI-578 , it's 2.5/3.0 compatibility problem.

    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.