Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: transformation in a job

  1. #1
    Join Date
    Sep 2008
    Posts
    12

    Default transformation in a job

    HI,

    I haven't found my problem in the forum.

    I made a transformation csv-->mysql loaded in a job

    If I use a local mysql database all is okay.
    If i use a distant mysql db , rows are not inserted.

    BUT if I execute the transformation (not in a job) all is okay too.

    anyone know why ?

    Olivier

    (joined file : my job + my transformation)

    Thank you
    Attached Files Attached Files

  2. #2

    Default

    Just an idea: What privileges are granted to your user at the remote MySQL server?
    Christoph
    21 is only half the truth

  3. #3
    Join Date
    Sep 2008
    Posts
    12

    Default

    All privileges for the user.
    If I directly execute the transformation, rows are added in my remote mysql database.
    Problem is only when i call the transformation in a job.

    Olivier

  4. #4
    Join Date
    Sep 2007
    Posts
    834

    Default

    hi, Olivier
    The transformation essaipenta.ktr is executed ONLY if the "HTTP 1" Step is succesful.
    Did you checked if the transformation even starts?
    Try changing the evaluation of the hop which reaches the "essaipenta" Step. Or create a new Step like here...
    Attached Images Attached Images   
    Last edited by Maria Roldan; 09-23-2008 at 08:59 AM.

  5. #5

    Default

    Dont' you worry maria, we've got it sorted
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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.