Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Error and Recovery Options

Error and Recovery Options

Configure properties for committing data and error recovery in the
Error and Recovery
fields. The section is minimized by default. The options are populated with default data if available.
The following table describes the error and recovery options:
Error and Recovery Options
Description
Stop on Error
Indicates how many non fatal errors the
PowerCenter Integration Service
encounters before it stops the session. If you enter zero, the session does not stop for non fatal errors. Default is zero.
Suspend on Error
Suspend workflow processing when an error occurs. You can fix errors and then restart the workflow. The default is No.
Rollback Transactions on Error
Rolls back the transaction at the next commit point when it encounters a non fatal write error. The default is Yes.
Recover Strategy
Strategy for recovering a workflow when errors occur.
Choose one of the following recovery strategies:
  • Resume from last checkpoint. The
    PowerCenter Integration Service
    saves the session state of operation and maintains target recovery tables.
  • Restart task. The
    PowerCenter Integration Service
    runs the task again when it recovers the workflow.
  • Fail task and continue workflow. Default. The
    PowerCenter Integration Service
    cannot recover the task, but it continues the workflow.
Enable High Availability Recovery
Select Yes to enable workflow recovery. High availability recovery is not available for web service workflows. The default is No.
Commit Type
Choose a source-based or target-based commit. By default, the
PowerCenter Integration Service
performs a target-based commit.
Commit Interval
The number of rows to process before a commit. Default is 10,000.
Error Log Type
Specifies the type of error log to create. You can specify flat file or none. Default is None.
Error Log File Directory
Required if you enable flat file logging. Specifies the directory where the log file is stored. Default is $PMBadFileDir\.