Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Error in Pentaho Kettle Version 3.0.1

  1. #1

    Default Error in Pentaho Kettle Version 3.0.1

    Hi All,

    Transformation which is working in Version 2.5.1 is not working in Version 3.0.1
    Following error is occurring.

    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Because of an error, this step can't continue:
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : offending row : [Member_association_id1 Integer]
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Error setting value #1 [Member_association_id1 Integer] on prepared statement (Integer)
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : org.pentaho.di.core.exception.KettleValueException:
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Unexpected conversion error while converting value [Member_association_id1 Integer] to an Integer
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : java.math.BigDecimal
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Unexpected conversion error while converting value [Member_association_id1 Integer] to an Integer
    2008/01/10 15:47:32 - Existing DB Lookup.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : java.math.BigDecimal

    Please look into it.

    Regards,
    Darius

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

    Default

    You can try the 3.0.2 (nightly update) , I think it was fixed some time ago.

    Regards,
    Sven

  3. #3
    Join Date
    Apr 2007
    Posts
    21

    Default

    Hello Sven,

    where do I get the build of 3.0.2. I have the same Problem on all Oracle Database calls using parameters.

    Many regards
    Volker Wenzel

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

    Default

    Volker, try one of these builds, they should do the trick.

    ftp://download.pentaho.org/client/pe...gration/3.1.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.