Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Error when spoon writting in the repository

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Error when spoon writting in the repository

    - I've created the repository in a Oracle 9i database.


    - When I want to save a transformation, I receive the error message below. It seems to be a column definition issue.



    - Is repository management reliable enough or should i better use local files ?
    - has repository been tested with Oracle ?
    - do you know if a fix exists to solve this problem?



    Thierry

    <hr />


    Error saving transformation to repository!



    Unable to commit connection after having inserted rows.
    ORA-01461: can bind a LONG value only for insert into a LONG column



    java.lang.reflect.InvocationTargetException: Error saving transformation: be.ibridge.kettle.core.exception.KettleException:
    Error saving transformation to repository!



    Unable to commit connection after having inserted rows.
    ORA-01461: can bind a LONG value only for insert into a LONG column

  2. #2
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Error when spoon writting in the repository

    I have encountered this same issue in Oracle 9i, we elected to store our repositories in postgre. I believe I know the issue, R_TRANSFORMATION stores a number of values as -1 for some transformations, in Oracle the repository creates with definition NUMBER(9,0). The fields won't take a signed value.

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Error when spoon writting in the repository

    Thank you for your reply


    Thierry

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

    Default RE: Error when spoon writting in the repository

    Except that this is not the correct answer of-course.
    Kettle repositories work perfectly fine on Oracle.
    I have knowledge of several sites running perfectly fine on Oracle.

    I suspect there are AGAIN some issues with JDBC drivers and database version mixups. Unfortunately, we will have sweat this one out as the Oracle JDBC drivers are not backward compatible and the old ones not forward compatible.
    In a few months time we will have database connection plugins and this will eliminate this problem.

    BUT, I would be very gratefull if you could send me something more besides this single ORA- line.
    What is the complete stack trace? Perhaps we can find a workaround by simplifying things?
    What&#39;s the version of Kettle used?

    Thanks,
    Matt

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

    Default RE: Error when spoon writting in the repository

    Just for the record, Oracles data type NUMBER(9,0) takes a -1 just fine!
    Don&#39;t want you to get the wrong idea about Oracle ;-)

    Hey, the database is not THAT bad...

    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.