Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: recovery from failures

  1. #1
    Join Date
    Sep 2008
    Posts
    3

    Default recovery from failures

    Hi all,
    if the tranformation is runing when for exemplo the energy ends, what happens to this process of transformation ?
    How is the tool behavior to recovery from failures ?
    Thanks.
    Dora.

  2. #2

    Default

    Hi Dora,

    what would you expect?
    If a computer system is powered off the result with Kettle is like every running software. All processes are terminated without cleaning up.
    But if your database supports transactions (most modern databases do, but e.g. MySQLs database engine MyISAM not) your data keeps clean. But you have an uncompleted Datawarehousef if you mean that.

    I think "energy ends" is no failure. In case of failure the transaction is rolled back and the other "failure handling" is left to ETL designer. He/She can run special steps if a job step fails.

    Christoph
    Last edited by christophWeißenborn; 09-22-2008 at 10:42 AM.
    21 is only half the truth

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

    Default

    I have designed ETL processes in the past that would clean up automatically upon the next run of the job.
    It takes some care and consideration, but it's not *that* difficult to do, even without database transactional support.

    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.