Execution of a pipeline can stop for any of these reasons:
You click the Cancel button
During the execution of a pipeline, the Execute button in the PainterBar changes to a Cancel button.
The error limit is reached
The Query Governor’s row or elapsed-time limit is reached
If there are rows that cannot be piped to the destination table for some reason, those error rows display once execution stops. You can correct error rows or return to the workspace to change the pipeline definition and then execute it again. For information, see “Correcting pipeline errors”.