Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Error reading transformation from repository

  1. #1
    Join Date
    May 2006
    Posts
    7

    Default Error reading transformation from repository

    We have a kettle repository that has been created on a database and when I try to open a transformation on this repository, I get the error below:


    A database error occured reading a transformation from the repository



    An error occurred executing SQL in part get metadata?: SELECT ID_STEP, CODE, NR, VALUE_NUM, VALUE_STR FROM R_STEP_ATTRIBUTE WHERE ID_TRANSFORMATION = 10001 ORDER BY ID_STEP, CODE, NR For input string: "4294967295"



    java.lang.reflect.InvocationTargetException: Error loading transformation at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:62) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:447) at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:70) at be.ibridge.kettle.spoon.Spoon.openFile(Spoon.java:2362) at be.ibridge.kettle.spoon.Spoon$40.widgetSelected(Spoon.java:863) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713) at be.ibridge.kettle.spoon.Spoon.readAndDispatch(Spoon.java:472) at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:4486) Caused by: be.ibridge.kettle.core.exception.KettleException: A database error occured reading a transformation from the repository



    An error occurred executing SQL in part get metadata?: SELECT ID_STEP, CODE, NR, VALUE_NUM, VALUE_STR FROM R_STEP_ATTRIBUTE WHERE ID_TRANSFORMATION = 10001 ORDER BY ID_STEP, CODE, NR For input string: "4294967295"






    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:1837) at be.ibridge.kettle.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:58) ... 13 more Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException: An error occurred executing SQL in part get metadata?: SELECT ID_STEP, CODE, NR, VALUE_NUM, VALUE_STR FROM R_STEP_ATTRIBUTE WHERE ID_TRANSFORMATION = 10001 ORDER BY ID_STEP, CODE, NR For input string: "4294967295"



    at be.ibridge.kettle.core.database.Database.openQuery(Database.java:1661) at be.ibridge.kettle.core.database.Database.openQuery(Database.java:1596) at be.ibridge.kettle.core.database.Database.openQuery(Database.java:1590) at be.ibridge.kettle.core.database.Database.getRows(Database.java:3529) at be.ibridge.kettle.core.database.Database.getRows(Database.java:3510) at be.ibridge.kettle.repository.Repository.fillStepAttributesBuffer(Repository.java:301) at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:1779) ... 14 more Caused by: java.lang.NumberFormatException: For input string: "4294967295" at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:303) at be.ibridge.kettle.core.database.Database.getRowInfo(Database.java:2149) at be.ibridge.kettle.core.database.Database.getRowInfo(Database.java:2259) at be.ibridge.kettle.core.database.Database.openQuery(Database.java:1648) ... 20 more



    Thanks,



    Ashish

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

    Default RE: Error reading transformation from repository

    Please be so kind to let us know the version of Kettle you&#39;re using.
    Please be so kind to let us know the database version you&#39;re using (Oracle)
    Please be so kind to let us know the database connection type you&#39;re using (ODBC/JDBC)
    Please be so kind to let us know what platform you&#39;re running on.
    Please be so kind to format your messages in Plain content format next time.

    Ever so grateful,

    Matt

  3. #3
    Join Date
    May 2006
    Posts
    7

    Default RE: Error reading transformation from repository

    Matt,

    Here is the information:

    KETTLE Ver 2.2.2
    ORACLE Ver 10.1.0.4.0
    Database connection type is JDBC
    Windows XP Professional Ver 2002 SP 2

    Thanks,

    Ashish

  4. #4
    Join Date
    May 2006
    Posts
    7

    Default RE: Error reading transformation from repository

    Also, the

    Kettle Spoon Ver is 2.3.0

    Thanks,

    Ashish

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

    Default RE: Error reading transformation from repository

    So, what version of Kettle are you using? 2.3.0 or 2.2.2?

    Thank you very much in advance,

    Matt

  6. #6
    Join Date
    May 2006
    Posts
    7

    Default RE: Error reading transformation from repository

    I have downloaded and installed Kettle 2.2.2.

    Thanks,

    Ashish

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

    Default RE: Error reading transformation from repository

    In that case i have good news for you because this bug was fixed in 2.3.0 ;-)

    Matt

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.