English
  • PowerCenter 10.2 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Back Next

Evaluating Error Breakpoints

Evaluating Error Breakpoints

The Integration Service uses the following rules to evaluate error breakpoints:
  • The Integration Service encounters a null input value, and the port contains a user-defined default value of ERROR ( ).
  • The Integration Service encounters an output transformation error, and the port contains the system default value of ERROR ( ). The following errors are considered transformation errors:
    • Data conversion errors, such as passing a string to date
    • Expression evaluation errors, such as dividing by zero
    • Calls to the ERROR function in an expression
  • The Integration Service encounters a null input value or transformation output error, and the port contains a user-defined default value of ABORT ( ).
  • The Integration Service encounters a fatal error.
  • If the Integration Service encounters an error when it processes a transformation, it evaluates error breakpoints for that transformation and global error breakpoints. If any error breakpoint evaluates to true, the Debugger pauses and does not evaluate data breakpoints.
When the Integration Service encounters a fatal error or an ABORT, the Debugger breaks even if it has not reached the configured number of errors to skip.