Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Roll Back on Failed Commit

Roll Back on Failed Commit

When the Integration Service reaches the commit point for all targets in a transaction control unit, it issues commits sequentially for each target. If the commit fails for any target connection group within a transaction control unit, the Integration Service rolls back all data to the last successful commit point. The Integration Service cannot roll back committed transactions, but it does write the transactions to the reject file.
For example, you create a mapping with one transaction control unit and three target connection groups. The target names contain information about the target connection group. TCG1_T1 represents the first target connection group and the first target.
The following figure shows Integration Service behavior when it rolls back on a failed commit:
This mapping contains a multipe output group transformation tc_TransactionControlUnit1, which connects to TCG1_T1, TCG1_T2, TCG1_T3, and TCG1_T4.
The Integration Service uses the following logic when it processes the mapping:
  1. The Integration Service reaches the third commit point for all targets.
  2. It begins to issue commits sequentially for each target.
  3. The Integration Service successfully commits to TCG1_T1 and TCG1_T2.
  4. The commit fails for TCG2_T3.
  5. The Integration Service does not issue a commit for TCG3_T4.
  6. The Integration Service rolls back TCG2_T3 and TCG3_T4 to the second commit point, but it cannot roll back TCG1_T1 and TCG1_T2 to the second commit point because it successfully committed at the third commit point.
  7. The Integration Service writes the rows to the reject file from TCG2_T3 and TCG3_T4. These are the rollback rows associated with the third commit point.
  8. The Integration Service writes the row to the reject file from TCG_T1 and TCG1_T2. These are the commit rows associated with the third commit point.
The following table describes row indicators in the reject file for committed transactions in a failed transaction control unit:
Row Indicator
Description
7
Committed insert
8
Committed update
9
Committed delete


Updated June 03, 2019