Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Data Sets
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Data Type Reference for Hadoop
  22. 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 Data 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\.