Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: roll back if error in processflow execution

  1. #1

    Default roll back if error in processflow execution

    hello everyone,
    i have a doubt that whenever we execute a process flow containing the transformations, if due to a problem any transformation fails then rest transformations don't execute, but rest of transformations executed already populated starts giving result in reporting. so is there any way in which we can hold the transformations populating the data until all the transformations execute successfully? is there any rollback option for other transformation if there is error in the successive?
    please reply me.

  2. #2
    pstoellberger Guest

    Default

    there could be several solutions for this problem:
    1) write all the transformed data into a staging area.. and at the end, when all transformations executed successfully, load it into the target area
    2) define custom error handling for the transformations (e.g all transformations in one job, when this job fails execute custom rollback... like delete all records where insert date = transformation-execution-date)

    there is no built-in commit/rollback functionality in PDI

    -paul

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.