Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problem while saving transformation changes

  1. #1

    Default Problem while saving transformation changes

    Hi all,
    I'm using PDI 3.0.0GA and usually when I change a transformation and clik on "save" it shows this error message:

    So what could be the problem, in 2.5.0 I had never a problem of this kind!
    I think there are some stuff not yet working well at the repository management level in 3.0.0GA
    1- First I had a problem to open my transformation and this problem was fixed thanks to Matt who send me the link to the new .jar files to put in the lib directory (kettle-engine-3.0.jar, kettle-ui-swt-3.0.jar)
    2- this actual problem: i cant save changes made to my transformations
    3- problem to delete a transformation from the repository: explore repositor---> right clik and delete. The error the following (Couldn't execute SQL: DELETE FROM R_TRANS_PARTITION_SCHEMA WHERE ID_TRANSFORMATION = 13

    Unknown column 'ID_TRANSFORMATION' in 'where clause')

    I think the problem is that the column name or the table name in the generated query to manipulate the Transformation metadata is wrong.

    ID_TRANSFORMATION should be ID_TRANS_PARTITION_SCHEMA
    or
    R_TRANS_PARTITION_SCHEMA should be R_TRANSFORMATION




    Error saving transformation to repository!

    Couldn't execute SQL: DELETE FROM R_TRANS_PARTITION_SCHEMA WHERE ID_TRANSFORMATION = 13

    Unknown column 'ID_TRANSFORMATION' in 'where clause'



    Thanks in advance!
    Sidi.
    Last edited by hammamr; 11-29-2007 at 10:50 AM.

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

    Default

    There is no need to ask the same question over and over.

  3. #3
    Join Date
    Nov 2007
    Posts
    29

    Default

    Sidi,
    I have already post it in the thread "3.0.0.GA: Error with Insert/update". See it.

    Luca

  4. #4

    Default

    Thanks alot guys I just upgraded my repository with the last jars and now it's working well.

    Sidi.

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.